By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,459 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,459 IT Pros & Developers. It's quick & easy.

Connection Failed error connecting to MS SQL Server

Seth Schrock
Expert 2.5K+
P: 2,951
I'm trying to add a data source to my computer through the ODBC Data Source wizard. However, I keep getting an error that says
Expand|Select|Wrap|Line Numbers
  1. Connection Failed:
  2. SQLState: '01000'
  3. SQL Server Error: 2
  4. [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
  5. Connection Failed:
  6. SQLState: '08001'
  7. SQL Server Error: 17
  8. [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied
I'm running SQL Server 2005 and today is my first day using it. I know that the server exists, so I'm thinking that the problem is the access denied part. I have created a test database called "Testing" just to see how to connect to it through Access. I'm using Windows Authentication. I added my username to the logins list and gave it every possible server role and mapped the user to the Testing database. I have turned on TCP/IP connections to allow remote PCs to be able to connect to it. At this point, I haven't been able to find anything else to try. This is 100% new to me. Thankfully, my extremely limited knowledge of MySQL has help a little, but not much.
Mar 11 '13 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
After trying anything and everything that I could think of, I discovered the problem. When I was selecting the server, it just listed the host name of the server and didn't include the server instance. So now my SQL Server that I'm connecting to is TESTLAPTOP\SQLEXPRESSTEST instead of just TESTLAPTOP. I'm now able to create the data source just as I want it.
Mar 12 '13 #2

P: 1

Post your reply

Sign in to post your reply or Sign up for a free account.