Geek Answers Handbook

Scheme comparison time

When comparing schemas in Visual Studio 2013 between Database Project and Azure SQL Database , I continue to receive the following timeout errors:

Error 1 An error was received from SQL Server when trying to reverse engineering elements like Microsoft.Data.Schema.Sql.SchemaModel.ISqlUser: timed out. the timeout period until the expiration date or the server does not respond.

Error 2 ExecuteReader requires an open and accessible connection. The communication current state is closed.

I do this on a Windows Server 2012 R2 virtual machine located in Azure.

  • Port allowed in 1433 firewall
  • Virtual Machine IP Address resolved on SQL Database Server (Azure)

I can simply query the database using Visual Studio SQL Server Object Explorer, so I can be sure of my connection and account.

Are there any other security settings that can give me these problems?

+4
source share
1 answer

You connect to SQL Database Azure if you exceed the database bandwidth limit (DTS). This can easily happen if you are using Azure SQL Database Basic Service.

5 (5 DTU), , , . SQL ( 10 DTU) , .

SQL, . :

http://blogs.msdn.com/b/sqlblog/archive/2014/11/13/timeout-expired-while-publishing-to-sql-database-via-ssdt.aspx

.

+7

More articles:


All Articles