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

  • Email, SSL
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How To Attach Data Bases SQL server 2005

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

How to Detach a Database (SQL Server Management Studio)

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

Sql 2008 R2 Management

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

How To create Sql Data Base In Plesk

To create a database in Plesk: 1. Login to Plesk. 2. Click on the domain name in the list at...

How to connect to the MySQL database

Configuration Settings:Host = localhost (really, put localhost)Database name =...