Managing Security on the Administration Database

The Administration database connection string uses a Microsoft SQL Server login user name and password.

During Commerce Server installation, Setup prompts you for an existing SQL Server login name and password that Setup uses to create the Administration database on the SQL server or to connect to the database if it already exists.

After the Administration database is created, you can use Microsoft SQL Server Enterprise Manager to change the SQL Server login and password for the Administration database. If you want to use a different SQL Server login to connect to the Administration database from the Commerce Server computer, you must use Commerce Server Manager to change the connection string to the database.

For security purposes, do not use the "sa" login for access to the Administration database. Instead, use SQL Server Enterprise Manager to create a new login and user for the Administration database.

To change the SQL Server login user name and password for the Administration database

  1. Right-click Commerce Server Manager, and then click Properties.

  2. In the Commerce Server Manager Properties dialog box, on the Administration Database tab, click Modify.

    The Data Link Properties dialog box appears.

  3. After making the necessary changes in the Data Link Properties dialog box, click OK.

    Ee785355.note(en-US,CS.20).gif Note

    • For information about how to complete the Data Link Properties dialog box, click Help in the Data Link Properties dialog box to open the Microsoft Data Link Help file.

See Also

Securing Your Site

Copyright © 2005 Microsoft Corporation.
All rights reserved.