To connect to your Microsoft SQL Server 2000 database using the Query Analyser, you will need to follow the steps listed below:
- Open Query Analyzer.
- Goto to File -> Connect or (Ctrl-O).
- Type the server name and the port number separate by comma (can be found in your hosting control panel) into the SQL Server text box.
e.g db11.cheapdotnet.com,25000
- Check SQL Server Authentication.
- Type in the login name and password (can be found in your database activation email) into their respective textboxes.
- Click Ok