{"id":374,"date":"2013-06-18T23:09:21","date_gmt":"2013-06-18T23:09:21","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=374"},"modified":"2022-02-03T11:25:04","modified_gmt":"2022-02-03T17:25:04","slug":"setting-up-asp-net-and-sql-server-frustrating-windows-security","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/","title":{"rendered":"Setting up ASP.NET and SQL Server &#8211; frustrating windows security"},"content":{"rendered":"<p>Sucking Access files into SQL Server&#8230; Setup steps:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.sqlservercentral.com\/Forums\/Topic1148079-359-1.aspx#bm1149810\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.sqlservercentral.com\/Forums\/Topic1148079-359-1.aspx#bm1149810<\/a><\/li>\n<\/ul>\n<p>Now I am getting the error:\u00a0The database owner SID recorded in the master database differs from the database owner SID recorded in database &#8216;proSteelMtoPartsList&#8217;. You should correct this situation by resetting the owner of database &#8216;proSteelMtoPartsList&#8217; using the ALTER AUTHORIZATION statement.<\/p>\n<p>It COULD be the user- but look around first on your database properties (right mouse click). I followed these links and REALLY messed things up but with some quicky DROP and CREATE TO scripts, I had another one going in no time. DO NOT do the steps in these links unless they WILL help, but they help with understanding and figuring out current settings. I did NOT restore from a backup &#8211; so that is why I should NOT have followed the steps. Never set the owner to sa either unless you have access to that account AND you have taken your account off of the dbo member list.<\/p>\n<ul>\n<li><span style=\"line-height: 15px;\"><a href=\"http:\/\/kevine323.blogspot.ca\/2011\/03\/database-owner-sid-recorded-in-master.html\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/kevine323.blogspot.ca\/2011\/03\/database-owner-sid-recorded-in-master.html<\/a><br \/>\n<\/span><\/li>\n<\/ul>\n<p>This person has some GREAT explanations:<\/p>\n<ul>\n<li><a href=\"http:\/\/mssqlstuff.blogspot.ca\/2012\/01\/solution-for-error-database-owner-sid.html\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/mssqlstuff.blogspot.ca\/2012\/01\/solution-for-error-database-owner-sid.html<\/a><\/li>\n<li><a href=\"https:\/\/www.simple-talk.com\/blogs\/2010\/06\/05\/database-owner-conundrum\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.simple-talk.com\/blogs\/2010\/06\/05\/database-owner-conundrum\/<\/a><\/li>\n<\/ul>\n<p>What it turned out to be is a couple of things &#8211; like the trustworthy &#8211; should have been run and to NOT use the statement in the stored procedure &#8211; however, this DID fix a problem on another database<\/p>\n<ul>\n<li>execute as user=&#8217;DOMAIN\\my.username&#8217; &#8211; which I used for<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Sucking Access files into SQL Server&#8230; Setup steps: http:\/\/www.sqlservercentral.com\/Forums\/Topic1148079-359-1.aspx#bm1149810 Now I am getting the error:\u00a0The database owner SID recorded in the master database differs from the database owner SID recorded in database &#8216;proSteelMtoPartsList&#8217;. You should correct this situation by resetting the owner of database &#8216;proSteelMtoPartsList&#8217; using the ALTER AUTHORIZATION statement. It COULD be the user- [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-374","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Setting up ASP.NET and SQL Server - frustrating windows security - ELB Solutions.com Inc.<\/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:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up ASP.NET and SQL Server - frustrating windows security - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"Sucking Access files into SQL Server&#8230; Setup steps: http:\/\/www.sqlservercentral.com\/Forums\/Topic1148079-359-1.aspx#bm1149810 Now I am getting the error:\u00a0The database owner SID recorded in the master database differs from the database owner SID recorded in database &#8216;proSteelMtoPartsList&#8217;. You should correct this situation by resetting the owner of database &#8216;proSteelMtoPartsList&#8217; using the ALTER AUTHORIZATION statement. It COULD be the user- [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-18T23:09:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:25:04+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"Setting up ASP.NET and SQL Server &#8211; frustrating windows security\",\"datePublished\":\"2013-06-18T23:09:21+00:00\",\"dateModified\":\"2022-02-03T17:25:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/\"},\"wordCount\":255,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/\",\"name\":\"Setting up ASP.NET and SQL Server - frustrating windows security - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2013-06-18T23:09:21+00:00\",\"dateModified\":\"2022-02-03T17:25:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/setting-up-asp-net-and-sql-server-frustrating-windows-security\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up ASP.NET and SQL Server &#8211; frustrating windows security\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting up ASP.NET and SQL Server - frustrating windows security - ELB Solutions.com Inc.","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:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/","og_locale":"en_US","og_type":"article","og_title":"Setting up ASP.NET and SQL Server - frustrating windows security - ELB Solutions.com Inc.","og_description":"Sucking Access files into SQL Server&#8230; Setup steps: http:\/\/www.sqlservercentral.com\/Forums\/Topic1148079-359-1.aspx#bm1149810 Now I am getting the error:\u00a0The database owner SID recorded in the master database differs from the database owner SID recorded in database &#8216;proSteelMtoPartsList&#8217;. You should correct this situation by resetting the owner of database &#8216;proSteelMtoPartsList&#8217; using the ALTER AUTHORIZATION statement. It COULD be the user- [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2013-06-18T23:09:21+00:00","article_modified_time":"2022-02-03T17:25:04+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"Setting up ASP.NET and SQL Server &#8211; frustrating windows security","datePublished":"2013-06-18T23:09:21+00:00","dateModified":"2022-02-03T17:25:04+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/"},"wordCount":255,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/","url":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/","name":"Setting up ASP.NET and SQL Server - frustrating windows security - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2013-06-18T23:09:21+00:00","dateModified":"2022-02-03T17:25:04+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/setting-up-asp-net-and-sql-server-frustrating-windows-security\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"Setting up ASP.NET and SQL Server &#8211; frustrating windows security"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=374"}],"version-history":[{"count":6,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/374\/revisions"}],"predecessor-version":[{"id":2850,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/374\/revisions\/2850"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}