Solved

Cannot connect to SQL Server

Posted on 2004-07-30
4
1,771 Views
Last Modified: 2012-06-21
Greetings,

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:

http://support.microsoft.com/default.aspx?kbid=328306

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.
0
Comment
Question by:ysageev
4 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 11680959
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?
0
 
LVL 18

Assisted Solution

by:SjoerdVerweij
SjoerdVerweij earned 250 total points
ID: 11681037
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.
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.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

867 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