Hello. Thanks for visiting.

Have questions about Server Intellect?

I'm here to help.

Call us toll free at 1-855-850-HOST(4678)

Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

Creating an SQL Server Database in Helm 4

One of the added benefits of upgrading to version 4 of the Helm Control Panel is the inclusion and integration of Microsoft SQL Server 2005 Express Edition. Creating a database through the Helm Control Panel has never been easier.

Step 1

Once logged into HELM as ADMIN, click the link for My Domains.

kb-helm4-adding-email-01

Step 2

Click the domain for which you would like to create the SQL Database.

kb-helm4-adding-email-02

Step 3

Click the icon which says MS SQL Server 2005.

kb-sqL-add-db-helm4-1

Step 4

This page will show you a list of all created databases. As you can see, there is already both a database and user named ‘test’. We will create a second database and user to illustrate the ability to easily manipulate database permissions within Helm 4. Click on Add in the upper left-hand corner of the window under the Databases heading.

kb-sqL-add-db-helm4-2

Step 5

Type a name for the database and click Save.

kb-sqL-add-db-helm4-3

Step 6

The newly created database is now in the list below. Clicking on the database name will give details about the database, including the Connection String. At this point, you have the option of either assigning permissions for the existing user, ‘test’, to access this database, or creating a new one. For the purposes of this article, we will create a new user. Click on Add in the upper-left hand corner of the window under the Users heading.

kb-sqL-add-db-helm4-4

Step 7

Type in a name for the database user, enter a strong password and set which database will be the default for this user. Once finished, click Save.

kb-sqL-add-db-helm4-5

Step 8

You should now see the newly created user, yet nothing listed under the User Databases heading. Click on the user to assign it to the database.

kb-sqL-add-db-helm4-6

Step 9

Highlight one or more databases in the list under the Available Databases heading, and click the right-pointing arrows to assign them.

kb-sqL-add-db-helm4-7

Step 10

Once they are Assigned Databases list, click Save.

kb-sqL-add-db-helm4-8

You have now successfully created a new database and user.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.