We are trying to install a Visual Basic application on several computers around our clinic. This program interacts with a database file on a network drive (the connection string is Y:\[file path]). When running the application on certain computers, we run into an error:
Code:
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)
Here is an example of the SQL Server Configuration Manager display on one of the computers running into this error (sorry for the quality):
Name: unnamed.jpg Views: 452 Size: 5.7 KB
As you can (maybe) see, there's nothing under the "SQL Server Network Configuration" dropdown. Is this the issue? Does every computer running the application need to have something like SQL Server 2008 R2 installed (I use this example because it's what was installed on the computer used to develop the application), or is there an easier way to get things working? I know this is probably a ridiculous question, so apologies in advance. Thank you!