Specify configuration database settings

1. When Setup finishes, the Configure Admin Virtual Server page appears.
2. In the Application Pool section, select Use an existing application pool or Create a new application pool.
   • If you selected Use an existing application pool, select the application pool to use. You must then restart Internet Information Services (IIS) for the change to take effect.
   • If you selected Create a new application pool, under Application pool name, type a name for the application pool. Under Select a security account for this application pool, select a type, and then enter the required information. You must then restart Internet Information Services (IIS) for the change to take effect.

     Note that if you select Configurable, you must specify an account that is a member of the Security Administrators and Database Creators roles for the Microsoft SQL Server database. It is recommended that you use a dedicated account for this account, rather than a user's logon account, and that you use the same account for each application pool that hosts the same content.

   • Click OK.

   After you configure the administrative virtual server, you must restart IIS by typing iisreset on the command line. After you reset IIS, you can click the link on the Application Pool Changed page to continue configuring Microsoft Windows SharePoint Services.

   Note  To complete this procedure, you must be logged on as a member of the Administrators group on the local computer, or you must be logged on using an account that is both a member of the SharePoint administrators group and that has been granted permissions to administer IIS.

3. After IIS has been restarted, on the Application Pool Changed page, click OK.
4. On the Set Configuration Database Server page, in the Configuration Database section, type the server name and database name to use.
5. Under Database connection type, select Use Windows authentication (recommended security level) or Use SQL authentication (less secure).

6. If you selected Use SQL authentication (less secure), you must also type the database account user name and password.

7. In the Active Directory Account Creation section, select one of the following options:
   • If you are using a Microsoft Windows domain, select Users already have domain accounts. Do not create active directory accounts.
   • If you are using Microsoft Active Directory directory service outside of a Windows domain, select Automatically create active directory accounts for users of this site.

8. If you selected Automatically create active directory accounts for users of this site, you must fill in the Active Directory Domain and Organization Unit information.

9. Click OK.

1. Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration.
2. Under Server Configuration, click Set configuration database server.
3. In the Configuration Database section, type the server name and database name for the existing configuration database.
4. Under Database connection type, select Use Windows integrated authentication (more secure, recommended) or Use SQL authentication (less secure).

5. If you selected Use SQL authentication (less secure), type the database account user name and password.

6. Select the Connect to existing configuration database check box.
7. Click OK.

You use the same operation on the command line to create or connect to a configuration database. The setconfigdb operation allows you to perform either action, depending on the parameters that you include. The setconfigdb operation takes the following required parameters: databaseserver (ds), databaseuser (du), and databasepassword (dp). (Note that the -du and -dp parameters are required only if you are using SQL Server authentication; they are not used with Windows authentication.) In addition, you can use the following optional parameters: connect, databasename (dn), and hh, which specifies that you are in server farm mode.

To create a new configuration database and specify a name for the database, use the following syntax:

stsadm -o setconfigdb -ds <database server> -dn <database name> 
-du <database user> -dp <database user password>

For example, to create a new content database called "config1" at http://mydomain, on the Sql_02 database server, using Windows authentication, type:

stsadm -o setconfigdb -ds mydomain -dn config1

To connect to an existing configuration database, use syntax that is similar to the following:

stsadm -o setconfigdb -connect -ds <database server> 
-dn <database name> -du <database user> 
-dp <database user password>

Note that the -do and -du parameters in the example above are not required when using Windows authentication.