SQL Server Express - 远程连接继续失败

发布于 2024-11-15 03:14:11 字数 1048 浏览 3 评论 0原文

我无法将 SQL Server 2008 Express 配置为允许远程连接。我按照本指南中的说明进行操作: http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

我仍然收到以下错误:

无法连接到 00.00.00.000

其他信息:

建立与 SQL Server 的连接时发生与网络相关或特定于实例的错误。找不到服务器或无法访问服务器。验证实例名称是否正确以及 SQL Server 是否配置为允许远程连接。

(提供程序:命名管道提供程序,错误 40 - 无法打开与 SQL Server 的连接)(Microsoft SQL Server,错误:3)

我还按照 http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to -sql-server-microsoft-sql-server-error/ 。作为测试,我什至关闭了防火墙,但没有任何变化,所以这不是问题。

更新在服务器名称下,它只写了IP地址。我还需要更多东西吗?

I have been unable to configure my SQL Server 2008 Express to allow remote connections. I followed the instructions from this guide: http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ .

I am still getting the following error:

Cannot connect to 00.00.00.000

Additional information:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

(Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server) ( Microsoft SQL Server, Error: 3)

I also configured the firewall as defined in http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ . As a test I even turned off the firewall, but nothing changed, so it is not the issue.

Update under server name, it only says the IP address. Do I need something more?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

东北女汉子 2024-11-22 03:14:11

在“连接到服务器”的“服务器名称”字段中,我有“myipaddress”。我将其更改为 myipaddress\SQLEXPRESS 并且它有效。

此外,一旦在没有防火墙的情况下工作,我应用了 http://www.sevenforums.com/system-security/58817-remote-access-sql-server-express-2008-windows-7-a.html 以使连接正常工作防火墙已打开。

In the Server name field of Connect to Server, I had myipaddress. I changed it to myipaddress\SQLEXPRESS and it works.

In addition, once this was working without the firewall I applied settings as defined in http://www.sevenforums.com/system-security/58817-remote-access-sql-server-express-2008-windows-7-a.html to make the connection work with the firewall turned on.

怀念你的温柔 2024-11-22 03:14:11

您是否拥有 sqlexpress 的系统管理员权限?您的用户帐户可能没有必要的权限。 codeplex 上有一个脚本,它将添加您作为系统管理员登录的帐户。

Do you have sysadmin rights in sql express? It may be that your user account doesn't have the necessary permissions. There is a script on codeplex that will add you logged on account as a sysadmin.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文