首页 > 技术文章 > Navicat 链接 Sql Server 报错解决

jaycethanks 2020-07-21 13:54 原文

一:

[IM002][Mircrosoft][ODBC驱动程序管理器]未发现数据源名称并且未指定默认驱动程序(0)
缺少对应驱动,在Navicat的安装路径下自带,安装即可:E:\Program Files\PremiumSoft\Navicat Premium 15\sqlncli_x64.msi

二:

[08001][Mircrosoft][SQL Server Native Client 10.0]SQL Server Network Interfaces:Connection string is not valid[87]. (87)
[HYT00][Mircrosoft][SQL Server Native Client 10.0]Login timeout expried(0)
[08001][Mircrosoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing aconnection to SQL Server is not found or not accessible. Check if instance name iscorrect and if SQL Server is configured to allow remote connetcions. For more information see SQL Server Books Online. (87)
登录主机IP和端口之前的连接符号不是冒号,而是逗号

推荐阅读