A
A
Andrey Panov2015-02-09 20:07:02
Microsoft Azure
Andrey Panov, 2015-02-09 20:07:02

Problems connecting to MsSql 2012 server from a remote computer. Where to dig?

Good afternoon.
There was a problem when moving the server, namely:
When trying to connect from a remote machine, error 121 (semaphore timeout) crashes. Through a sniffer it is visible that requests for the server come. The remote studio logs in on the server, then a request comes to it;

DECLARE @edition sysname; 
SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname); 
select case when @edition = N'SQL Azure' then 2 else 1 end as 'DatabaseEngineType'

It is executed, but the sniffer does not see the response being sent. After that, the cars are thrown with empty packets until the remote connection falls off by timeout.
I forgot to add that in reverse order everything works fine

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Belotserkovsky, 2015-03-03
@PanovAndrey

SQL Azure may limit queries based on its own limits.
Try increasing the size of SQL Azure.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question