ODBC connection failures with MS Access
Posted on 2004-09-16
I have a sql (2000) server called Numbers in the network and the ip address of 192.168.0.95. The server instance is called NUMBERS\BKUPEXEC, and thers a database called VIS_PRD that was created earlier this morning.
Im trying to configure one of the client machines to connect to this server via a user and/or system instance created in thier ODBC Data Sources. Couple of things that I notice when I attempt the connection
The server name NUMBERS or NUMBER/BKUPEXEC do not appear as a server option on the server pulldown (as if the ODBC Data Source Administrator) is not able to resolve to it and find it by default
I manually entered the server instance in (NUMBERS/BKUPEXEC) and tried authenticating using both NT and SQL authentication and I keep getting the following error
Connection failed: SQLState: '0100' SQL Server Error:53....ConnectionOpen (CreateFile()) Connection failed..
What could I be doing wrong?
-Frustrated with SQL now