Score:0

SSMS connect server type is grayed out

us flag

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

Score:2
us flag

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.

Roman avatar
us flag
Thanks, but check out the screen shots I added. That is not the case.
Manu avatar
us flag
@Roman: Is this an Express Version of SSMS 11.0? If Yes, this might be the reason you only have the Database Engine option. Can you do a Setup Discovery Report and share the results with us?
Roman avatar
us flag
Not SQL express. Installed with en_sql_server_2012_standard_edition_with_service_pack_4_x64_dvd_100075944.iso
Manu avatar
us flag
@Roman: edited my answer to show you this print screen. Also I'm still positive about my statement, ssms 18 being too new to connect so 10.5/12.0 SSIS
Roman avatar
us flag
Add to features of SSMS installation! I don't know how I missed that. Thanks. That was it.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.