Cannot connect to Microsoft##SSEE database on MS SBS 2008 server

I am in process of moving some components on my Microsoft Small Business Server 2008 and I need to see where any databases for Share Point or WSUS are located and what the sizes are …

  • Go to START > ALL PROGRAMS
  • Click on Microsoft SQL Server 2005
  • Now right click on SQL Server Management Studio Express

Your SQL Server Management Studio Express will launch and you will be presented with a login screen

In the login screen you click on the SERVER NAME and select from drop down menu SERVERMICROSOFT##SSEE, keep Server Type = Database Engine and Authentication = Windows Authentication. I assume you are logged in as the server/domain administrator and click CONNNECT. You will get this error message as on my screenshot.

To correct this issue and successfully log on to your SQL so you can manage the databases for SharePoint or WSUS .. You will need to make this change. On the Server name line you will need to type in this: \.mssql$microsoft##sseesqlquery

The rest such as Server type = Database Engine and Windows Authentication remain same. Once you have typed in the above click CONNECT and you should be now successfully logged on and be able to manage your SQL databases on MS Small Business Server 2008 J