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.
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to my database from a website not hosted at DigiServ.biz?

No, we do not allow linking to your database from a website hosted elsewhere. This is in...

How do I edit my MySQL database?

There are two ways to edit your MySQL Database. A. You can connect to your databases online by...

How do I reduce the size of my MS SQL Log Files?

MS SQL Server Databases are set to Simple backup mode, so you shouldn't see large log...

How do I connect to my database in my scripts?

To connect to your database from your scripts, use the connection information found on the...

Can I connect to MySQL using my 3rd party tool?

Yes, you may.  Please read the following KB article which details how to connect using...