KB3020402 - FIX: SQL Server 2014 Object Explorer does not display the SQL Azure objects correctly

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use) SQL Server 2014 Web - duplicate (do not use) SQL Server 2014 Business Intelligence - duplicate (do not use)

Symptoms

Assume that you are using Microsoft SQL Server Management Studio 2014 (SSMS 2014). When you deploy a database to an Azure SQL V12 database or you import a data-tier application, the Azure Edition drop-down list in SSMS 2014 lists the Web and Business editions as valid options. These two editions are deprecated and should not be displayed when you connect to an instance of Azure SQL V12.

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 1 for SQL Server 2014 SP1 /en-us/help/3067839

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: