Network-related or instance-specific errors occur when you establish a connection with SQL Server !, Sqlserver

Network-related or instance-specific errors occur when you establish a connection with SQL Server !, Sqlserver

When I was working on a data center charging system, my database often encountered "network-related or instance-specific errors when establishing a connection with SQL !" The error message is as follows:

After finding a lot of materials, I still solved the problem with the help of my classmates. I would like to express my gratitude for the help I have provided (not to mention my name !) Next, I will give you a solution to this problem, hoping to help you and keep this solution in mind.

 

First, open "manage" on the local computer ",

 

Next, select "services and applications" from the Management menu and select "services"

 

Then find "SQL proxy" in the service"

 

 

Right-click the SQL proxy and choose start. Wait about 30 seconds to complete. Then, your database problem is solved.

My database has always encountered such a problem. I only know why this problem has always been solved, but I still don't know why. I also hope that I can get some suggestions from everyone, you can contact me! I am very grateful.

Network-related or instance-specific error occurs when you establish a connection with SQL Server provider: SQL network interface, error 26

Check whether the password of the local windows Administrator account has been modified
Check whether database users (such as sa) can log on to the database directly.
The local firewall intercepts port 1433.

In my opinion, 3rd is the most likely thing to happen. If the local firewall shields the port number of 1433, the database will be scrapped.


When I watch a video in ACFUN, the network-related or instance-specific error occurs when I establish a connection with SQL Server.

Use this domain name to log on to wenzhou. acfun. TV