久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

客戶端遠程連接到 SQL Server 需要什么?

What does a client need to connect remotely to an SQL Server?(客戶端遠程連接到 SQL Server 需要什么?)
本文介紹了客戶端遠程連接到 SQL Server 需要什么?的處理方法,對大家解決問題具有一定的參考價值,需要的朋友們下面隨著小編來一起學習吧!

問題描述

限時送ChatGPT賬號..

我已在我的家用計算機上設置了 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模板網!

【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題,如果有圖片或者內容侵犯了您的權益,請聯系我們刪除處理,感謝您的支持!

相關文檔推薦

What SQL Server Datatype Should I Use To Store A Byte[](我應該使用什么 SQL Server 數據類型來存儲字節 [])
Interpreting type codes in sys.objects in SQL Server(解釋 SQL Server 中 sys.objects 中的類型代碼)
Typeorm .loadRelationCountAndMap returns zeros(Typeorm .loadRelationCountAndMap 返回零)
MS SQL: Should ISDATE() Return quot;1quot; when Cannot Cast as Date?(MS SQL:ISDATE() 是否應該返回“1?什么時候不能投射為日期?)
Converting the name of a day to its integer representation(將一天的名稱轉換為其整數表示)
How to convert nvarchar m/d/yy to mm/dd/yyyy in SQL Server?(如何在 SQL Server 中將 nvarchar m/d/yy 轉換為 mm/dd/yyyy?)
主站蜘蛛池模板: 一区二区视频 | 午夜一区二区三区在线观看 | 高清久久久| 日韩精品一区二区在线观看 | 日韩视频一区在线观看 | 久久久精 | 久久69精品久久久久久久电影好 | 91av精品| 日韩一级精品视频在线观看 | 成人免费在线视频 | 99re视频在线 | 久久综合伊人一区二区三 | 亚洲精品美女在线观看 | 国产精品一区久久久 | 久久一二 | 瑟瑟视频在线看 | 欧美精产国品一二三区 | 国产精品99一区二区 | av电影一区二区 | 天天影视网天天综合色在线播放 | 国产亚洲精品久久久优势 | av天空| 国产韩国精品一区二区三区 | 国内自拍偷拍视频 | 黄色网址大全在线观看 | 欧美日韩综合视频 | 日日干天天干 | 国产日产精品一区二区三区四区 | a级在线 | 国产精品影视在线观看 | 最新91在线 | 天天看逼 | 五月天国产在线 | 欧美视频在线播放 | 亚洲精品久久久一区二区三区 | 99亚洲精品| 九九亚洲精品 | 人人射人人 | 亚洲一级av毛片 | 一区二区三区在线看 | 日韩成人免费视频 |