Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Can't connect to MSDE (XP Home)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-06 : 20:29:22
Lenny writes "I recently converted to xp home. Previously I was running sql server 7 (MSDE) on Win98 w/o problems.
But now w/ XP cannot connect at all -- not with Enterprise mgr, Access projects, Query mgr, etc..
In all cases, I get the msg, "Connection could not be established - SQL Server does not exist or access
denied".

The server is running (via service manager) -- although I notice in the services test box of the manager,
the service is indicated as "Distributed Transaction Coordinator". I don't recall if that was the indication
when I was running successfully on Win 98.

I'm trying to connect w/ login:sa and blank pw.

The Client Network Utility is set for TCP/IP, multiprotocol and named pipes. Server Network Utility
is set for Shared Memory, multiprotocol and TCP/IP. (Was trying multiple combinations).

Thanks for any help you can provide.

Lenny"
   

- Advertisement -