which port to be enabled on windows firewall for connection to external sql server

[Former Member]

Dear all,

I am trying to connect to external sql server from SAP SQL server using MS SQL management studio. But it pops up error. When discussed with It team, they asked me the port to be enabled on windows firewall of SAP server.Please help me in solving the issue

[Former Member · Accepted solution]

Dear Mathan Kumar,

depending on wich functions you want to use, you have to open the following ports:

• SQL Admin Connection- 1434 (TCP)
• SQL TCP Browser - 2382 (TCP)
• SQL UDP Browser - 1434 (UDP)
• SQL Server - 1433 (TCP)  (Note: This may have to be open on the client side as well)
• SQL Dynamic Port - 49172 (TCP)
• SQL Debugger - 135 (TCP)
• SQL Service Broker - 4022 (TCP)

You will find detailed information about configuring the Windows Firewall to Allow SQL Server Acces here: http://msdn.microsoft.com/en-us/library/cc646023.aspx

Best regards

Sascha

[Former Member · Accepted solution]

Dear Sascha,

Thanks for your reply. Its been solved.