9. dubna 2012 17:29
I've followed the tutorial here http://msdn.microsoft.com/en-us/hh328536 but I get the following error when connecting from Powershell to the SQL server:
PS D:\Users\Administrator> $sql.Open() Exception calling "Open" with "0" argument(s): "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." At line:1 char:10 + $sql.Open <<<< () + CategoryInfo : NotSpecified: (:) , MethodInvocationException + FullyQualifiedErrorId : DotNetMethodException
I can successfully ping the server by its network name from the Azure role. I have also completely disabled the Windows firewall on the SQL machine to eliminate any interference. There's only one instance of SQL server running on that machine on the default port, 1433. I've enabled TCP/IP and Named Pipes everywhere in the SQL Configuration MMC. I don't know what else to try. Any suggestions?
9. dubna 2012 17:42Ok, I've just noticed that adding "Connect timeout=150" to the connection string fixes the problem. The question is: why is there such a big delay considering that the default timeout is 15 seconds?
- Upravený Clement Cazalot 9. dubna 2012 17:42 Clarity
10. dubna 2012 4:00Thanks to Microsoft Support I was able to fix my problem using these instructions: http://blogs.msdn.com/b/
windows_azure_connect_team_. blog/archive/2011/06/03/ speeding-up-sql-server- connections.aspx
- Označen jako odpověď Clement Cazalot 10. dubna 2012 4:01