November 21, 2018 at 1:16 pm
Hi,
I installed and configured managed instance ,
connection to instance done using VPN
I have no problem accessing Managed instance from SSMS (tested with vpn on several windows boxes)
User running php application on Linux reports that sometime (once every N minutes) SAME query executed by application report error
[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x274C (SQL: select top 1 * from [server1].[table1] where [token] = 6777737b087ccaed03fa80117) in /www/mynet/i123/database/database/Connection.php on line 664
I enabled profiler trace all possible events , but look like request does not reach the server
when query run successfully I see
RPC: completed
declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@P1 nvarchar(4000)',N'select top 1 * from [server1].[table1] where [token] = @P1',N'6777737b087ccaed03fa80117'
select @p1
SP: StmtCompleted
select top 1 * from [server1].[table1] where [token] = @P1
Any suggestion on debugging the problem?
October 1, 2020 at 6:06 pm
hi, could you solve the problem? The same thing happens to me with an application in laravel.
October 1, 2020 at 9:34 pm
Those connection errors could be firewall, could be proxy related...could be a lot of things. In terms of SQL Server, there were some issues with connectivity on Linux and I believe they have been addressed in different updates. So make sure you have applied the latest updates to the SQL Server instance.
Sue
November 23, 2020 at 5:11 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply