错误：“连接失败：SQLState：在 Microsoft SQL 2008 r 上创建 ODBC 连接时出现‘08001’？2
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/44938273/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Error: "Connection failed: SQLState: '08001' occurs when creating an ODBC connection on Microsoft SQL 2008 r?2
提问by johorjaya er
I have two sql server installed in same server. SQL server 2012 express and SQL server 2008 r2. After we moved to new office, we are not able to connect 2008 server but still able to connect 2012.
我在同一台服务器上安装了两个 sql server。SQL Server 2012 express 和 SQL Server 2008 r2。搬到新办公室后，2008的服务器连不上，2012的还是可以连接的。
I have checked and confirmed that TCP/IP is enabled and the port is 1433 for both server.
我已经检查并确认 TCP/IP 已启用并且两个服务器的端口都是 1433。
SQL browser is also enabled
还启用了 SQL 浏览器
That is no firewall for blocking inbound and outbound from server, however I can't disable end user firewall as the option is being grey out by company IT.
这不是用于阻止来自服务器的入站和出站的防火墙，但是我无法禁用最终用户防火墙，因为该选项已被公司 IT 禁用。
ABC\SQLexpress2012 - working ABC\SQL2008 - doesn't not working
ABC\SQLexpress2012 - 工作 ABC\SQL2008 - 不工作
We managed to login Sql management studio in the machine itself. But both NT authentication and SQL authentication are not working in end user PC.
我们设法在机器本身登录Sql管理工作室。但是 NT 身份验证和 SQL 身份验证都不适用于最终用户 PC。
Any ideas from the experts here ?
这里的专家有什么想法吗？
采纳答案by Sambuu
Change your SQL Server 2008 port
更改 SQL Server 2008 端口
try this one
试试这个
