Solved

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

Posted on 2008-10-15
1
851 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

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 article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

12 Experts available now in Live!

Get 1:1 Help Now