无法通过Windows 2012上的系统dsn使用ODBC连接连接到SQL Server 2008 [英] Unable to connect to SQL Server 2008 using ODBC connection via system dsn on windows 2012

问题描述

我有Windows 2012服务器，并且可以通过创建数据连接通过Visual Studio Server Explorer连接到SQL Server 2008实例.我还可以使用SQL Server Management Studio并连接到该SQL Server.但是由于某些原因，当我尝试使用ODBC数据源管理器进行连接以设置DSN时，出现以下错误.

I have Windows 2012 server and I am able to connect to a SQL Server 2008 instance through Visual Studio Server Explorer by creating a data connection. I can also use SQL Server Management Studio and connect to that SQL Server. But for some reason when I try to connect using the ODBC Data Source Administrator to set up a DSN I get the following error.

连接失败:
SQLState:'01000'
SQL错误:1
[Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] ConnectionOpen(SECCreateCredentials()).
连接失败:
SQLState:'08001'
SQL错误:18
[Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] SSL安全错误

Connection Failed:
SQLState: '01000'
SQL Error: 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECCreateCredentials()).
Connection failed:
SQLState: '08001'
SQL Error: 18
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

我似乎找不到任何与此相关的东西，并且想知道是否有人熟悉这个问题.

I can't seem to find anything about this specifically and wondering if anyone out there is familiar with a this problem.

我还要补充一点，即客户端和服务器均不执行加密，因此我会遇到与ssl相关的错误，这使我有些困惑.

I would add that neither the client nor the server enforce encryption so its a little confusing to me that I would be getting an ssl related error.

推荐答案

打开ODBC日志记录后，收到事件消息
创建SSL客户端凭据时发生致命错误.内部错误状态为10013.

After turning on ODBC logging got the event message
A fatal error occurred while creating an SSL client credential. The internal error state is 10013.

这并没有导致我遇到确切的问题，但是确实使我从一个类似的错误中得到了解决.

this didnt lead me to the exact problem but did lead me to the fix from a similar error.

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ SecurityProviders \ SCHANNEL \ Protocols \ TLS 1.0 \ Client \ Enabled必须从0切换到1

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client\ Enabled needed to be flipped from 0 to 1

这篇关于无法通过Windows 2012上的系统dsn使用ODBC连接连接到SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！