Technical 1 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.


Blog by: Aadi

Comments

Post a Comment

Popular posts from this blog

Flutter-Fire Setup Demo Tutorial with Code

Image
Setup Flutter Fire: Prerequisites: Install Flutter in Android Studio. Create (Setup) Firebase database. Database Structure:  NOTE: Output is attached at end of post. You may change it as per your need.      Step 1: Configure Firebase App CLI for all Platforms. Official Docs:   https://firebase.google.com/docs/flutter/setup Official Youtube Tutorial:  https://www.youtube.com/watch?v=FkFvQ0SaT1I (Run the app once to check installation.) Step 2: Add Essential Dependencies Get all Packages here: https://pub.dev Step 3: Edit pubspec.yaml Add Dependencies. NOTE: Check Version, your version may defer. My pubspec.yaml dependencies : flutter : sdk : flutter firebase_database : ^11.0.3 http : ^1.2.2 # The following adds the Cupertino Icons font # to your application. # Use with the CupertinoIcons class for iOS style icons. cupertino_icons : ^1.0.2 firebase_core : ^3.2.0 Step 3: Code Documentation CRUD from Flutter Fire: https://firebase.google.co...
Read more

Getting Started with Arduino Cloud Trigger

Image
It's not preferred to continuously monitor the value from an IoT Device but rather get precise alerts whenever particular condition gets awake.  We will see how to add Trigger in Arduino Cloud. Hardware Setup: 1. MQ4 (Gas Sensor) 2. ESP32: Connections:  VCC Pin of Gas Sensor -> 3V3 Pin of ESP32 GND Pin of Gas Sensor -> GND pin of ESP32 A0 Pin of Gas Sensor ->  34 Pin of ESP32 (NOTE: ESP32 may vary in Models make sure to install specific Drivers if needed) Generally there are 2 variables supported in Arduino Cloud for Trigger. 1. Boolean Variable 2. String Variable Here we are going to see Email alerts based on Boolean Variable Condition. If you are new to Arduino Cloud please watch this video. If you are familiar to setup and create dashboard you can move further. Step 1: Go to Triggers and click -> create trigger Step 2: Add Trigger Name and click -> Rename Step 3: Click -> Done (We will come back to this page again)  Step 4: Go to -> Things....
Read more