Sqlconnection Error If Exe Is Executed From Network Path

First of all: everything you will read in this post happens only if Windows 10 April 2018 update is installed. No problem before installation and after update uninstallation. Aft

Solution 1:

Finally I found the problem: in the server with the shared folder, SMBv2 is disabled (I don't know why) so only SMBv1 is active; the same program executed from the same client in the same network but located on a server with SMBv2 enabled works fine.

So the problem is about SMBv1 share, deprecated starting from Windows 10 1803

Solution 2:

This blog gives a solution to this, which worked for us. Specifically look at the answer from "M.Hermann": Windows 10 1803 won't run ODBC SQL connected application from network

The below link seems to explain why SMBv1 is disabled: SMBv1 is not installed by default in Windows 10 Fall Creators Update and Windows Server, version 1709 and later versions

I'm not sure why this only seems to be a problem after 1803 though, since SMBv1 has been disabled since 1709.

Solution 3:

I have same problem with some application write in "Rad Studio 10.2"

I find a solution for me, i change my connection string by deleting the parameter "Network Library = dbmssocn"

I change this :

Provider=SQLOLEDB.1;Password=MyPassword;Persist Security Info=True;User ID=MyUser;Initial Catalog=MyDb;Data Source=MyServer;Network Library=dbmssocn;

To this :

Provider=SQLOLEDB.1;Password=MyPassword;Persist Security Info=True;User ID=MyUser;Initial Catalog=MyDb;Data Source=MyServer

Now all work fine !

Solution 4:

You are attempting to execute and untrusted executable (by default for any .exe on a network share). It is therefore restricted in what it can do.

Try right-clicking the exe and doing a 'run as administrator'.

You might also try looking into the local security policy.