SYSDBA User Fix Script:

When restoring a SalesLogix SQL database backup from one server to another, you must synchronize the database’s sysdba user to the new SQL server’s sysdba user.  If you skip this step, you will not be able to see the new database in Connection Manager and/or you will receive an error: "Connection Failed becuase of an error in initializing the provider.  Cannot open database "your database name" requested by the login. The Login Failed."

The Knowledgebase will provide the following:

Description:

When attempting to create a connection to a new SalesLogix database via Connection Manager, the name of the new database is not listed.

Possible Resolution:

If the database was recently attached or restored, run the sysdba_fix script against the database via SQL Query Analyzer. For information, see How to run the Sysdbafix_script.sql script on a database.

Clicking the how to run link will provide the following:

Description:

How to run the Sysdbafix_script.sql script on a database.

Possible Resolution:

To run the Sysdbafix script against the database:

1. Open SQL Enterprise Manager
2. Open Query Analyzer
3. Select File / Open
4. Browse to the SalesLogix CD(s)
   The sysdba script can be found in different places depending on the CD set you received.
   It can be in the Databases folder or the Upgrade folder.
5. Select the Sysdbafix_script.sql script
6. Execute it against the database

SYSDBA User Fix Script:
Run this script in SQL Server Management Studio/Query Analyzer for the new (or database with a problem) database.

 sp_change_users_login 'Update_One', 'sysdba', 'sysdba'