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

    Question

  • 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

Answers

  • 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