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://126.96.36.199 (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:
188.8.131.52 for INFDB1
184.108.40.206 for INFDB2
220.127.116.11 for INFDB3
18.104.22.168 for INFDB4
22.214.171.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
No, we do not allow linking to your database from a website hosted elsewhere. This is in...
There are two ways to edit your MySQL Database. A. You can connect to your databases online by...
MS SQL Server Databases are set to Simple backup mode, so you shouldn't see large log...
To connect to your database from your scripts, use the connection information found on the...
Yes, you may. Please read the following KB article which details how to connect using...