Can't connet to MSDE with Query Analyzer

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

  • Next message: Jack: "Performance" 
    Date: Sun, 2 May 2004 16:00:49 -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.

  • Next message: Jack: "Performance"

    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.tools)
    • 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.connect)
    • 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)