When running an application from a SMB Share the SQL connection does not work

M

m4xh

Hello,

when running an application from \\share\share\application.exe the application is not capable of connecting to the SQL Server.

The error message: SQL Error (17): [DBNETLIB][ConnectionOpen (Connect()).] sql server does not exist or access denied


When running the same application from C:\temp\ the connection is working fine.

I can reproduce the problem with a small SQL Management client like "HeidiSQL". The behaviour and error message is the same.


When running netstat -ano | findstr <IPAdressOfSQLServer> i cannot see any connection. Not even a "SYN_SENT".

If I start the appliaction locally I can see the connection to the SQL Server on Port 1433.

The command "Telnet <IPAdressOfSQLServer> 1433" is working as well.


I've already found a User with a similar problem:

Windows 10 - after update 1803 odbc SQL server connect problem

Application run from network share on Windows 10 cannot connect to SQL Server


Apparently KB4284848 should fix the problem: https://support.microsoft.com/en-us/help/4284848/windows-10-update-kb4284848

This fix is only required when using SMB v1. We're already using SMB v3.1.1 (checked with get-smbconnection in Powershell)


We've tried starting the application on an Windows 10 Notebook and Citrix server. On the citrix server we're using

Windows Server 2016

Version 1607

Build 14393.2248


I hope someone can help us with this issue. Thank you


Kind regards

m4xh

Continue reading...
 
Back
Top Bottom