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. .gif "Note") Note:
We recommend that you use this option for Commerce Server 2009.
|
SQL Server Authentication |
Select this option to use SQL Server authentication for the Administration database. Note:
There are security risks associated with using SQL Authentication in a Commerce Server 2009 deployment. We do not recommend that you use this option.
|
Login Name |
Note:
This field is only available if you select SQL Server Authentication.
Type the SQL Server logon name for the computer that is running SQL Server. |
Password |
Note:
This field is only available if you select SQL Server Authentication.
Type the SQL Server password for the computer that is running SQL Server. |
Test |
Click to test the connection to the Administration database. Note:
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.
|