Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007

    Unanswered: connection failed - ODBC from remote SQL SERVER

    im trying to create an ODBC data source from a SQL SERVER 2005 database located in a remoted pc.
    Client----------->PC1 : win 2000 sp4, not sql server
    Remote server--->PC2 : win 2000 sp4, sql server 2005 express

    From the Command Prompt, im typing "ping PC2" successfully.
    After, in the ODBC datasource administrator-->System DNS tab, i choose "sql server" as a new data source , and in the server box , i'm typing PC2/SQLEXPRESS.

    In the next steps, im typing the user-passwords.
    The error :
    connection failed
    [microsoft][odbc sql server driver][named pipes]ConnectionOpen(CreateFile()).
    Connection failed:
    SQLState: '08001'
    Client unable to establish connection

    What goes wrong?
    I follow the same steps locally, and everything is OK.

    Sorry for my bad english

  2. #2
    Join Date
    Mar 2007
    Holmestrand, Norway
    Here's an article on troubleshooting connectivity issues on SQL Server Express.
    Ole Kristian Velstadbråten Bangås - Virinco - - Facebook - Twitter

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    SQL 2005 does not support the Named Pipes protocol by default. I would choose a different protocol, preferably TCP/IP. You can set the protocol using the Client Configuration button on the second screen of the DSN definition in the ODBC DSN applet.


Posting Permissions

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