Failed to retrieve server version

Question

Post reply

Failed to retrieve server version

Oscar_Boots

Old Hand

Points: 362
More actions
July 18, 2023 at 5:38 am

#4237871

Hi Forum,
I'm trying to set up Visual Studio (VS) 2022 & SQL Server (SS) 2019 to create SSIS, SSRS & SSAS Projects.
I've found that SSIS won't Install in VS if SS is installed, so I've installed VS first, gone to the extensions & installed the SSIS/SSRS & SSAS software.
Then I've installed the SSMS and attached the DWs and all works well in SSMS.
When I try to create anything in VS, I'm getting the 'Failed to retrieve server version' error.
I'm using Windows 11.
Has anyone found an answer?
I can't find one after searching the 'net.
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

Did you install the correct extensions into VS 2022?

There are two copies of each extension now, one for 2019 and one for 2022, so you need to ensure you use the right one

https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices - 2022

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects - 2019

Same also for SSRS / SSAS there is a 2019 and a 2022 version so you need to ensure you have enabled the correct extensions.

Oscar_Boots Old Hand Points: 362 More actions · Answer 2

Thanks Ant-Green,

Ok, to ask a dumb question to clarify, I should install VS (either 2019 or 2022) I then go to manage extensions & download/install the SSIS/RS/AS packages.

I should then install SSMS for the same year as the VS install?

I'll go back & give it a try.

Thanks.

Phil Parkin SSC Guru Points: 246987 More actions · Answer 3

Oscar_Boots wrote:

Thanks Ant-Green,
Ok, to ask a dumb question to clarify, I should install VS (either 2019 or 2022) I then go to manage extensions & download/install the SSIS/RS/AS packages.
I should then install SSMS for the same year as the VS install?
I'll go back & give it a try.
Thanks.

Your SSMS installation should be completely independent of VS.

You are correct about installation order: VS first, followed by the extensions. But based on people's current experiences (eg, link), I'm sticking with 2019 for SSIS/AS/RS dev for now. 2022 seems fine for DB development.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel