SQL server does not allow remote connections error: 26 - Error Locationg Server/Instance Specified


  • Im using MSSQL 2005 Server Express and today there was installed 4 updates for my operating system. Afterwards i was not able to connect to database anymore.

    The error is that it does not allow to connect to remote connections error 26.

    this is my connection string: conn = new SqlConnection(@"Server=localhost\SQLExpress; Integrated Security=True; Database=SUM_projektet");

    how to solve this problem?

    please be precisly in describing how thx!

    Thursday, May 15, 2008 1:00 PM


  • After couple of hours searching the net:


    the server was somehow disabled???hmmm wierd!

    this was the solution:



    Microsoft SQL Server 2005 -> Configuration Tools -> Configuration Manager



    SQL Server 2005 Services -> SQL Server (SQLEXPRESS) ==> needs to be set to start again


    hope this could help others with same problem

    Thursday, May 15, 2008 2:56 PM