Connect to SQLServer behind a fire wall.

Is it possible to connect to SQLServer which sits behind a firewall? I have a VB 6 application using OLEDB. How about with .net appliction.

Yes, you just need the right port/protocols open. By default, I believe SQL server uses UDP over port 1434. Here are some MSDN resources:

MSDN Library > ... > SQL Server 2000 > Basic Installation Options > Network Libraries

http://msdn.microsoft.com/library/en-us/instsql/in_runsetup_77g3.asp?frame=true

SQL Server 2000 > Relational Database Components > Communication Components

http://msdn.microsoft.com/library/en-us/architec/8_ar_cs_98mr.asp?frame=true