HC8 andMS SQL EXPRESS

Does HC8 work with  MS SQL 2005 EXpress edition ? 

allamiro

Does HC8 work with  MS SQL 2005 EXpress edition ? 

Yes HC8 support Sql Express version 2005 & 2008

________________________
HC Support Team
Contact Support Department
http://hostingcontroller.com

It turns out and this is very important to know   if you are using MSSQL you have to install it on the mix mode or   it wont work with HC8.

During HC installation or User database creation HC panel use sql authentication, yes it is require to setup sql server using mix mode.

________________________
HC Support Team
Contact Support Department
http://hostingcontroller.com

I m not sure if its important but I think HC8 should add on  their online doc on how to setup the  prequisite such as MS SQL   for HC8 also.

HC doc/kbs are based on set of instructions for configuring 3rd party applications in the panel. To find out 3rd party software installation/configuration doc you can collect that info from their site.

BTW: Kb article to configure mssql http://support.hostingc...ction=kb&article=231

________________________
HC Support Team
Contact Support Department
http://hostingcontroller.com

Question: When I try to add MS SQL database, I get error "unable to connect to database".
Answer: This error occurs in two cases:

1. MS SQL services are not running
2. Hosting Controller is not properly configured.

SOLUTIONS
To resolve this problem, make sure that ¬MSSQLServer¬ services is running and Hosting Controller is configured properly.
To Start MSSQLServer Service:

1. Login as Host Admin. Click My Server---->Services and then click on List Services.
2. Find MSSQLSERVER service in the list and make sure that link in Startup Type column is labeled Automatic. If it is not, click on the link in the Startup Type column next to MSSQLSERVER service and choose the Automatic startup type from the available drop-down. Click on Update button.
3. The link in Status column should be labeled Running. If it is not, click on the link in the Status column next to MSSQLSERVER service and choose the Start radio button. Click on Update button.

To Configure MS SQL Settings In Hosting Controller:

• Login as Host Admin. Click Server Manager--->Edit Server and then find SQL Server Settings.
• In SQL Server Name box, provide ¬local,machine name or IP address (without quotes)
• Provide valid SQL server administrator login name in SQL Server Administrator Name box with valid password.
• If you are using SQL Server Express Edition then by default it creates SQL instance name like ' MachineName\SqlExpress' which can be  verified by opening SQL Express Management studio and provide same SQL instance name into HC SQL setting.

Note: Default MS SQL administrator login name is ¬sa¬. If you don¬t know its password, it may be reset from MS SQL MMC.
    4.     In SQL Server IP Address box, provide the IP of the server. Click Save Settings button.
    5.     Consult with this article If SQL Server is on remote subsequent machine.

MachineName\SqlExpress