November 10, 2003 at 6:33 am
A SQL server was rebuilt from scratch yesterday and then the SQL Server DB was restored from backup.
Now my connect statement from another ODBC compliant DB does not work.
Here is the error I get:
Login was denied because of an authorization error. (6179)
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test1'.
Failed to connect to the MSS database.(6142)
Where do I need to go to fix this?
Darrell
Darrell
November 10, 2003 at 12:46 pm
Darrell:
Without more information, it's difficult to tell you exactly where to fix this. My guess is this: Although you've restored the database from a backup including the list of database users, the SQL Server logins for those users don't exist on the server because it's a fresh install. Use Enterprise Manager to look in the Security section to verify the logins exist.
Once you've verified the existence of the logins (or recreated them), you'll need to use sp_change_users_login to map database users to the SQL Server logins.
Hope this helps...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply