The Netgear Wireless Router has a secured Wireless Network Connection thiết đặt already. Its SSID is NETGEAR44.
Bạn đang xem: Hướng dẫn xử lý lỗi khi thông tin cấu hình kết nối database không chính xác
The desktop PC"s name is Srh-PC. Its operating system is Windows 7 Professional Service Pack 1 64-bit. It has Microsoft SQL vps 2008 R2 database hệ thống installed. It is connected lớn NETGEAR44 as wireless for internet.
The laptop"s name is Srh-HP. Its operating system is Windows 7 Professional Service Pack 1 64-bit. It has Microsoft SQL vps client tools installed. It is connected lớn NETGEAR44 as wireless for internet.
On my máy tính I want to mở cửa SQL hệ thống Management Studio and then connect to lớn database vps of my desktop PC. How can I bởi vì that? I am not strong in networking so any tutorial pointer will help.
windows-7 networking wireless-networking router sql-server
cốt truyện
Improve this question
Follow
asked Dec 27, 2017 at 2:11

srhsrh
26966 silver badges1212 bronze badges
4
địa chỉ a bình luận |
1 Answer 1
Active Oldest Score
1
Per some notes I have saved from a while back on a vps with applicable specs, I figured why note throw in an answer và make into some helpful steps to lớn simplify this task.
Run All Commands on the SQL server instance OS
Important: Be sure to run all elevated as administrator from command prompt.
Xem thêm: Bài Văn Thuyết Minh Về Con Mèo Có Sử Dụng Biện Pháp Nghệ Thuật
Find/Confirm Listening TCP Port for the SQL server Instance
USE
From Elevated Command Prompt
Allow inbound TCP connections to the confirmed SQL port
netsh advfirewall firewall showroom rule name="Name of rule/description inbound/outbound on TCP " dir=in action=allow protocol=TCP localport=#### profile=domainAllow Remote Access via SSMS Database Connection
Manually demo from all subnets in case you need to adjust the network scope of the rules. Ensure the C:Program Files~ path is correct for your environment as well as the profiles và the TCP port number.
netsh firewall địa chỉ cửa hàng allowedprogram program="C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBinnsqlservr.exe" name="Microsoft SQL server 2008 R2 Database Engine Access" profile=domain netsh advfirewall firewall địa chỉ rule name="Allow SSMS Database Engine connections inbound on TCP " dir=in action=allow protocol=TCP localport= profile=domain