SQL Server Performance

[Microsoft][ODBC SQL Server Driver][Named Pipes]

Discussion in 'General DBA Questions' started by aaronsandy, Mar 8, 2005.

  1. aaronsandy New Member

    I am trying to connect to an instance of sql server hosted remotly,by QA.I got the following err.
    Server: Msg 17, Level 16, State 1
    [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.

    SQl server is hosted on Win 2003 server.Pl suggest
  2. Madhivanan Moderator


    Make sure that the remote server is running

    Madhivanan
  3. aaronsandy New Member

    Yes I checked the service manager its running.
  4. Adriaan New Member

    Make sure that the SQL Server which hosts the database has the Named Pipes library activated. Look up the following topic in BOL: Named Pipes, testing and verifying
  5. Hemant_kayadav New Member

    Please check SQL server is listening on TCP or Namepipe.Based on server setting you add client entry on your Client Network Utility. I hope this will help.
  6. aaronsandy New Member

    I have checked all these.When we made a connection on the host server by QA on host server ..its working fine.But when I try to connect remotely I m geting that error buy QA.The application which is using this db is showing a similar error
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied
  7. Adriaan New Member

    Does the remote QA have the same SP level as the host server?
  8. aaronsandy New Member

    Yes both have the SP3 as service packs
  9. Adriaan New Member

    I should have said "the same SP level for SQL Server", but your answer seems to refer to that so no problem.

    And for MDAC?
  10. Argyle New Member

    Can you telnet to the sql port on the server? If not verify network connectivity.

    1.
    On the SQL server verify the port is uses, normally 1433. Write down the IP of the server.

    2.
    On the client open a command prompt and type:
    telnet ip_of_server 1433

    for example:
    telnet 10.1.1.33 1433

    If you get "could not open connection to host" error you have a network issue. Check network settings and firewalls etc. If you can establish a connection you will get a blank screen in the prompt.

    If you can connect by ip but not name:
    telnet my_sql_server_name 1433

    then you have a name resolution issue. Check your DNS or WINS settings or connect to the server by IP (which normally is a bad idea)
  11. aaronsandy New Member

    I followed the process given by u.I got a blank screen by using telnet but still the error is there.pls suggest what should i do now
  12. Argyle New Member

Share This Page