Server不存在或访问被拒绝错误

Server不存在或访问被拒绝错误

本文介绍了SQL Server不存在或访问被拒绝错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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

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

08-04 01:46