问题描述
我有一个在服务器以外执行的应用程序，可以正常运行.客户端尝试连接时，它们会收到以下错误:
I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error:
无法获取数据.*数据提供者无法初始化* SQL Server不存在，或访问被拒绝
Failed to get data.*Data provider could not be initialized*SQL Server does not exist, or access denied
在我的Office Web组件(MDAC)上.我猜有一些安全性或服务器配置错误，但我无法查明.我正在运行SQL Server 2005.
on my Office Web Components (MDAC). I am guessing there is some security or server configuration error, but I'm not able to pinpoint it. I am running SQL Server 2005.
*注意-客户无法更改其安全设置和公司政策.
*Note - clients can't change their security settings, company policy.
推荐答案
在命令提示符下尝试使用此方法:
When you try this from a command prompt:
TELNET服务器名1433
TELNET servername 1433
会发生什么?如果屏幕变黑，则表明SQL Server正在监听，并且客户端设置有问题.如果您收到拒绝访问"或无响应"类型的答案，则很可能是防火墙问题或SQL Server没有监听，但无论哪种情况，都是服务器问题.
What happens? If you get a blank screen, then SQL Server is listening and you've got something wrong in your client settings. If you get an "Access denied" or "no response"-type answer, it's most likely either a firewall issue or SQL Server isn't listening, but in either case, it's a server issue.
这篇关于SQL Server不存在或访问被拒绝错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！