C# VS sql project error

Question

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

Timur Lenk · Answer

Hi SQL services are running of course. Timur

Ankur Mistry · Answer

Hello go to the services and start sql server services.

Timur Lenk · Answer

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 · Answer

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!