{"id":63,"date":"2025-09-24T11:08:53","date_gmt":"2025-09-24T09:08:53","guid":{"rendered":"https:\/\/paessens.org\/blog\/?p=63"},"modified":"2025-09-24T11:11:37","modified_gmt":"2025-09-24T09:11:37","slug":"import-data-is-greyed-out-in-ssms","status":"publish","type":"post","link":"https:\/\/paessens.org\/blog\/index.php\/2025\/09\/24\/import-data-is-greyed-out-in-ssms\/","title":{"rendered":"Import Data is greyed out in SSMS"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Recently did I update my SQL Server Management Studio from version 19 towards version 21.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Later on I noticed that activities like Import Data, Export Data and Copy Database under Tasks are greyed out.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In order to solve it, must you add <strong>Business Intelligence<\/strong> to your installation of SSMS.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on Windows Icon on your desktop<\/li>\n\n\n\n<li>Click on Settings<\/li>\n\n\n\n<li>Click on Apps<\/li>\n\n\n\n<li>Scroll down towards SQL Server Management Studio 21, click on it<\/li>\n\n\n\n<li>Press Modify<\/li>\n\n\n\n<li>Select Business Intelligence<\/li>\n\n\n\n<li>Press Modify<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Once finished, the options are no longer greyed out.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently did I update my SQL Server Management Studio from version 19 towards version 21. Later on I noticed that activities like Import Data, Export Data and Copy Database under Tasks are greyed out. In order to solve it, must<\/p>\n<p><a href=\"https:\/\/paessens.org\/blog\/index.php\/2025\/09\/24\/import-data-is-greyed-out-in-ssms\/\" class=\"awp-btn awp-btn-secondary awp-btn-bubble\">Continue Reading<span class=\"screen-reader-text\">Import Data is greyed out in SSMS<\/span><i class=\"fa fa-arrow-right\"><\/i><span class=\"bubble_effect\"><span class=\"circle top-left\"><\/span><span class=\"circle top-left\"><\/span><span class=\"circle top-left\"><\/span>\t<span class=\"button effect-button\"><\/span><span class=\"circle bottom-right\"><\/span>\t<span class=\"circle bottom-right\"><\/span><span class=\"circle bottom-right\"><\/span><\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,18],"tags":[19,21],"class_list":["post-63","post","type-post","status-publish","format-standard","hentry","category-ms-sql","category-mssql_general","tag-ms-sql","tag-ssms"],"_links":{"self":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/63","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":3,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"predecessor-version":[{"id":66,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/63\/revisions\/66"}],"wp:attachment":[{"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/paessens.org\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}