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.
Once logged into HELM as ADMIN, click the link for My Domains.
Click the domain for which you would like to create the SQL Database.
Click the icon which says MS SQL Server 2005.
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.
Type a name for the database and click Save.
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.
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.
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.
Highlight one or more databases in the list under the Available Databases heading, and click the right-pointing arrows to assign them.
Once they are Assigned Databases list, click Save.
You have now successfully created a new database and user.