SQL Server不存在或访问被拒绝错误 [英] SQL Server does not exist or access denied error

问题描述

我有一个在服务器以外执行的应用程序，可以正常运行.客户端尝试连接时，它们会收到以下错误:

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不存在或访问被拒绝错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！