Connecting SQL 2005 Mgt STudio through a Cisco Firewall

What ports do i need to open on my Cisco Firewall in order to allow someone outside my firewall access to SQL? They want to connect using MGT Studio.

Thanks

Bosco

YOu will need to open the port assigned to SQL Server (by default the 1433) but this can differ based on the settings you provided during the install.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Except the TCP port Jens mentioned, you may also need to open UDP port 1434 if it's a named instance (also make sure SQL Browser is running). If you want use Named Pipes, you need open up ports used by file sharing.