Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    29

    Unanswered: msde 2000 odbc connection failed

    i have msde 2000 running on a server i am able to create an odbc connection to my db on that pc. when i try to create anpther odbc connection on another pc on that network i get the following error:

    sql state '01000'
    server error 2
    [microsoft][odbc sql server driver][named pipes] connectionopen (connect()).
    connection failed
    sql state '08001'
    server error 17
    [microsoft][odbc sql server driver][named pipes]server does not exist or access denied.

    what do i have to do to get this odbc connection on this pc working?

    Thank You,
    Thomas

  2. #2
    Join Date
    Jul 2004
    Posts
    10
    Have you enabled network protocols? If not try this. Easier to do this by uninstalling and then reinstalling.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, and take help of this KBA http://support.microsoft.com/default...;EN-US;Q328306 to overcome the issue.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •