What should I do if navicat cannot connect to sqlserver?

What should I do if Navicat cannot connect to the SqlServer database?

1. Cause

I originally installed SqlServer 2008 R2, but later I didn’t need to uninstall it (no cleaning, just uninstall it), and I have been using Navicat since then. Use SqlServer to connect to the server remotely.

After reinstallation, I can connect through the graphical management interface (SqlServer management studio) that comes with SqlServer, but Navicat reports an error when connecting.

Related recommendations: "Navicat for mysql usage graphic tutorial"

reported The error is as shown below:

[08001] [Microsoft][SQL Server Native Client 11.0]Registry information is corrupt or missing. Make sure the provider 
is installed andregistered correctly. (27)
[08001] [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection (27)
[08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while 
establishing a connection to SQL Server.
Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured toallow 
remote connections. For more information see SQL Server Books Online. (0)

The original meaning is "the registry information is damaged and the client cannot establish a connection", etc. However, Navicat has just been reinstalled and the connection to MySQL is normal, so the problem with Navicat is eliminated.

2. Solution

So I began to wonder if there was a problem with the SqlServer installation or it was not cleaned up, so I started to clean up the SqlServer.

(1) First, run the uninstaller, uninstall step by step, and uninstall all SqlServer-related items in the control panel.

After (2), I checked the registry cleaning items of SqlServer and found that there were quite a few.

1.彻底删除SQL Server：
hkey_local_machine/software/Microsoft/MSSQLServer
hkey_local_machine/software/Microsoft/Microsoft SQL Server
hkey_current_user/software/Microsoft/Microsoft SQL Server
hkey_current_user/software/Microsoft/MSSQLServer
hkey_local_machine/system/currentcontrolset/control/sessionmanager/pendingfileren ameoperations 
2.注册表中的相关信息删除：
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer
HKEY_LOCAL_MACHINE/System/CurrentControlSet/Services/MSDTC
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager中找到PendingFileRenameOperations项目
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows/CurrentVersion/setup删除ExceptionComponents 
3、运行注册表,删除如下项：
HKEY_CURRENT_USER/Software/Microsoft/Microsoft SQL Server 
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer

There are some items that are not available, so just ignore them. Just delete some of the registry entries. Be careful not to delete them by mistake!

After deleting, remember to restart and then reinstall. Please refer to https://zhuanlan.zhihu.com/p/35337198

for the installation steps. At this point, the problem should be gone and you can use it correctly. .

The above is the detailed content of What should I do if navicat cannot connect to sqlserver?. For more information, please follow other related articles on the PHP Chinese website!