Kbase P150273: Getting ODBC error 08001sql server does not exist. access denied when trying to connect to the SQL s
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/28/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting ODBC error 08001 sql server does not exist. access denied when trying to connect to the SQL server through the MS SQL Server DataServer
08001: [microsoft][ ODBC Sql Server driver][db netlib] sql server does not exist. access denied.
01000: [microsoft][ ODBC Sql Server driver][db netlib]ConnectionOpen (Connect()).
Failed to connect to MSS database. (6142)
FACT(s) (Environment):
Running _probrkr on the DataServer machine
The ABL client is on the Linux machine
MS SQL Server machine is remote to the DataServer machine
The SQL Server ODBC DSN test connection works fine
Changing the ODBC DSN to use from TCP to named pipe, the connection still worked
After changing back the DSN to use TCP again on the SQL Server driver the same error shows up on the DSN
The telnet <server IP> 1433 failed to to establish the connection to the MS SQL Server from the DataServer machine
The netstat -an -P TCP did not list the MS SQL Server default port 1433 on the list as listening
Windows
OpenEdge 10.x
MS SQL DataServer
CAUSE:
The cause is unknown at the time of this writing
FIX:
Restart the MS SQL Server machine to resolve the issue