Unable to create ODBC Data Source for SQL Server (though am the Administrator)

Hi,

I have a SQL Server database that I am the administrator of - and can access fine through SSMS.  I also used to have an ODBC Data Source set up for this allowing me to import tables into MS Access etc.

For some reason, that DSN became corrupt and prevented connection.  I have deleted it and tried to create another one (as a System DSN) but am getting the following connection error

"Microsoft SQL Server ODBC Driver Version 03.85.1132
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
TESTS FAILED!"

All security is set up to use Windows authentication, both in the DSN and in SSMS.  I'm a) concerned that I can access it through Management Studio but not create a DSN connection when they are both using the same auth model and b) confused as to why this would be when it worked fine until recently.

As additional info I am using XP SP2, SQL Server 2005 and Access 2003 which comes back with a slightly different connection error message: below
---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 233
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Thanks in advance,
LVL 1
GeniusStealsAsked:
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.