SQL Management Express and Microsoft##SSEE

Download and install Microsoft SQL Server Management Studio Express

Download and install Microsoft SQL Server 2005 Express Edition Toolkit

Configure the built-in SQL instance for remote management by SQL Server Management Studio Express

  1. Open the “SQL server Configuration Manager”
  2. Right-click the line “Protocols for MICROSOFT##SSEE” and choose “Properties”
  3. Set “hide instance” field is set to “no” instead
  4. Under protocols, enable TCP/IP and Named Pipes
  5. Restart the microsoft##ssee service

I found the above steps here.

Access the SQL instance using SQL Server Management Studio Express

  1. Start SQL Server Management Studio Express
  2. Connect to this instance: \.pipeMSSQL$MICROSOFT##SSEEsqlquery
  3. You may need to check Windows Authentication

I found the instance name here.

Now that you have access to the instance you may perform regular tasks to it, such as backing it up, detaching it and so on.

Leave a Reply

Your email address will not be published. Required fields are marked *