You can connect to a MSSQL server over any IP connection as long as the right port is open and you have the right credentials. You just make the connection string use the IP address as the 'server' (instead of a local server name). This should work fine for any technology that allows you to connect to MSSQL.
-
Peter