SQL Server 2008 R2 can’t connect to local database in Management Studio

If your instance is called SQLEXPRESS, then you need to use .\SQLEXPRESS or (local)\SQLEXPRESS or yourMachineName\SQLEXPRESS as your server name – if you have a named instance, you need to specify that name of the instance in your server name.

Leave a Comment