Does the SQL Server have a static IP? What port has the SQL Server been configured for? I hope it's not the default 1433.

With a static IP, you should just be able to use the IP and port in your connection string. For more security, you might look at implementing a VPN between the two sites.

-Mike