SQL Server连接错误 [英] SQL Server connectivity error

问题描述

我在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,

这篇关于SQL Server连接错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！