{"id":9219,"date":"2008-10-22T15:27:00","date_gmt":"1999-11-29T20:00:00","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=9219"},"modified":"2008-10-22T15:27:00","modified_gmt":"1999-11-29T20:00:00","slug":"administering-your-windows-internal-database","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=9219","title":{"rendered":"Administering Your Windows Internal Database"},"content":{"rendered":"<div>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.\u00a0 Finding out how to manage the WID proved to be a nightmare until I stumbled upon <a href=\"http:\/\/www.mssqltips.com\/tip.asp?tip=1577\">this<\/a>.\u00a0 Watch out though, it is missing a backslash ( &quot;&quot; ) at the start of the connection string.\u00a0 You&#8217;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.<\/div>\n<div>\u00a0<\/div>\n<div>EDIT: I though I should put this here, at least for my own notes.\u00a0 The correct connection string is &#8230;<\/div>\n<div>\u00a0<\/div>\n<div><a>\\.pipeMSSQL$MICROSOFT##SSEEsqlquery<\/a><\/div>\n<div>\u00a0<\/div>\n<div>&#8230; if you are managing Windows Internal Database using <a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&amp;displaylang=en\">Management Studio Express<\/a>.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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.\u00a0 Finding out how to manage the WID proved to be a nightmare until I stumbled upon this.\u00a0 Watch out though, it is missing a backslash ( &quot;&quot; ) at &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=9219\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Administering Your Windows Internal Database&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[39],"tags":[],"class_list":["post-9219","post","type-post","status-publish","format-standard","hentry","category-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9219"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/9219\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}