SQL Server Management Studio Express 2008

Download and Install any edition of SQL Server 2008 (As per your Requirement)

• SQL Server 2008 Express
• SQL Server 2008 Express with Tools
• SQL Server 2008 Express with Advanced Services

Which edition of SQL Server 2008 Express is right for you?
SQL Server 2008 Express is available in the following 3 editions

SQL Server 2008 Express

• SQL Server database engine – create, store, update and retrieve your data

SQL Server 2008 Express with Tools

• SQL Server database engine – create, store, update and retrieve your data
• SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases

SQL Server 2008 Express with Advanced Services

• SQL Server database engine – create, store, update and retrieve your data
• SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases
• Full-text Search – powerful, high-speed engine for searching text-intensive data
• Reporting Services – integrated report creation and design environment to create reports

Make sure you download the SQL Server 2008 Express with Tools

Minimum Requirements:

• Download and install Microsoft .Net Framework 3.5 SP1.
• Download and install Windows Installer 4.5 [important if you have pre-Vista OS].
• Download and install Windows PowerShell 1.0.

Note: If you have non-SP1 version of Visual Studio 2008, you will be stopped at the very last step before the install begins! So if you have VS2008 or any 2008 Express products, upgrade them to SP1 to install the Tools version to get your Management Studio Express.

How to connect MSSQL 2008 Database

* Login into DNP
* Click on User Spaces name
* Click on Databases -> MSSQL 2008
* Click on The Browse database Link

How to create Domain in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on Create Domain Button
* Enter the domain name
* Select the Package
* Click on Save

How to create Domain Aliases in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on Domain Aliases Icon
* Click on Add Button
* Click on Alias domain name under Domain Alias Name text box
* Click on Save

How to create MSSQL 2000/2005 Database in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on MS SQL Server Icon
* Click on Add Button
* Click on Add Button under Databases
* Enter The Database Name under Database Name text Box
* Click on Save
* Click on Add Button Users
* Enter The User Name, password and Confirm Password
* Select the database from Available database list and sent it to assigned database list by clicking on >> button
* Click on Save

How to create MySql 4/5 Database in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on MySql 4/5 Database Icon
* Click on Add Button
* Click on Add Button under Databases
* Enter The Database Name under Database Name text Box
* Click on Save
* Click on Add Button Users
* Enter The User Name, password and Confirm Password
* Select the database from Available database list and sent it to assigned database list by clicking on >> button
* Click on Save

How to enable AWStats Statistics in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on AWStats Statistics
* Click on Enable AWStats Statistics Button
* Click on Save

How to create Sub Domains in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on Sub Domains
* Click on Add Button
* Enter your Sub Domain Name in Sub Domain Name text box
* Click on Save

How to create Custom Error Pages in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on Custom Error Pages
* Click on Error Name for Which you want to Set Custom Error Page
* Select the Type as per your requirement (File or URL)
* If You have Select the File, then Enter your File Name by clicking on button just available in the last of text box
* Click on Save
* If You have Select URL, then Enter Error Page Url
* Click on Save

How to create FTP Account in Helm4

* Login into Helm CP
* Click on My Domains Icon
* Click on yourdomain.com (Here yourdomain.com is your domain name)
* Click on FTP Accounts
* Click on Add Button
* Enter UserName, Password and Confirm Password
* Select the Path as per your requirement from Path option
* Click on Save