You need to download SQL Server Management Studio: you can get one from: http://www.microsoft.com/downloads/en/default.aspx I have highlighted the steps for remote connection below: >> 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 : Protocol TCP/IP Server : "Server IP" Port : 1433 >> Go to 'Start > Programs >Microsoft SQL Server 2008 R2' and run SQL Server Management Studio Input the proper credentials, check the 'Remember Password' if you wish. Server Name: Server IP address 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. If you are having issues connect, we may need to help you whitelist your IP

Add to Favourites
Print this Article