sql_help/Solved_1_network-related-instance-specific-error-SQL-Server at main · A7ryan/sql_help · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Solved:
**A network-related or instance-specific error occurred while establishing a connection to SQL Server**

I personally faced this issue when I wanted to connect my .NET Web Application to the Local Database.

If you are trying to connect your Visual Studio Project with Local Database and getting this error, this is right place for you.

NOTE: This may not be guaranteed solution, I have no idea if this solution exists open source but I tried to solved my error using following steps:

Prerequisites: If you have done any configuration in Visual Studio trying to solve this error, I request you to please uninstall the Visual Studio and reinstall it again.

Even after reinstall you will face same error so try below steps.
(But, It will make default configuration for Visual Studio).

After this, run the Following Commands in the Terminal.
(I personally have not faced any issue (some sort of side effects) after following the steps)


Run the following code in your command prompt:

1) Find the Local DB exists or not: (NOTE: Please copy your LocalDb version)
        sqllocaldb


2) Try to Start SQL Local DB
        sqllocaldb s

Note: If you get error to start (already running), try to stop it (using 3rd step)


3) Stops My Sql Local Db Instance
        sqllocaldb p


4) Now try to delete the instance (please mention your version below)
        Sqllocaldb delete (version_of_instance)
        E.g. sqllocaldb delete 15.0.4153.1


5) Now stop the instance using command (If error continue for next step)
        sqllocaldb p


6) Finally Delete localdb using
        Sqllocaldb delete


7) Create it again using
        Sqllocaldb create

8) Start the service again and it works
        sqllocaldb s


I hope after running following steps, you will be able to connect visual studio projects with your local db.

Again this is not guaranteed but it has helped many of my friends' and wish the same for you.


by: Aadi.7

View it on my blog: https://iotcloudify.blogspot.com/