Can't connet to MSDE with Query Analyzer

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sal Young (salyoung_at_comcast.net)
Date: 05/02/04


Date: Sun, 2 May 2004 16:00:50 -0500

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:

Unable to connec to server SERVERNAME

Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied

I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.



Relevant Pages

  • Cant connet to MSDE with Query Analyzer
    ... I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from ... I'm using a NETGEAR MR314 cable router w/ ... Unable to connec to server SERVERNAME ...
    (microsoft.public.sqlserver.connect)
  • Cant connect to MSDE with Query Analyzer
    ... I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from ... I'm using a NETGEAR MR314 cable router w/ ... Unable to connec to server SERVERNAME ...
    (microsoft.public.sqlserver.clients)
  • Cant connet to MSDE with Query Analyzer
    ... I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from ... I'm using a NETGEAR MR314 cable router w/ ... Unable to connec to server SERVERNAME ...
    (microsoft.public.sqlserver)
  • Cant connet to MSDE with Query Analyzer
    ... I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from ... I'm using a NETGEAR MR314 cable router w/ ... Unable to connec to server SERVERNAME ...
    (microsoft.public.sqlserver.odbc)
  • Re: Roger Wilco Audio Configuration
    ... The cable router network ports serve as my ... The Server Publishing Rule is ... duplicates what the ISA Publishing Rule does except that the "target" of the ...
    (microsoft.public.isa.configuration)