Execution of .Net Console EXE always fails with below error, this happens only when EXE placed on network drive, from local system it works without any connection error.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).
Any assistance will be appreciated.
The issue found with “missing permission at top directories in path hierarchy”. After providing appropriate permission to top directories, EXE was able to connect SqlServer. It appears that in absence of such permission security policy restricts application to access network resources.