How to connect to a MsSQL 2008 database using SQL Server Management Studio


Open the program SQL Server Management Studio Express and you will be prompted with a Connect to Server box. Fill out the fields with your database information.

The Server Name field is the IP/Hostname of the Database Server.
You must include ",1435' after the IP/Hostname to specify port '1435' for MSSQL 2008 eg: eg: servername,1435.
servername needs to be replaced with your actual server name or domain name.

The Authentication field should be 'SQL Server Authentication' by default.

The Login field is the username you have set up for the database.

The Password field is the password you have set up for the user.

and Click Connect.

Was this answer helpful?

 Print this Article

Also Read

How to View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Odin Plesk Panel

To View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Plesk, Please follow the...

How to connect to a MsSQL 2012 database using SQL Server Management Studio

Open the program SQL Server Management Studio Express and you will be prompted with a Connect to...

Connection String for MsSQL 2008 database

You can use the following connection sting for connecting to MS SQL Server 2008 database...

Connection String for MsSQL 2012 database

You can use the following connection sting for connecting to MS SQL Server 2012 database...

How to connect to a MsSQL 2014 database using SQL Server Management Studio

Open the program SQL Server Management Studio Express and you will be prompted with a Connect to...