MS Access 2003 Connection Failed: Specified SQL Server not found (ODBC SQL Server Driver)
Posted on 2006-05-12
I have having a strrange issue accessing any of our SQL Server 2000 Databases through MS Access on a couple of machines. I am able to open any databases from my machine, and one of my users has the same computer as me (Windows 2k Professional w/ MS Office 2k3) but she is getting an error message when trying to open a table, report or query. There is also one other PC that i know that cannot log in which has Windows 2k3 Professional and MS Office 2k3.
The Error is as follows:
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Created()).
SQL State: '08001'
SQL Server Error:6
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified server not found.
After this error appears an SQL Login screen Appears?
Can someone please help with this??