• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1786
  • Last Modified:

Cannot connect to SQL Server


Earlier this week I was able to create User DSN's and Access ADP's using
MSDE 2000.  Yesterday I started getting the error message "SQL Server does
not exist or access denied".  I don't know why this is happening.  I
uninstalled MSDE and installed the latest SQLExpress 2005 with .net framwork
2.0.   I keep getting the identical message.  I deleted my DSN's as well.

Interestingly, when I try to set up a user dsn it lists my machine 3 times
and "local" twice.  Could this be part of the problem?

I did find the link:


But I'm not sure from this page what the problem is.  Why would SQL Server
just stop working?  I can connect using the SQL Server manager, which says
that SQLEXPRESS is running.

I am very new to SQL server, having more experience in Access.  I think I have a named instance of the database. I am using Windows NT authentication and a trusted connection. I am completely stuck and don't know how to proceed.

Any help would be appreciated.
2 Solutions
SQLExpress is still beta--hope you're not building a production applications....

Have you tried to connect using both the machine name and the IP address?
I had the same problem -- the SQL Express 2005 hosed my tinker machine. Only completely uninstalling it and reinstalling MSDE worked. That might not even be enough for you; you might have to resort to a complete Windows re-install.

When testing Beta software, use a throwaway machine, or VirtualPC.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now