This document explains how to make a remote connection via SQL Server Management Studio 2008 to manage your SQL 2008 database. If you don't already have the program installed you will need to download a trial copy from Microsoft or use this direct link.

Step 1: Download SQL Server Management Studio from one of the links above

Step 2: Burn the ISO image you just downloaded to a DVD.  If you don't want to burn a DVD, you can download WinImage from the internet to open the ISO and extract to a folder.

Step 3: Run setup.exe from your dvdrom drive, select Installation on the left, Select 'New SQL Server stand-alone installer' on the right, select Enterprise Evaluation license, then under Feature Selection check off Management Tools - Basic, Click Next and allow the installation to proceed.

Step 4: Go to 'Start > Programs > Microsoft SQL Server 2008' and run SQL Server Configuration Manager. Go to to Aliases and create a new alias.

Alias Name : mssql4.nextmill.net
Protocol TCP/IP Server : mssql4.nextmill.net
Port : 5000

Step 5: Go to 'Start > Programs >Microsoft SQL Server 2008' and run SQL Server Management Studio

Step 6: Input the proper credentials, check the 'Remember Password' if you wish.

Server Name: mssql4.nextmill.net
Login: Username you selected when creating the database
Password: Password you selected when creating the database

Step 7: Click 'Connect', you may also select a Default Database and/or TCPIP Network Protocol under 'Options' if you wish.