Knowledgebase

Note: To connect to an MS SQL 2008 database you must use the 2008 version of SQL Server Management Studio. You cannot connect to an SQL 2008 database using the 2005 (or earlier) version of SQL Server Management Studio. Make sure TCP port 1433 and 1434 not blocked by your firewall or your ISP.

To connect to your SQL 2008 database using SQL Server Management Studio, follow the steps listed below: 

Open SQL Server Management Studio, the "Connect to Server" window will open. Select/enter the following:

• Server Type: Database Engine
• Server Name: sql2008.domain\sql2008 or sql2008.domain\sql2008,1433 (make sure sql2008 record exist on your DNS Record)
• Authentication: SQL Server Authentication
• Login: [SQL 2008 Login name]
• Password: [SQL 2008 Password]

Click "connect" and you will be connected to the SQL 2008 server.