C# console app can't connect to SQL Server when executed from shared folder

Question

I built a C# console app that connects to a SQL Server database. Locally it's working perfectly, but when I publish it to a network shared folder, I get this error:

Unhandled exception. System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

System.ComponentModel.Win32Exception (5): Access denied.

The connection string used :

SqlConnection conn = new SqlConnection("Data Source=frpardb9354;Initial Catalog=" + database_source + ";Integrated Security=SSPI");

I tried using Integrated security=False and hardcoding the user ID and password, it didn't work.

I also verified that connection mode is Windows auth and SQL Server in SSMS, and that the server allows remote connection.

Anybody has an idea of the source of this error?

Without the actual value of database_server_name it is just a guessing game. — Steve
– Steve, Commented Apr 23, 2023 at 16:11
first thing first, from the server that hosts the shared folder ping the My Sql server either with IP or DNS. does it respond ? — jmvcollaborator
– jmvcollaborator, Commented Apr 23, 2023 at 16:11
@jmvcollaborator how to ping from the server that hosts the shared folder please ? i don't have access to that server via remote connection but i have access to the shared folder — chiraz cheikha
– chiraz cheikha, Commented Apr 23, 2023 at 16:30
The following may be helpful: stackoverflow.com/a/71199793/10024425 — It all makes cents
– It all makes cents, Commented Apr 23, 2023 at 16:31
System.ComponentModel.Win32Exception (5): Access denied. seems to be the key here — siggemannen
– siggemannen, Commented Apr 23, 2023 at 19:43

NineBerry · Accepted Answer · 2023-04-23 16:19:51Z

2

According to the error message you use "Named Pipes" to connect to the database server. "Named Pipes" are a mechanism to communicate between processes on one computer. Setup your database connection to use tcp/ip instead und specify a computer name for the connection that is visible from everywhere in the local network.

Also make sure that the SQL Server is configured to allow connections from different computers and enable Firewall exemptions on the computer to allow inbound connections to Microsoft SQL.

edited Apr 23, 2023 at 16:19

answered Apr 23, 2023 at 16:14

NineBerry

28.8k4 gold badges68 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marc Gravell Over a year ago

Named pipes work between machines, no? Microsoft seem to think so... learn.microsoft.com/en-us/windows/win32/ipc/named-pipes

NineBerry Over a year ago

Using named pipes across computers will be blocked by current firewalls. You can't unblock individual named pipes, only all or none. So using them for communication between different computers is not a good idea.

Collectives™ on Stack Overflow

C# console app can't connect to SQL Server when executed from shared folder

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related