Connect to WID from SSMS 2012

Try to connect to the WID using SQL Server Management Studio (SSMS). To do this, open SSMS by using right click, “Run as administrator” and in the database server copy/paste

np:\\.\pipe\MICROSOFT##WID\tsql\query

Keep the setting for use Windows Authentication and click connect. It should connect successfully to the WID SQL instance. Then expand Databases and you should see SUSDB. Expand SUSDB and expand Tables and you should be able to see a bunch of tables in the database.

If you get this far, the database server is up and running and the database is online and accessible.

I’ve seen where the database server is accessible, but the database is in a (Recovery) state – which you need to fix first.