From MS
www.microsoft.com/mspress/books/sampchap/5000a.asp
SharePoint Portal server and Microsoft SQL Server
If you install SharePoint Portal Server on a computer running SQL Server 7
or SQL Server 2000, SharePoint Portal Server upgrades the existing Microsoft
Search (MSSearch) service. In addition, SharePoint Portal Server upgrades
the full-text index format of all of the existing indexes on that computer
the next time that MSSearch starts. For the upgrade to succeed, there must
be enough disk space on the computer to accommodate 120 percent of the size
of the largest full-text index on the drive. Upgrading the full-text index
format can take several hours, depending on the number and size of the
existing indexes. During the SharePoint Portal Server setup, a message
informs you that the service will be upgraded.
Because SharePoint Portal Server upgrades MSSearch and full-text indexes, do
not install SharePoint Portal Server on a server that participates in a SQL
Server clustering environment or add a computer running SharePoint Portal
Server to a clustered environment.
You can install SQL Server on a computer already running SharePoint Portal
Server. In this instance, SQL Server uses MSSearch installed by SharePoint
Portal Server. If you remove SharePoint Portal Server from a computer that
has SQL Server installed, SharePoint Portal Server will not remove the
upgraded MSSearch because it is a shared service with SQL Server.
The VERY FIRST time I tried installing SPPS, I used a test SQL server and
ran into problems.