Show All

Hide All

Specifying Configuration Database Settings

Microsoft Office SharePoint Portal Server 2003 uses the configuration database to store configuration and site mapping information for the servers in the server farm. There can be only one configuration database for each server farm.

The preferred method for removing a server running SharePoint Portal Server from the server farm is to disconnect the server from the configuration database. If this is not possible (for example, the server is offline), you might need to use the Remove Server button on the Configure Server Topology page. For information about removing servers from the server farm, see Removing a Server from the Server Farm.

Specify configuration database settings

1. On the SharePoint Portal Server Central Administration for server_name page, in the Server Configuration section, click Configure configuration database server.
2. On the Specify Configuration Database Settings for server_name page, in the do one of the following:

   Create the configuration database

   1. In the Database Connections section, click Create configuration database.
   2. In the Configuration Database Server section, in the Database server box, type the name of the computer running Microsoft SQL Server.

      This is the server on which the configuration database is stored.

      Note  If you have a named SQL Server instance, specify both the name of the computer running SQL Server and the SQL Server instance name in the format server_name\SQL_instance_name.

   3. In the Configuration Database Name section, do one of the following:
      • If you want to use the default database name that is displayed, click Use default name.
      • If you want to specify a name for the database, click Specify custom name, and then type a name for the database.
   4. Click OK.

   Connect to an existing configuration database

   1. In the Database Connections section, click Connect to existing configuration database.
   2. In the Configuration Database Server section, in the Database server box, type the name of the computer running Microsoft SQL Server.

      This is the server on which the configuration database is stored.

      Note  If you have a named SQL Server instance, specify both the name of the computer running SQL Server and the SQL Server instance name in the format server_name\SQL_instance_name.

   3. In the Configuration Database Name section, do one of the following:
      • If you want to use the default database name that is displayed, click Use default name.
      • If you want to specify a name for the database, click Specify custom name, and then type a name for the database.
   4. Click OK.

   Disconnect from the configuration database

   Before you disconnect from the configuration database, you must:

   1. Delete any portal sites associated with the server (for example, an index management server would not have any portal sites associated with it). For more information, see Deleting a Portal Site.

      If the server that you want to remove has a SQL Server instance that is used for the content database, component settings database, or profile database for one or more portal sites, you must delete those portal sites before you disconnect.

      If the SQL Server instance is used for the default content database or default component settings database, and the server is not the last server in the server farm to be disconnected, you must change the default content database and default component settings database to a SQL Server instance on another computer. For more information, see Specifying Content Database Settings and Specifying Settings for the Component Settings Database.

      If the server that you want to remove has no SQL Server instance on it, there is no need to delete any portal site.

   2. Remove all component assignments from the server. For more information, see Changing Component Assignments for the Server Farm.
   3. Ensure that the server does not provide Simple Mail Transfer Protocol (SMTP) services globally or to individual virtual servers.

   To disconnect from the configuration database, do the following:

   1. In the Database Connections section, click Disconnect from configuration database.
   2. Click OK.