Can''t connect in Sql Express on local machine

I have SQL Express running on my laptop but are unable to connect to the default database paulm-laptop\sqlexpress

When I try to connect I get the error message

TITLE: Microsoft SQL Server Management Studio Express
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)

Everything is on my laptop whcih is running Vista Business as an administrator

Any ideas why,

Thanks Paul

Did you enable remote connections for your SQL Server Instance ? If not, have a look at my screencast for more information how to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Since you are on Vista, you should make sure that you are running Managment Studio as Administrator (right click on the shortcut and on Compatibility, choose Run as Administrator) or you can just right click on the shortcut and choose Run as Administrator each time you run it. I have seen this error when running it without it.