New Database Dialog Box
Use the New Database dialog box to specify the name, location, and password credentials that Commerce Server requires to create a new Data Warehouse database. This dialog box is only accessible from the Database Connection Strings dialog box in Site Packager.
Use this |
To do this |
|---|---|
SQL Server computer |
Type the name of the computer that is running SQL Server. |
Database name |
Type the name that you want for the Data Warehouse database. |
Use Windows Integrated Security |
Click to use Windows NT Integrated Security to manage connection to the computer that is running SQL Server. This option passes the user's credentials to the computer that is running SQL Server. Because of delegation issues, this is practical when the computer that is running SQL Server is on the same computer as Internet Information Services (IIS), and the users are on the same domain as the Web server computer. |
Use a specific user name and password |
Click to pass an explicit user name and password in a connection string to manage the connection to the computer that is running SQL Server. This option is practical if you can prompt the user for credentials, but it can be less secure than other options. |
SQL user name |
Type the user name of the person with logon rights to the computer that is running SQL Server. Use a logon name that is a member of one of the following SQL Server roles: sysadmin or dbcreator. To avoid OLAP errors, do not use the following special characters: /, ?, &, \, <, >, :, |, #, @, %, and ' |
SQL password |
Type the password of the person with logon rights to the computer that is running SQL Server. To avoid OLAP errors, do not use the following special characters: /, ?, &, \, <, >, :, |, #, @, %, and ' |
Create Database |
Click to create the new database on the specified server. |
See Also
Other Resources
How to Change the Administration Database SQL Server Logon and Password
How to Change the Administration Database Connection String