Last week I was preparing my pre-con for SQL Server Days.
I was playing around a lot with the new Azure features because that will be a big part of my pre-con.
When I was trying to deploy a database to my Azure VM with the new “Deploy database to Azure VM” wizard,
I noticed that there were a lot of double subscriptions that I could use. This was probably caused by the testing that I have done lately 😉
Adding a subscription is easy but I couldn’t find any way to remove a subscription from the dropdownbox.
As an MVP, you get the privilege to ask questions to other SQL MVP’s and the Microsoft Product Team.
So, I posted this question and got quickly response from a Microsoft SQL Server Program Manager.
The solution is public information, so I’m happy to share it with you.
The references to the subscriptions are stored under the following directory
%USERPROFILE%\Documents\SQL Server Management Studio\Deploy DB to Windows Azure VM
Apparently, that is my active subscription.
To get rid of this active subscription, you need to update the deploymentsettings.xml file in the folder
%USERPROFILE%\AppData\Local\SQL Server\Deploy to SQL in WA VM
When you should open the xml file you will see indeed the subscription.
After removing the deploymentsettings.xml file, I got my “clean” dropdownbox back.
This is something that you won’t need a lot but always good to know!