Connect to SQL Server From Home
esse quam videri
If you are not on campus you must connect to the VPN first http://imamp.colum.edu/mediawiki/index.php/IAM_VPN
Using SQL Express
Using Visual Studio
Open SQL Server Configuration Manager
Open Native Client Configuration and Right click on Aliases. Select New Alias
Name the alias and enter the IP
Open SQL Server Management Studio
Enter the name of the alias. Rememebr the SQL server has two authentication models. You cannot logon with windows authentication outside of the IAM network.
You should now see the sever in the Object Explorer