To connect to MSSQL Server 2000, 2005 or 2008 databases you can use a free MSSQL Management Studio Express (SSMSE) application. You need to download a copy of MSSQL Server 2005 or MSSQL Server 2008 SSMSE and install it.

Note: SSMSE 2008 works with SQL Server 2005 and 2000; SSMSE 2005 SP3 and higher works with SQL Server 2008 and 2000.

To connect to the server, run the application and follow the steps below:

1. Specify the settings below and click Connect button.

  • Server Type: Select Database Engine
  • Server Name: Enter the IP address of your SQL server (can be found at HostPilot > MSSQL Server > Databases page)
  • Authentication: select SQL Server Authentication
  • Login: Enter the username (can be found at HostPilot > MSSQL Server > Logins page)
  • Password: Enter the password (can be found at HostPilot > MSSQL Server > Logins page)

2. If it does not work with default settings, go to Options > Connection Properties tab. And choose TCP/IP in the drop down menu for Network Protocol.

3. If TCP/IP is not available in the drop-down menu, you need to enable this protocol using the Client Network Configuration in Computer Management. Navigate to Start > Programs > Administrative Tools > Computer Management > Services and Applications > SQL Server Configuration Manager > SQL Native Client Configuration > Client Protocols and enable TCP/IP protocol. You can also open Client Network Configuration from Start > Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager > SQL Native Client Configuration > Client Protocols.

Then try to connect.

Detailed infromation on SSMSE usage can be found in Introducing SQL Server Management Studio documentation.