Solved

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

Posted on 2008-10-15
1
853 Views
Last Modified: 2012-05-05
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
Comment
Question by:GeniusSteals
1 Comment
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 22719662
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now