Kbase P53022: Can not connect to SQL Server database after SQL Server was backed up and restored
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
SQL Server 2000
Progress 9.1D
SQL Server DataServer
SYMPTOM(s):
Progress 9.1D06
Can not connect to SQL Server
Login was denied because of an authorization error. (6179)
Failed to connect to the MSS Database. (6142).
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test1'. Failed to connect to the MSS database.(6142)
ODBC DSN is configured to use SQL Server authentication with user/password
Can not login into SQL Server with user/password using SQL Server tools
SQL Server user created through SQL Server
SQL Server 2000 Service Pack 3a
Can not change the ODBC DSN configuration so that the SQL Server verifies authenticity via Windows NT authentication
CHANGE:
SQL Server database was backedup and restored through Microsoft tools
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
In SQL Server, delete user/password and recreate the login again.