C# VS sql project error

Timur Lenk

Hi,

I finished with my Visual Studio C# project. My software use a local database on a network location. I published my project and working fine on my PC. But just on my PC. If I run my exe file (by shortcut) from a different PC I'll receive the following 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: 50 – Local Database Runtime error occurred. The specified LocalDB instance does not exist."

The connection string is:

string connString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=X:\\Jobref\\Jobref.mdf;Integrated Security=True";

I searched on Google and tried few tricks already. Installed SQLLocalDB, changed my string from \\MSSQLLocalDB to \\v11.0 or \\v12.0 but won't work.

I worked on my project a lot and not working now (on my PC only)... That is crazy.

Please help me.

Timur

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Timur Lenk10y ago
Hi,

SQL services are running of course.

Timur
Ankur Mistry10y ago
Hello,

go to the services and start sql server services.
Timur Lenk10y ago
Hi Francis,

I am not sure what is the issue. As I said the program is running fine on my PC.

I do not have SQL Server Management Studio. I used Visual Studio only.

Thanks,

Timur
Francis Susaimichael10y ago
If you are sure the issue is the "connection string" then you need to construct it correct. I have mentioned a simple way in the below blog post:

http://www.aspdotnetchamp.com/2014/12/an-easy-way-to-construct-connection.html

Also check your SQL server is configured to allow the remote connection as well.

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Hope this helps!