SQL Server连接错误

本文介绍了SQL Server连接错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我在SQL Server 2008 R2中恢复了数据库转储，我已建立ODBC连接，测试连接成功。当我尝试从应用程序访问数据库得到以下错误。 连接失败： SQLState：'01000' SQL Server错误：53 （Connect（））。 连接失败： SQLState：'08001' SQL Server错误：17 [Microsoft] [ODBC SQL Server驱动器] [DBNETLIB] SQL Server不存在或访问被拒绝。 请求您帮助解决此问题。 感谢advanace。

I restored DB dump in SQL server 2008 R2, I have established ODBC Connection, Test connection was successful. When i try to access DB from application got the below error. Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Drive][DBNETLIB]SQL Server does not exist or access denied. Request you to help how to solve this problem. Thanks in advanace.

推荐答案

错误信息非常明确：SQL Server没有存在或访问被拒绝。 请查看连接字符串，确定服务器是否正确，然后检查您要连接的用户的用户权限。 The error message is pretty explicit: "SQL Server does not exist or access denied." So look at your connection string, identify if the server is correct, and then check the user permissions for the user you are connecting as.

从Windows 2003到wiund的服务器迁移ows 2008 32 bit-64 bit。从Syswow64文件夹配置ODBC连接解决了这个问题。 谢谢， Hi, It is server migration from windows 2003 to wiundows 2008 32 bit- 64 bit. Configuring ODBC connection from Syswow64 folder solved the problem. Thanks,