{"id":851,"date":"2022-11-02T12:17:36","date_gmt":"2022-11-02T12:17:36","guid":{"rendered":"http:\/\/markedcode.com\/?p=851"},"modified":"2025-04-07T11:48:52","modified_gmt":"2025-04-07T11:48:52","slug":"ssis-ssms-user-error","status":"publish","type":"post","link":"https:\/\/markedcode.com\/index.php\/2022\/11\/02\/ssis-ssms-user-error\/","title":{"rendered":"SSIS SSMS User Error"},"content":{"rendered":"\n<p>When setting up an SSIS package to run on a schedule in SSMS there is a chance there is an error around which user is running the script. To fix this we will do the following:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to SQL Server Configuration Manager<\/li>\n\n\n\n<li>Update SQL Server Agent to &#8216;Log On As&#8217;:\u00a0 LocalSystem\n<ol class=\"wp-block-list\">\n<li>Note we will need to stop the SQL Server Agent first<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"66\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2022\/11\/Untitled-picture-300x66.png\" alt=\"SQL Server Configuration Manager\" class=\"wp-image-852\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2022\/11\/Untitled-picture-300x66.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/11\/Untitled-picture-1024x226.png 1024w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/11\/Untitled-picture-768x169.png 768w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/11\/Untitled-picture.png 1220w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure><\/div>\n\n\n<p>That\u2019s it &#8211; after this change the scripts should run without any issues!<\/p>\n\n\n\n<p>For more on the SQL Server Configuration Manager: <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-configuration-manager?view=sql-server-ver16\">https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-configuration-manager?view=sql-server-ver16<\/a><\/p>\n\n\n\n<p>Keep reading about D365 tips and tricks here: <a href=\"https:\/\/markedcode.com\/index.php\/category\/d365\/\">https:\/\/markedcode.com\/index.php\/category\/d365\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When setting up an SSIS package to run on a schedule in SSMS there is a chance there is an error around which user is running the script. To fix this we will do the following: That\u2019s it &#8211; after this change the scripts should run without any issues! For more on the SQL Server<\/p>\n","protected":false},"author":1,"featured_media":970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7,20],"tags":[39],"class_list":{"0":"post-851","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-d365","8":"category-ssis","9":"tag-ssms"},"_links":{"self":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/comments?post=851"}],"version-history":[{"count":4,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/851\/revisions"}],"predecessor-version":[{"id":1156,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/851\/revisions\/1156"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media\/970"}],"wp:attachment":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media?parent=851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/categories?post=851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/tags?post=851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}