Windows Support Manual

Using the MSSQL database

Our 250MB plan includes MS SQL 2000 server.
The database runs on a seperate server from the web sites and can be connected to using a DSN set up within the control panel.

The database is administered using SQL Enterprise Managaer

(Note: if you do not have a copy of Enterprise Manager, you can download a 120 day free trial here:
http://www.microsoft.com/sql/evaluation/trial/2000/default.asp)

1. Open Enterprise Manager, right click on SQL Server Group Icon and click "New SQL Server Registration"

2. This will start the "SQL Server Wizard"

3. Cllick "Next"
4. At the next screen type in our SQL Server address: helium.srv2.com
5. Click the Add button to add it to the Added servers list.

6. Check the option for The SQL Server Login information that we provided you with.

7. Check the option to "Login automatically using my SQL Server Account information.
8. Type in your username and password and click next.

9. On the next screen you want to check the option to add the SQL server to an existing SQL Group. Check this option and click next.

10. The next screen is the finish screen. Click finish and Enterprise Manager will connect.

If you get a message that you cannot connect, you may need to change the connection type to TCP/IP not Named Pipes. For instructions Click Here.