HELP - Cannot connect to SQL Server 2005 Express


  • I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express
    But when i load the latter and try to connect to my database I get the below error message.

    TITLE: Connect to Server
    Cannot connect to DEVCOMP\SQLEXPRESS.
    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) (Microsoft SQL Server, Error: -1)
    For help, click:

    Further Details:

    Monday, December 5, 2005 10:28 AM


All replies

  • Further to the above error me, I got the following when I clicked on "Surface Area Configuration for Services and Connections"

    TITLE: Surface Area Configuration for Services and Connections - localhost
    Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
    [C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)

    Monday, December 5, 2005 10:39 AM
  • Check to see if the SQL Server Express service is started.

    Also, you may want to change the network settings to accept TCP/IP and remote connections. Check out this blog entry:

    Let me know if this doesn't fix your problem.

    Monday, December 12, 2005 11:24 PM
  • The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.

    If localhost is not known, then either your hosts. file is corrupt or blocked by a firewall (for any tests, deactivate the local firewall temporarily). You can use instead of localhost.

    The hosts file is located in your windows directory under



    Saturday, December 31, 2005 9:08 PM
  • I have checked out the blog and performed all the steps.  I have restarted the services and still no luck.


    I am a newbie to webdev so started with the sample personal website.  I followed the instructions to the letter but cant get past Ctrl-F5 to initialize without the error.


    Where do I goto from here?


    Friday, January 20, 2006 9:41 PM
  • Make sure that port 1433 is open on the server and the windows xp pcs.

    Saturday, January 12, 2008 10:53 PM