Here are the steps to configure a server to be accessed from remote sql server.
1) enable the firewall on port 1433.
2) enable the firewall on port 1434 udp
3) In SQL Server Configuration Manager to enable TCP / IP.
4) to enable TCP port 1433 and port put off by dynamic null string.
(5) to enable IP Address / Enabled properties of TCP / IP Protocols and network config, enable TCP / IP)
6) Check whether the Client Protocols TCP / IP on the default port 1433
7 ) enable SQL Server and SQL Browser.
0 comments:
Post a Comment