SQL Server 2014 Management Studio and V12 of SQL Server on Azure
Embed from Getty Images
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!
Shri Bhupathi View All →
Husband, father, and consultant who dabs mostly in Microsoft technologies. Loves tennis – both watching and playing.