Connect to SQL Server From Home

esse quam videri
Jump to: navigation, search

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

SQLServerConfigurationManager.png

Open Native Client Configuration and Right click on Aliases. Select New Alias

CreateSQLServerAlias.png

Name the alias and enter the IP

CreateSQLServerAliasAlias-New.png

Open SQL Server Management Studio

SQLServerManagemantStudio.png

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.

SQLConnetToServer.png

You should now see the sever in the Object Explorer

SQLConnectedToServer.png

Retrieved from "http://imamp.colum.edu/mediawiki/index.php?title=Connect_to_SQL_Server_From_Home&oldid=19875"