[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 875
  • Last Modified:

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,
0
GeniusSteals
Asked:
GeniusSteals
1 Solution

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now