Home / server / Questions / 1067630
Accepted
Roman
Asked: 2021-06-24 14:43:10 +0800 CST

SSMS connect server type is grayed out

  • 772

source: SQL Server 10.50.x
destination: SQL Server 11.x (Not SQL Express. It was installed with en_sql_server_2012_standard_edition_with_service_pack_4_x64_dvd_100075944.iso) I'm afraid I don't know much about modern MS SQL Server. I am trying to migrate from one machine to another and it looks like I need to import the maintenance plan. I found instructions that said to use SQL Server Management Studio to connect to Integration Services and export. I was able to do that from the source server, but on the intended destination server, the connect dialog box has "server type" grayed out. I installed the latest version of SSMS (18) and I was able to get the Integration Services option, but it gave an error "Class Not Registered". Does anyone know how I can make this happen so that I can import those maintenance plans? connect button

Connect Object Explorer

Edit: I just tried to manually create a maintenance plan and got this; so, maybe I need to start over and figure out how to install SQL Server. Something seems very wrong. enter image description here

sql-server

1 Answers

  1. Best Answer

    Server type ist grayed out if you want to start a new connection using the "Connect" button on the left. If you klick on the "cable-symbol" (Connect Object Explorer) you can chose the server type.

    I think this is silly, no idea what the purpose is...

    Regarding the "Class Not Registered" Error, I'm pretty sure your SSMS is "too new" for your Instance. Try the oldest on this List: Previous SSMS releases

    Edit:

    What I meant in the comment was the Management Studio, not the DB Instance. With 2012 (2008r2 maybe too) you had to install Management Tools as Feature. I've found an old 2012 install image and started it up to show you this printscreen: enter image description here Read the Feature description and check if you have installed this feature.

    • 2