Solved

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

Posted on 2008-10-15
1
864 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 22719662
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

719 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