How Do I Connect to the Windows Internal Database (WID)?

Connecting to the Windows Internal Database (WID) can only be done LOCALLY. It cannot be done from a remote machine. This is one of the trade-offs for using WID over SQL Express (but SQL Express carries a hard database size limit where as the WID does not).

Using SQL Server Management Studio

SQL Server Management Studio (SSMS) is by far the easiest way to graphically connect and explore the database server instance.To tell if the WID carries more than the SUSDB database, you’ll need to install SSMS and connect to the WID instance. To do this, open SSMS by using right click, “Run as administrator” and in the database server copy/paste

WID2008

np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

WID2012+

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 and any other databases on this instance.

Share the Post

About the Author