Sunday, February 12, 2012

Can't Connect to Database Engine

I have just installed sql server 2005 Express . The Server is running but I can't connect to the Server in Server Management Studio (on the same machine). I am getting the following message:

TITLE: Connect to Database Engine
----------

Cannot connect to MARION\SQLEXPRESS.

----------
ADDITIONAL INFORMATION:

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)

Any help much appreciatedIt looks like you need to reinstall but I am not an expert, sorry.|||Have you tried connecting specifying server = (local)\SQLEXPRESS?|||

Quote:

Originally Posted by almaz

Have you tried connecting specifying server = (local)\SQLEXPRESS?


Thanks it worked. Saved me hours of head banging

No comments:

Post a Comment