11.15 Microsoft SQL Server and SharePoint Portal Server

---

If you install SharePoint Portal Server on a computer running Microsoft SQL Server 7.0 or SQL Server 2000, SharePoint Portal Server will upgrade the existing MSSearch. In addition, SharePoint Portal Server upgrades the full-text index format of all the existing indexes on that computer the next time 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 Share- Point 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.

---