Administration Database Configuration Page

Use the Administration Database Configuration page to select the type of authentication and credentials to use to access the administration database.

Note

If you select SQL Server Authentication, you must verify that the Login Name and Password you enter are valid. If you select Windows Authentication, you must make sure that your account, the user who is running the Configuration Wizard, has appropriate permissions to access the computer that is running SQL Server. In either case, the user should have administrative rights on the computer that is running SQL Server. In addition, if the Administration database does not already exist on the computer that is running SQL Server, the Wizard will try to create it. In this case, the user running the Configuration Wizard must have "create database" permissions on the computer that is running SQL Server.

Use this

To do this

SQL Server

Type the computer name where the SQL Server software is installed.

Database Name

Accept MSCS_Admin as the default database name, or type a new name for the Administration database.

Windows Authentication

Select this option to use integrated Windows authentication for the Administration database.

Dd442319.alert_note(en-us,CS.95).gifNote:
We recommend that you use this option for Commerce Server 2009 R2.

SQL Server Authentication

Select this option to use SQL Server authentication for the Administration database.

Dd442319.alert_note(en-us,CS.95).gifNote:
There are security risks associated with using SQL Authentication in a Commerce Server 2009 R2 deployment. We do not recommend that you use this option.

Login Name

Type the SQL Server logon name for the computer that is running SQL Server.

Dd442319.alert_note(en-us,CS.95).gifNote:
This field is only available if you select SQL Server Authentication.

Password

Type the SQL Server password for the computer that is running SQL Server.

Dd442319.alert_note(en-us,CS.95).gifNote:
This field is only available if you select SQL Server Authentication.

Test

Click to test the connection to the Administration database.

Dd442319.alert_note(en-us,CS.95).gifNote:
If the test connection fails because the computer that is running SQL Server could not be found, verify that the Server Name is correct and that the computer that is running SQL Server is online.If the test connection fails because of a logon failure, verify that the Login Name and Password are correct and that the SQL Server Authentication account has access to the computer that is running SQL Server. Or, if you have selected Windows Authentication, verify that the user running the Configuration Wizard has the necessary permissions on the computer that is running SQL Server.If an unexpected error occurs, review the log file for more information.

See Also

Other Resources

Managing the Administration Database

Commerce Server Configuration Wizard