{"id":59,"date":"2008-10-21T21:20:00","date_gmt":"2008-10-21T21:20:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/"},"modified":"2008-10-21T21:20:00","modified_gmt":"2008-10-21T21:20:00","slug":"how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/","title":{"rendered":"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005)"},"content":{"rendered":"<div class=\"ExternalClassD3503E5FA60441A297857B098FBAB089\">\n<p>Well this came in handy the other day\u2026<\/p>\n<p>\u00a0<\/p>\n<p>Use this path, to connect to your local SharePoint Windows Internal Database (WID) using SQL Server Management Studio Express (2005), such as in cases where you need to move the databases (say from the default of C: to E:)<\/p>\n<div style=\"border-right:gray\">\n<div style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\">\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:white;border-bottom-style:none\"><span style=\"color:#606060\"> <\/span><a href=\"\/\/\\.pipeMSSQL$MICROSOFT##SSEEsqlquery\">\\.pipeMSSQL$MICROSOFT##SSEEsqlquery<\/a><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>Found this tonight (Feb 2009) and its a little more detailed, so I figured I better provide it as he\/she took the time to provide screenshots \ud83d\ude42<\/p>\n<p><a href=\"http:\/\/www.mssqltips.com\/tip.asp?tip=1577\">http:\/\/www.mssqltips.com\/tip.asp?tip=1577<\/a><\/p>\n<p>&#8220;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well this came in handy the other day\u2026 \u00a0 Use this path, to connect to your local SharePoint Windows Internal Database (WID) using SQL Server Management Studio Express (2005), such as in cases where you need to move the databases (say from the default of C: to E:) \\.pipeMSSQL$MICROSOFT##SSEEsqlquery Found this tonight (Feb 2009) and &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[337,14,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005) - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005) - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Well this came in handy the other day\u2026 \u00a0 Use this path, to connect to your local SharePoint Windows Internal Database (WID) using SQL Server Management Studio Express (2005), such as in cases where you need to move the databases (say from the default of C: to E:) .pipeMSSQL$MICROSOFT##SSEEsqlquery Found this tonight (Feb 2009) and &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-21T21:20:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/\",\"name\":\"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005) - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2008-10-21T21:20:00+00:00\",\"dateModified\":\"2008-10-21T21:20:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005) - Brainlitter - Inside the mind of Sean Wallbridge","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/","og_locale":"en_US","og_type":"article","og_title":"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005) - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Well this came in handy the other day\u2026 \u00a0 Use this path, to connect to your local SharePoint Windows Internal Database (WID) using SQL Server Management Studio Express (2005), such as in cases where you need to move the databases (say from the default of C: to E:) .pipeMSSQL$MICROSOFT##SSEEsqlquery Found this tonight (Feb 2009) and &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2008-10-21T21:20:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/","url":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/","name":"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005) - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2008-10-21T21:20:00+00:00","dateModified":"2008-10-21T21:20:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/21\/how-to-connect-to-a-sharepoint-windows-internal-database-wid-with-sql-management-studio-express-2005\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"How to connect to a SharePoint Windows Internal Database (WID) with SQL Management Studio Express (2005)"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/59"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}