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.