Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Question Unanswered: Unable to connect to SQL Server on client with WinForms app


    I have a Visual C# WinForms app which I am accessing a SQL Server 2005 database with. On the Server, I have allowed remote connections (TCP and named pipes) and enable SQL Browser as per instructions on MSDN. The app works fine on the development machine.

    Server name is <machine name>\SQLEXPRESS, connecting with Windows Authentication.
    Server log states that it is listening on [ 'any' <ipv4> 3153].
    Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].

    On the client (local network), when trying to open the database I get this error still:

    An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Also on the client, I can go into the ODBC Data Source Administation, and connect to the SQL Server Database that way successfully.

    What further steps can I take to allow the client to access the SQL Server?


  2. #2
    Join Date
    Nov 2007
    Perhaps windows firewall is preventing the connection. If you can safely (temporarily) turn off firewall on both client and server and retry the connection again.

Posting Permissions

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