首页 > 数据库 >Navicat Premium 连接数据库报错【08001】

Navicat Premium 连接数据库报错【08001】

时间:2023-05-19 14:56:34浏览次数:48  
标签:Premium 11.0 08001 Server Client 报错 SQL Navicat

具体错误如下:

[08001] [Microsoft][SQL Server Native Client 11.0]Reistry information is corrupt or missing. 
     Make sure the provider is installed and registered 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 to allow remote connections. For more information see SQL Server Books Online.(0)

错误原因:

Sql Server 服务被删除

 

解决方法:

  1. 重装Sql Server

  2. 进入Navicat,点击数据库进行编辑======>高级======>Navicat Client 驱动程序,选择【ODBC Driver 17 for SQL Server】

  3. 测试连接======>连接成功(不成功想其他办法)

                Leslie Cheung 随笔

标签:Premium,11.0,08001,Server,Client,报错,SQL,Navicat
From: https://www.cnblogs.com/Leslie-Cheung/p/17415106.html

相关文章

  • github报错“ssh_exchange_identification: Connection closed by remote host fatal:
    解决方式:不确定是否为密钥过期还是C:\Users\John\.ssh文件夹下的config文件中没有添加github的host。总之,所有的尝试如下:(1)重新生成公钥和私钥。打开gitbash,输入以下命令获取自己github的email。gitconfiguser.email 生成ssh私钥和公钥ssh-keygen-trsa-......
  • 关于Nmap扫描时报错:‘utf8’ codec can’t decode byte 0xc1 in position 0:invalid
    Nmap的官方下载地址:https://nmap.org/download.html参考文献:https://blog.csdn.net/weixin_45451139/article/details/105289026https://blog.csdn.net/qq_39855437/article/details/126541352我的用户名是中文,要改用户名。荣耀电脑改不了,而且只有这一个用户。于是我建了一......
  • mysql加密连接报错处理记录
    一、目前mysql的版本更新的特别快了,那么我们在使用的时候出现navicat连接异常的问题了,原因是因为navicat版本过低导致的。具体是因为:mysql8.0.4为了更安全的连接,默认从mysql_native_password改成了caching_sha2_password了。所以导致很多连接工具连接失败了。这样改......
  • edge打开控制台就报错
        不知道怎么瞎点到这个玩意儿了。。。。......
  • vue中pdf预览,报错(Cannot read properties of undefined (reading ‘catch‘))解决
    1、在node_modules中找到vue-pdf,src下的pdfjsWrapper.jsif(pdfRender!==null){if(canceling)return;canceling=true;pdfRender.cancel().catch(function(err){emitEvent('error',err);});return;}修改为if(pdf......
  • 路由导航报错:NavigationDuplicated: Avoided redundant navigation to current locati
    跳转页面时候,重复点击菜单引起路由重复报错;点击按钮跳转到同一个或当前的路径会报错。为每一个Promise添加一个回调函数this.$router.push({name:'Cats',},()=>{})修改VueRouter原型对象上的push/replace方法在router/index.js文件中添加如下代码//获取原型对......
  • Navicat连接本地mysql报错-caching_sha2_password
     查询用户加密方式:selectuser,pluginfromuserwhereuser='root';修改用户加密方式改为mysql_native_password。alteruser'root'@'localhost'identifiedwithmysql_native_passwordby'123123';执行命令flushprivileges使权限配置项立即生效flushp......
  • chatGP问答 - elasticsearch ,这个报错memory locking requested for elasticsearch p
    问:elasticsearch,这个报错memorylockingrequestedforelasticsearchprocessbutmemoryisnotlocked答:是的,我理解你的问题。当你在配置Elasticsearch时,如果遇到"memorylockingrequestedforelasticsearchprocessbutmemoryisnotlocked"错误,这通常表示El......
  • fastapi报错TypeError("'numpy.int64' object is not iterable"解决
     目录1.代码1.1main.py1.2start.sh?bug1------[TypeError("'numpy.int64'objectisnotiterable")bug2------"msg":"valueisnotavaliddict",1.代码1.1main.py?12345678910111213141516171819......
  • 关于Docker报错
    idea连接docker里的mysql镜像时报错:[28000][1045]Accessdeniedforuser'root'@'172.17.0.1'(usingpassword:YES) 解决:命令:dockerexec-itmysql/bin/bash进入mysql:mysql-uroot-proot开启远程访问:ALTERUSER'root'@'%'IDENTIFIED......