How to connect to SQL Server 2008 or 2005 using SQL Server Management Studio?
The information in this article applies to:
SQL Server Management Studio
SQL Server 2005
SOLUTION
The following describes on how to connect to your SQL Server 2008 or 2005 database using SQL Server Management Studio for database managment.
Open SQL Server Management Studio, the Connect to Server Window will pop up, select/enter the following:
Server Type: Database Engine
Server Name: [The SQL 2008/2005 Server Host name provided by Re-invent ]
Authentication: SQL Server Authentication
Login: [SQL 2008/2005 Login name]
Password: [SQL 2008/2005 Password]
Click connect and you will be connected to the SQL 2008 / 2005 hosting server where your database resides.
NOTE 1: Make sure you do not have a firewall blocking your software and/or port 1433 from accessing the Internet or you will not be able to connect to your database remotely.
NOTE 2: SQL 2005 Server Management Studio is NOT compatible with SQL 2008 databases. Please use SQL 2008 Server Management Studio for management of SQL 2008 databases. |
Article ID: 67, Created On: 5/15/2008, Modified: 9/24/2010