Post reply

cant connect to server from another machine

  • February 1, 2006 at 3:20 pm

    #170868

    Hi Friends

    I have a sql server (2005 standard edition) on Win xp machine. i can connect to this server from my machine ok but others on the network try to connect i get following error

     
    "An error has occurred during report processing.

    Cannot create a connection to data source 'dataSource1'.

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) "

     
    but my remote connection allows remote connects. i also enabled "Named pipes" and "VIA" protocols under sql configuration manager but no avail.

    any ideas on this one.

    Thanks for your help.

  • February 3, 2006 at 10:54 am

    #618744

    How are you trying to connect from the other pc's?  ODBC, OLE DB, Query Analyzer, etc.  Could it be that you have the SQL 2005 client installed on your pc and the others don't?  Maybe try installing SQL 2005 connectivity on one of them and see what happens.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply