Administering Your Windows Internal Database

Windows Server 2008 includes the Windows Internal Database, a form of SQL 2005 that can be used for limited roles, e.g. ADAM and WSS 3.0 SP1.  Finding out how to manage the WID proved to be a nightmare until I stumbled upon this.  Watch out though, it is missing a backslash ( "" ) at the start of the connection string.  You’ll use the SQL Express Management Studio and that connection string to get a GUI for managing your databases, e.g. detach the Windows Sharepoint Services 3.0 SP1 databases, move them and reattach them.
 
EDIT: I though I should put this here, at least for my own notes.  The correct connection string is …
 
 
… if you are managing Windows Internal Database using Management Studio Express.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.