How To connect the Sql Data Base remotely

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

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Sql 2008 R2 Management

FIX: A fix is available for SQL Server Management Studio 2008 R2 that enables you to rename SQL...

How to Detach a Database (SQL Server Management Studio)

SQL Server 2005 Books Online (November 2008) How to: Detach a Database (SQL Server Management...

What is differnce between Mysql And Mssql

Some of the difference between MSSQL and MYSQL Syntax are as follows: 1) MSSQL support UDD(User...

How to connect to the MySQL server remotely

Note: If connecting from your home computer, you need a MySQL client like Navicat, phpMyAdmin, or...

How To Attach Data Bases SQL server 2005

SQL Server 2005 Books Online (November 2008) How to: Attach a Database (SQL Server Management...