Client Area
All-in-one service management,
billing & support, conveniently & securely
in one single feature rich place.

Portal Home > Knowledgebase > Windows Hosting > Windows (Helm USA) > Databases > How do I edit my MS SQL Database?


How do I edit my MS SQL Database?




There are two ways to edit your MS SQL Database.

A. You can connect to your databases online by visiting http://db.yourdomain.com/ There, you can choose between managing your MSSQL or MySQL databases via a full-featured web management tool. Choose the MS SQL option and on the login screen, choose the DB server your DB was created on (this can be found by clicking the Database Manager icon in Helm for your domain, then clicking the DB you want to edit), and the username and password of the MS SQL database you have already set up in Helm. You will then have web-based ability to edit your database such as creating new tables, running queries, and inserting data.

B. You can use MS Enterprise Manager (EM). This is a tool that is normally included on the MS SQL 2000 CD. You can also download the MS SQL 2000 trial at http://www.microsoft.com/sql/evaluation/trial/default.asp which contains the Enterprise Manager software. Enterprise Manager will not expire when the trial expires.

To connect using EM, do the following steps:

Open a web browser and connect to https://72.29.120.108 (the http is necessary when using a port in a URL) and enter "emanager" for both username and password. You will receive a "successfully authenticated" message. You need to do this every time before you can connect to the SQL server.

Next you will need to create a new MS SQL Server registration in EM (you only have to do this the first time). So, open EM and expand Microsoft SQL Servers. Right click on SQL Server Group and choose New SQL Server Registration.

For Server, enter the following:

72.29.120.101 for INFDB1
72.29.120.112 for INFDB2
72.29.120.250 for INFDB3
72.29.120.130 for INFDB4
72.29.120.124 for INFDB5

Choose SQL Server Authentication and enter the username and password of a database user you created in Helm.

Uncheck all three check boxes at the bottom (Display SQL Server state in console, Show system datbases and system objects, Automatically start SQL Server when connecting).

Click ok. You will be prompted to start the MS SQL Server. Click Yes/Ok.

After about 10-20 seconds, you should be connected to the database. Expand the databases folder and browse to your database. Expand your database folder and you can now administer your database.

Unfortunately, we cannot hide the rest of the databases on the server, but you will not be able to access any of them.

Remember, you will need to authenticate to the website at the first IP address above before you can connect Enterprise Manager to the MS SQL IP.


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read