24 Sep, 2025
Import Data is greyed out in SSMS
MS SQL, MS SQL General ,

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 you add Business Intelligence to your installation of SSMS.

  1. Click on Windows Icon on your desktop
  2. Click on Settings
  3. Click on Apps
  4. Scroll down towards SQL Server Management Studio 21, click on it
  5. Press Modify
  6. Select Business Intelligence
  7. Press Modify

Once finished, the options are no longer greyed out.