troubleshooting Question

Error connecting adp file to SQL Server 2005 Instance

Avatar of kalliopi
kalliopi asked on
Microsoft AccessMicrosoft SQL Server 2005
13 Comments1 Solution942 ViewsLast Modified:

I have a new SQL Server 2005 Install and can't connect my MS Access 2003 ADP file to it any more.  I've done this in the past without issue, but now it's not working.

There are a couple little things that I'm doing differently this time, one is that when I installed SQL I used a named instance instead of the default.  I can connect without issue to from SQL Server Management Studio using the IP to connect, but from MS Access I try connecting to the <IP> or the <IP>\<the instance> but neither way works.  I get the error: "[DBNETLIB][ConnectionOpen (Invalid Instance()). Invalid Connection."

I'm not sure if the Instance name is the problem, or something else with the Install.  Any suggestions for help would be greatly appreciated!

Chris Mangus
Database Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros