SQL Server 2014 Management Studio and V12 of SQL Server on Azure


 
This is a short and simple post that I hope will help anyone trying to access SQL Server V12 on Azure.

If you have SQL Server 2014 installed and trying to use the Management Studio to view Stored Procedures on a V12 SQL Server database instance on Azure, you may get this error:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ADDITIONAL INFORMATION:
unknown property IsNativelyCompiled (Microsoft.SqlServer.Management.Sdk.Sfc)

The way you fix this is to install SP1 for SQL Server 2014 available for download here. This CU should eliminate this issue.

You can, however, use Visual Studio 2013 without the CU to connect to and work with the V12 version without any issues.

Hope this helps!

Notes from the field

Shri Bhupathi View All →

Husband, father, and consultant who dabs mostly in Microsoft technologies. Loves tennis - both watching and playing.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: