Azure SQL Database
An Azure relational database service.
6,326 questions
What is the output of SELECT @@Version on the two different instances
"An incompatible SQL Server version was detected." New error message in VS/SSDT since an update hit our Managed Instance yesterday.
Thomas Totter
21
Reputation points
VS Version: 2022 and 2019 (with latest SSDT updates).
Since one of our Azure SQL Manages Instances was updated yesterday we cannot access it in Visual Studio anymore.
Error message: "An incompatible SQL Server version was detected."
The managed instances which haven't gotten the update yet still work.
Azure SQL Database
{count} votes
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator2022-03-23T00:17:49.62+00:00 @Thomas Totter Thank you for posting your question on Microsoft Q&A and for using Azure services.
My understanding is that you are unable to access your Managed Instance from visual studio after of the Managed Instance was updated to a different version.
You are able to access to the one which were not updated. Please let me know if my understanding is not correct. I will suggest you create a support ticket for this type of issue.
Please let me know if you don't have a support plan. I will make sure to unable one for you.Regards,
Oury -
Thomas Totter 21 Reputation points
2022-03-23T09:07:04.763+00:00 Your understanding of the situation is 100% correct!
Thanks for the advice regarding ticket. My company (or in that case our customer) will open a support ticket (i requested this internally yesterday already). But since this might take 2-3 days on their side, i just wanted to check if anyone here experiences the same issues and (maybe) found some workaround etc.
If i get some infos on the matter, i'll update here if it's not a specific problem on our side.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
areHH 1 Reputation point2022-03-23T11:41:37.207+00:00 Hi,
We are experiencing the same issues. Both Visual Studio 2019 and 2022.
No issues when connection to SQL Elastic Pool
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2022-03-25T16:59:26.427+00:00 @Thomas Totter , @areHH , anonymous user, @JUMARIE Fabrice , @Butler Jonathan
The Product team is working on this, and we will provide updates regarding this situation on this thread. Soonest is Mid-April.
Thank you for your patienceRegards,
Oury -
Dan Guzman 9,401 Reputation points2022-03-25T17:08:01.657+00:00 Soonest is Mid-April.
Ouch. Can the Product team(s) suggest a viable workaround until the issue is resolved? This is a show-stopper for customers that rely on CI/CD tooling for MI deployments.
-
Butler Jonathan 61 Reputation points2022-03-25T17:10:54.147+00:00 How is that a usable cloud architecture?
Microsoft break our Dev/Test/Prod pipelines and we are meant to wait until sometime in mid-April for the SSDT projects to work again?
Does anyone know if AWS pulls this kind of trick (I wanted to say a lot more there, believe you and me) ?
I am meant to demo this to senior members of our company to show we have an auditable DevOps process, but you've just made it look like amateur-hour at best.
Can you tell me which product team broke our software that we pay good money for?
Thanks
Jonathan
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2022-04-22T17:53:18.623+00:00 **Update on the issue. **
@Thomas Totter
@areHH , anonymous user, @JUMARIE Fabrice , @Butler Jonathan
@Dan GuzmanThe fix for this issue is available in Visual Studio 2022 Preview (Version 17.2.0 Preview 3.0).
As short-term mitigation we suggest customers install Visual Studio 2022 Preview. This version can be installed side-by-side with other versions, and can be downloaded from https://visualstudio.microsoft.com/vs/preview/#download-preview
As a long-term mitigation, once the fix reaches the Visual Studio 2022 GA editions (version 17.2.0 or higher), we suggest customers start using Visual Studio 2022 GA (Community, Professional, Enterprise). There is currently no ETA for this fix to reach Visual Studio 2019.
Note that the use of Visual Studio 2022 Community is permitted for organizations of any size when used for SQL Server Data Tools development (the software license terms is available at https://visualstudio.microsoft.com/license-terms/vs2022-ga-community/).
Visual Studio (GA) can be downloaded from https://visualstudio.microsoft.com/downloads/We apologize for the impact to affected customers. We are continuously taking steps to improve the Microsoft Azure Platform and our processes to help ensure such incidents do not occur in the future
Regards,
Oury
Sign in to comment
8 answers
Sort by: Most helpful
-
ErikEJ 341 Reputation points MVP2022-03-22T18:17:38.573+00:00 -
Thomas Totter 21 Reputation points
2022-03-22T18:22:16.887+00:00 Working Managed Instrance: Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 26 2022 22:23:07 Copyright (C) 2019 Microsoft Corporation
Not-Working Managed Instance: Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 25 2022 16:04:35 Copyright (C) 2021 Microsoft CorporationUpdate seemed to hit us yesterday, as the updated MI was restarted at 00:00.
Sign in to comment -
-
Thomas Totter 21 Reputation points
2022-03-22T18:21:48.167+00:00 Working Managed Instrance: Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 26 2022 22:23:07 Copyright (C) 2019 Microsoft Corporation
Not-Working Managed Instance: Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 25 2022 16:04:35 Copyright (C) 2021 Microsoft CorporationUpdate seemed to hit us yesterday, as the updated MI was restarted at 00:00.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2022-03-23T12:12:41.46+00:00 Hi, Having the same issue when trying to access our "Azure SQL managed instance(s)" from Visual Studio Community 2019 Ed. Error message from Visual Studio when trying to carry out a schema compare. This was working, DataWarehouse: Unable to determine the database platform type. The database may be unavailable. NB: can connect to the "Azure SQL managed instance(s)" from SSMS. ![185999-image.png][1] [1]: /api/attachments/185999-image.png?platform=QnA
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2022-03-25T22:51:46.877+00:00 anonymous user Please file a support ticket and share the ticket number so that we can keep track of it.
Let us know if you don't have a support plan.
Regards,
Oury
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 98%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
JUMARIE Fabrice 1 Reputation point2022-03-23T13:31:34.213+00:00 Hello, I exactly have the same issue.
From Visual Studio 2022, in server explorer, I cannot open a new query when I right-click on one of my database.
I get the error message:An incompatible SQL Server version was detected
I upgraded to Visual studio Professional 2022, Version 17.1.2 with SQL Server Data Tools 17.0.62201.12090, I think it is the latest one.
I cannot query an Azure database running on the version: Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 25 2022 16:04:35 Copyright (C) 2021 Microsoft Corporation
But everything works fine with a database running on the version: Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 26 2022 22:23:07 Copyright (C) 2019 Microsoft Corporation
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2022-03-25T22:31:38.923+00:00 @Butler Jonathan Please kindly create a support ticket and share the support ticket with me so I ca check the progress of the issue. The Product group will offer to roll back the upgrade until the visual studio issue will be fixed.
Regards,
Oury
Sign in to comment -
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2022-03-23T22:13:32.853+00:00 @Thomas Totter , @JUMARIE Fabrice , anonymous user, @areHH
We are working closely with Product Group to fix this issue. Could you please send an email to azcommunity@microsoft.com? with your server name. Please mention in the subject line Attn: Oury "An incompatible SQL Server version was detected." so I don't miss it.
Regards,
Oury-
Thomas Totter 21 Reputation points
2022-03-24T13:31:23.627+00:00 Our customer (who owns the managed instances) already opened a ticket and as far as i know, they are in contact with product group already. But anyway, thank you for your effort, much appreciated!
-
Butler Jonathan 61 Reputation points
2022-03-24T21:38:05.57+00:00 Hi
Is this linked with SSDT Schema Compare no longer working with Managed Instances?
I have raised a support ticket with MS (using Visual Studio Subs); can someone liaise with MI product team and SSDT product and get this fixed as it's broken dev/test/prod pipelines - not good (understatement).
We need an urgent resolution to the problem and processes put in place to prevent these breaking changes in future - there was no notice that VS SSDT would break and we are scrambling around trying to figure out if we can deploy reliably without tooling...a ridiculous proposition and certainly one that would cause terrible problems at audit.
Thanks
Jonathan -
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2022-03-25T22:29:28.157+00:00 @Thomas Totter , @Butler Jonathan Could you please share the ticket number. Our product Group will offer to roll back the upgrade until the Visual studio is fixed.
Regards,
Oury -
Butler Jonathan 61 Reputation points
2022-03-28T08:01:18.063+00:00 Would you like me to email azcommunity@microsoft.com with the Support Number?
Thanks
Jonathan -
Butler Jonathan 61 Reputation points
2022-03-29T12:56:56.217+00:00 Hello
Still not working.
Can you advise what we need to do to get the mitigation implemented?
Thanks
Jonathan
Sign in to comment -