SQL Server Express connection problems

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • EgoSum
    New Member
    • Mar 2007
    • 20

    SQL Server Express connection problems

    I can't connect app to SQLEXPRESS via the local network.
    It works on same PC.

    In SQL Server Configuration Manager > SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS > TCP/IP and Named Pipes - set to Enabled.

    In Server Properties > Security > SQL Server and Windows Authentication mode is set.

    Firewall and antivirus are stopped during tests.

    What else can be cause of this trouble?

    Thanks for any help.
  • kenobewan
    Recognized Expert Specialist
    • Dec 2006
    • 4871

    #2
    Are you getting an error message?

    Comment

    • EgoSum
      New Member
      • Mar 2007
      • 20

      #3
      Thank you for your answer. More precisely:

      Error message:

      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)

      Connection string:

      mConnection = new SqlConnection(@ "data source= computerNameSer ver\sqlexpress; " +
      "database=myDat abase;" +
      "UID=x;PWD=y;") ;

      Comment

      • prabunewindia
        New Member
        • Mar 2007
        • 199

        #4
        hi friend,
        go to programs--> sql server ---->config tools--->
        Sql server 2005 surface area config--->
        Select surface area settings for services and connections-->
        one window will open--->
        in Database engine--> select remote connections--->
        then select --->local and remote in radio button
        u may get the solution
        prabu


        Originally posted by EgoSum
        Thank you for your answer. More precisely:

        Error message:

        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)

        Connection string:

        mConnection = new SqlConnection(@ "data source= computerNameSer ver\sqlexpress; " +
        "database=myDat abase;" +
        "UID=x;PWD=y;") ;

        Comment

        Working...