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.