[已解决]无法访问SQL Server 2008 [英] [Solved] SQL Server 2008 is not accessible

问题描述

你好，

我们的远程服务器上有SQL Server.

配置就像:
已启用TCP/IP协议.
从网络服务运行SQL服务.

当我尝试使用正确的用户名和密码从本地框中访问此服务器时，它向我显示未找到实例错误.

但是当尝试ping服务器IP地址时，它看起来不错.

请为我提供解决方案，以消除此问题.

我们在远程计算机上安装了SQL Server 2008，并尝试将其与我的计算机中安装的SQL Server 2008管理连接

Hello ,

We have SQL server on our remote server .

Configuration is like :
TCP/IP protocol is enable.
SQL service runing from network service.

When i tried to access this server from my local box with correct user name and password then it shown me instance not found error.

but when tried to ping the server ip address it looks good .

Please provide me solution to get rid of this.

We have SQL Server 2008 on remote machine and tried to connect that with my SQL server 2008 managment install in my machine

推荐答案

确保将其配置为允许远程

Make sure it''s configured to allow remote access.

也许有涉及防火墙?您可能有权ping它，但是sql server端口可能不在允许的列表中.如果是这样，则可能需要配置防火墙以允许sql服务器端口上的传入连接.

请参阅 http://support.microsoft.com/kb/287932 [

Perhaps there''s a firewall involved? You may have permission to ping it but the sql server port may not be in the allowed list. If so, you may need to configure the firewall to allow incoming connections on the sql server port.

See http://support.microsoft.com/kb/287932[^]

请看一下，可能有一些对您有用的信息.

"SQL Server不存在或访问被拒绝"错误消息的可能原因 [您可能无法连接到配置为使用以下计算机上的TCP/IP服务器网络库的SQL Server实例:运行Windows XP Service Pack 2 [ ^ ]

^ ]

Take alook, may be there is something helpful info for you.

Potential causes of the "SQL Server does not exist or access denied" error message[^]

You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2[^]

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/[^]

这篇关于[已解决]无法访问SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！