問題描述
我已在我的家用計算機上設置了 Microsoft SQL Server 2008 R2 Express.我的家用電腦裝有 Windows 7，并在路由器后面.我配置它我覺得沒問題，因為我可以通過管理工作室從工作中聯系到他.意思是 - 我打開了所有必要的端口，我配置了 SQL 以接受 TCP 上的連接.我也在我的路由器上設置了 DynDNS 并且我通過我的 DNS 名稱連接并且它工作正常.
i have set up a Microsoft SQL Server 2008 R2 Express on my home computer. My home computer has Windows 7 and is behind a router. I configured it i think ok, because i can connect to him from work through management studio. Means - i opened all necessary ports, i configured SQL to accept connections on TCP. I have also on my router set up DynDNS and i connect through my DNS name and it works.
我還使用 Microsoft PortQueryUI [ http://www.microsoft.com/download/en/details.aspx?id=24009 ] 來測試服務器是否可見，從我的工作計算機是否可見.我的 PortQueryUI 工作輸出正常(附上)，但其他網絡的人無法連接到我的服務器.他們在測試端口 1434 UDP(大粗體)時出現錯誤代碼 0x00000002，我認為它是正確的 - 0x00000000.
I use also Microsoft PortQueryUI [ http://www.microsoft.com/download/en/details.aspx?id=24009 ] to test if the server is visible and from my work computer and it is visible. My PortQueryUI output at work is ok (attached bloew) but people from other networks cannot connect to my server.They have in the test to port 1434 UDP (big bold) an error code 0x00000002 where i have it correct - 0x00000000.
這是什么原因，有什么需要在他們的電腦上做的嗎?也許他們的網絡阻止了某些東西?
What is the reason, is there something that needs to be done on their computers? Maybe their network is blocking something?
我的 PortQueryUI 工作輸出:
My PortQueryUI output from work:
=============================================
Starting portqry.exe -n myhome.dyndns.net -e 1434 -p UDP ...
Querying target system called:
myhome.dyndns.net
Attempting to resolve name to IP address...
Name resolved to 83.xxx.xxx.xxx
querying...
UDP port 1434 (ms-sql-m service): LISTENING or FILTERED
Sending SQL Server query to UDP port 1434...
Server's response:
ServerName ROBERT-KOMPUTER
InstanceName SQL2008R2
IsClustered No
Version 10.50.1600.1
tcp 1433
np \\ROBERT-KOMPUTER\pipe\MSSQL$SQL2008R2\sql\query
==== End of SQL Server query response ====
UDP port 1434 is LISTENING
portqry.exe -n myhome.dyndns.net -e 1434 -p UDP exits with return code 0x00000000.
=============================================
Starting portqry.exe -n myhome.dyndns.net -e 1433 -p TCP ...
Querying target system called:
myhome.dyndns.net
Attempting to resolve name to IP address...
Name resolved to 83.xxx.xxx.xxx
querying...
TCP port 1433 (ms-sql-s service): LISTENING
portqry.exe -n myhome.dyndns.net -e 1433 -p TCP exits with return code 0x00000000.
推薦答案
確保端口 1433 在 SQL 所在的防火墻上打開，為了安全起見，您可能也應該在其上設置某種 IP 范圍/范圍.
Make sure port 1433 is open on your firewall where SQL is, you should probably put some sort of IP range/scope on that too for security.
您需要在數據庫屬性中將數據庫設置為接受遠程連接.您需要設置用戶名和密碼并授予其訪問數據庫的權限，以便您的遠程連接能夠識別它.
You need to set your database to Accept Remote Connections in the DB properties.
You need to setup a username and password and give it access to the database so your remote connection recognizes it.
以下是允許連接的示例:
Here's an example of allowing the connection:
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
以下是連接示例:
http://www.youtube.com/watch?v=hT9p_FPt720
這篇關于客戶端遠程連接到 SQL Server 需要什么?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！