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 EXEC xp_readerrorlog 0, 1, N"Server is listening on", "any", NULL, NULL, N"asc"--EXEC xp_readerrorlog 0, 1, N"Server is listening on"Note: Change in below commands to lớn the confirmed port number

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

Further Resources