Login failed for user

You receive the following error message:

Microsoft OLE DB Provider for SQL Server: Login failed for user <user name>.

If you do back up the SQL Server database tables associated with the Profiles resource, and then restore them on a different database on the same SQL Server installation or on a different SQL Server installation, the Profiles resource might not initialize because the connection string(s) to the database tables might not be valid after being restored to the new SQL Server. The connection string(s) might not be valid because either the logon credentials are not valid, or the database is not present on the SQL Server installation, or both.

Ee824018.note(en-US,CS.20).gifNote

  • It is recommended that you do not back up and restore your databases directly. Instead, you should use Commerce Server Site Packager to back up and restore your databases.

Solution

The Profiling System depends on the s_CommerceProviderConnectionString connection string. This connection string is used by the OLE DB Provider for Commerce Server, and is stored within the Commerce Server Administration database. If you restore the Administration database from a database backup, this connection string is often incorrect and must be reset.

To reset the s_CommerceProviderConnectionString connection string

  1. Expand Commerce Server Manager, expand Global Resources, right-click Profiles, and then click Properties.

  2. In the Profiles Properties dialog box, on the Connection Strings tab, select s_CommerceProvideConnectionString, and then click Modify.

  3. In the Data Link Properties dialog box, make the necessary changes, and then click OK.

    Ee824018.note(en-US,CS.20).gifNote

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

Copyright © 2005 Microsoft Corporation.
All rights reserved.