How to Remote Connect to SQL Server 2008
- 1). Click the Windows "Start" button and select "All Programs." Click "SQL Server," then click "SQL Server Management Studio." A dialog window opens. This is where you configure the connection for the SQL Server.
- 2). Type the server name into the Server Name text box. Select "SQL Server Authentication" from the Authentication drop-down box.
- 3). Type your user name and password for the SQL Server. Click "Connect." The console software opens, and all databases on the remote server are shown on the left side of the window. This verifies that you are connected to the server.
Source...