Run time Error in C#

10y1.3kSQL

Pls Give Solution

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: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)

5 Replies

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

Rajeev Punhani10y ago
Hi Ronak,
This error is due to connection string .It seems you are trying to connect thelocaldb database .Either you don't have localdb installed on your system or your db connectionstring is wrong .For SqlServer 2012 you can download from
https://www.microsoft.com/en-us/download/details.aspx?id=29062
For Sql Server 2014 download from
https://www.microsoft.com/en-us/download/details.aspx?id=42299
Connection String is different for both.
For 2012 Data Source=(LocalDB)\v11.0;
For 2014 Data Source=(LocalDB)\MSSQLLocalDB;
You can check the availablelocal db in Sql Server Management Studio.
If the above solution is helpful then,accept the answer.
barathi raja10y ago
Correct code for connection string or database name correct...
Vinay Singh10y ago
Hi
Please check the connection string you have used to connect to the data base. if you have specified the connection in web.config file. you check the connection string format and credential.
<connectionStrings>
<add name="myconnectionstring" connectionString="Data Source=Server;Integrated Security=true;Initial Catalog=DBConnectionStrings"/>

connectionStrings>
Now for retrival
string val = System.Configuration.ConfigurationManager.ConnectionStrings["myconnectionstring"].
ToString();
for detail check the link
Retrieve Connection String From Web.config In ASP.net Using C#.Net (AppSettings,ConnectionStrings)
Ravi Polara Patidar10y ago
Hi,
your problem is Basic.
your Database connection some Time Loss.
your PC to join LAN Then this type of Problem Accured.
Check SQL Configuration Manager Then Run SQL Process.
Karthik Elumalai10y ago
Hi Ronak patel,
I think you might have some problem in the connections string ,because this exception will usally occur when there is error in connection string.
Hope the below two link,will help to resolve your problem.
http://stackoverflow.com/questions/16877770/cant-connect-to-database-from-file
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6367932b-7963-420e-b2bd-8946bde5f917/error-52-when-trying-to-connect-to-sql-server-from-iis-website?forum=sqlsecurity
Kindly let me know your feedback.
Thanks
Karthik