Kbase P104245: Getting error 6179 when trying to launch program that connects to the SQL Server Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/05/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SQL Server DataServer
SYMPTOM(s):
Getting error 6179 when trying to launch program that connects to the SQL Server Database
Getting error 6179 when connecting to SQL Server Database
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test'. Failed to connect to the MSS database.(6142)
Using the SQL Server supplied ODBC Driver for SQL Server 2000
ODBC Data Source Name(DSN) is set to the system tab in the ODBC Admin
User name and the password are supplied with the Schema holder connection parameter in the pf file
The ODBC is trying to use the user who logged on the the Windows machine
CAUSE:
The ODBC DSN is set to NT Authentication
FIX:
Change the ODBC DSN to use SQL Server Authentication