Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSMS - SQL Azure v12 preview - unknown property IsNativelyCompiled

When I try to view stored procedures in a SQL Azure database (V12 preview) in Management Studio (2014) I get the following error.

TITLE: Microsoft SQL Server Management Studio

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------ ADDITIONAL INFORMATION:

unknown property IsNativelyCompiled (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

Since its in preview I guess that it will be fixed, but is there anyone else who have seen this and in that case have any workarounds until its fixed by MS?

EDIT: It works against on-premise 2014 installations so it seems like its only applies for SQLAzure V12.

like image 685
jmw Avatar asked Dec 29 '14 14:12

jmw


People also ask

Can I use SSMS with Azure?

Get started using SQL Server Management Studio (SSMS) to connect to your Azure SQL Database and run some Transact-SQL (T-SQL) commands. The article demonstrates how to follow the below steps: Connect to an Azure SQL database.

How do I connect to Azure SQL Server Visual Studio?

Open your project in Visual Studio. In Solution Explorer, right-click the Connected Services node, and, from the context menu, select Add Connected Service. In the Connected Services tab, select the + icon for Service Dependencies. In the Add Dependency page, select Azure SQL Database.

How do I access Azure SQL managed instance?

Connect with SSMSOn the on-premises client computer, open SQL Server Management Studio. In the Connect to Server dialog box, enter the fully qualified host name for your managed instance in the Server name box. Select SQL Server Authentication, provide your username and password, and then select Connect.


1 Answers

The solution for me was to download the lastest cumulative update to SQL Server from http://sqlserverbuilds.blogspot.com.es/ (CU5 at the time of writing).

like image 144
jmw Avatar answered Oct 13 '22 13:10

jmw