{"id":688,"date":"2011-01-05T13:32:00","date_gmt":"2011-01-05T13:32:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/"},"modified":"2011-01-05T13:32:00","modified_gmt":"2011-01-05T13:32:00","slug":"sql-permissions-and-such-for-sharepoint","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/","title":{"rendered":"SQL Permissions and such for SharePoint"},"content":{"rendered":"<div class=\"ExternalClass79E4914E4A88463DBCE3D823E362AD32\">\n<p>Hey there, <\/p>\n<p>A colleague asked a good question today about SQL and SharePoint, so I thought I&#8217;d share the answer. <\/p>\n<p>\u00a0<\/p>\n<h2>The question was\u2026 <\/h2>\n<p>Why are there so many accounts under SQL Logins related to SharePoint and are these correct? (to paraphrase) <\/p>\n<p>\u00a0<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/010511_2131_SQLPermissi1.png\"> <\/p>\n<p>\u00a0<\/p>\n<h2>The answer is\u2026 <\/h2>\n<p>SharePoint manages these permissions, so long as we implement SharePoint correctly. When we install SharePoint, we make sure that: <\/p>\n<p>\u00a0<\/p>\n<p>The <strong>SharePoint Database Access Account<\/strong> (the Farm account) has the following permissions: <\/p>\n<ul>\n<li>DBCreator <\/li>\n<li>SecurityAdmin <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>The <strong>SharePoint Admin Account<\/strong> (also used for installing) has the following permissions: <\/p>\n<ul>\n<li>DBCreator <\/li>\n<li>SecurityAdmin <\/li>\n<li>SysAdmin (not needed for SharePoint, but needed to access\/manage SQL) <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>So long as we do that, SharePoint manages the rest. Yes, a whole bunch of other accounts will appear as logins in SQL but that is because different accounts need different privileges to do different things. For example, the application pool accounts need different permissions than the accounts used for search, etc. SharePoint will handle this for us, so long as the system itself is configured to allow for that to happen. Occasionally, we need to modify a login to help it along (for example, there is some scenarios with some service applications where the extra logins might need some rights modified, but for the most part, let SharePoint and the &#8216;Managed Accounts&#8217; handle that<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hey there, A colleague asked a good question today about SQL and SharePoint, so I thought I&#8217;d share the answer. \u00a0 The question was\u2026 Why are there so many accounts under SQL Logins related to SharePoint and are these correct? (to paraphrase) \u00a0 \u00a0 The answer is\u2026 SharePoint manages these permissions, so long as we &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/\"><\/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,334,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Permissions and such for SharePoint - 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=\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Permissions and such for SharePoint - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Hey there, A colleague asked a good question today about SQL and SharePoint, so I thought I&#8217;d share the answer. \u00a0 The question was\u2026 Why are there so many accounts under SQL Logins related to SharePoint and are these correct? (to paraphrase) \u00a0 \u00a0 The answer is\u2026 SharePoint manages these permissions, so long as we &hellip;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-05T13:32: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\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/\",\"name\":\"SQL Permissions and such for SharePoint - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2011-01-05T13:32:00+00:00\",\"dateModified\":\"2011-01-05T13:32:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Permissions and such for SharePoint\"}]},{\"@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":"SQL Permissions and such for SharePoint - 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":"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/","og_locale":"en_US","og_type":"article","og_title":"SQL Permissions and such for SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Hey there, A colleague asked a good question today about SQL and SharePoint, so I thought I&#8217;d share the answer. \u00a0 The question was\u2026 Why are there so many accounts under SQL Logins related to SharePoint and are these correct? (to paraphrase) \u00a0 \u00a0 The answer is\u2026 SharePoint manages these permissions, so long as we &hellip;","og_url":"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2011-01-05T13:32:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/","url":"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/","name":"SQL Permissions and such for SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2011-01-05T13:32:00+00:00","dateModified":"2011-01-05T13:32:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2011\/01\/05\/sql-permissions-and-such-for-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"SQL Permissions and such for SharePoint"}]},{"@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\/688"}],"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=688"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/688\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}