远程sql server访问被拒绝 [英] Sql server access denied for remote

问题描述

大家好，



我们在使用Web引用访问应用程序时遇到问题。

Hi All,

We are facing an issue while accessing an application using Web refrence.

Server was unable to process request. ---threw an exception. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. 

我们与团队讨论过此事，他们告诉我这是因为我们的SQL问题。我们试图启用TCP / IP在SQL Server配置工具中，但显示访问被拒绝错误。请帮助解决它。

We discussed this matter with the team,they are telling this is becuase of our SQL Issue.We tried to enable the TCP/IP in SQL Server Configuration Tools,but Access denied error is showing.Please help to resolve it.

推荐答案

确保您还在Windows防火墙中启用了访问权限。 />


打开Windows防火墙的属性，并添加SQL Server服务器安装文件夹中的程序sqlservr.exe和sqlbrowser.exe作为例外。 />


我使用快速版本，这解决了这个问题。

Make sure you have also enabled access in the Windows Firewall.

Open the properties of Windows Firewall and add as exception the programs "sqlservr.exe" and "sqlbrowser.exe" that are in the installation folder of your SQL server.

I use the express version, and this solve the issue.

检查以下注册表子项中指定的协议： br />
HKEY_LOCAL_MACHINE\SOFTWARE \ Microsoft /\\ MSSQLServer \Client\ConnectTo \DSQUERY

此值通常反映CNU中的设置，但有时不反映。



如果值为DBNETLIB，则使用t中的一个他在CNU的启用协议列表中的协议。如果列出了特定协议，则使用该协议。

Check the protocol that is specified in the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERY
This value typically reflects the settings in the CNU, but sometimes it does not.

If the value is DBNETLIB, it uses one of the protocols in the enabled protocols list of the CNU. If a specific protocol is listed, that protocol is used instead.

这篇关于远程sql server访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！