SQL Server 不存在或访问被拒绝错误
我有一个在服务器上执行时运行良好的应用程序。 当客户端尝试连接时，他们会收到以下错误：
无法获取数据。 *数据提供者无法初始化 *SQL Server 不存在，或者
我的 Office Web Components (MDAC) 上的访问被拒绝。 我猜测存在一些安全或服务器配置错误，但我无法查明它。 我正在运行 SQL Server 2005。
*注意 - 客户端无法更改其安全设置、公司策略。
I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error:
Failed to get data.
*Data provider could not be initialized
*SQL Server does not exist, or access denied
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（7）
当您从命令提示符尝试此操作时：
TELNET servername 1433
会发生什么？ 如果您看到空白屏幕，则表明 SQL Server 正在侦听，并且您的客户端设置出现问题。 如果您得到“访问被拒绝”或“无响应”类型的答案，很可能是防火墙问题或 SQL Server 没有侦听，但无论哪种情况，都是服务器问题。
When you try this from a command prompt:
TELNET servername 1433
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 2005 默认情况下禁用网络可访问性，您可能需要启用它
http://msdn.microsoft.com/en-us/library/ms165647(SQL.90).aspx
SQL Server 2005 disables network accessibility by default, you might need to enable it
http://msdn.microsoft.com/en-us/library/ms165647(SQL.90).aspx
您的防火墙设置可能会阻止来自客户端的连接。 如果不是，则可能是 DNS 问题。
Your firewall settings might be preventing connections from your clients. If not, it can be a DNS issue.
最有可能是您的防火墙不允许远程连接的问题？
Most likely an issue with your firewall not allowing remote connections?
如果它在服务器上工作但客户端遇到问题，我认为错误的“访问被拒绝”部分是这里的关键，这是一个身份验证问题。
您使用哪种身份验证来验证您的客户？ 服务器是否使用模拟？ 如果您在 Active Directory 域中运行客户端和服务器，则客户端应用程序（例如 Office 或 Internet Explorer）可能会将凭据传递到服务器，服务器使用该凭据对数据库进行身份验证。
If it's working from the server but clients are having problems, I think the "access denied" part of the error is the key here and it's an authentication problem.
What sort of authentication are you using to authenticate your clients? Is the server using impersonation? If you're running clients and server in an active directory domain, the client application (Office or Internet Explorer for example) might be passing credentials to the server which the server is using to authenticate to the database.
为了能够从网络计算机连接 SQL Server，需要在服务器上为 TCP 流量打开端口 1433。 此外，如果您有命名实例，您应该检查它正在侦听的端口，因为它可能与默认端口不同，并且可能需要打开。 您还必须为 UDP 打开端口 1434 以支持 SQL Browser 服务
For SQL Server to be contactable from a network machine it requires port 1433 to be open on the server for TCP traffic. Additionally, if you have a named instance you should check the port it is listening on as it may be different to the the default and will probably need to be opened. You will also have to open up port 1434 for UDP to support the SQL Browser Service
防火墙问题。 禁用防火墙，再次运行实例
firewall issue. diable firewall, run instance again