LockedHC8 andMS SQL EXPRESS

Author
allamiro
Starting Member
2009/06/03 14:06:11 (permalink)

HC8 andMS SQL EXPRESS

Does HC8 work with  MS SQL 2005 EXpress edition ? 
#1

7 Replies Related Threads

    Tahir
    HC Staff
    Re:HC8 andMS SQL EXPRESS 2009/06/03 20:01:34 (permalink)
    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
    #2
    allamiro
    Starting Member
    Re:HC8 andMS SQL EXPRESS 2009/06/09 13:20:49 (permalink)
    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.



    #3
    Tahir
    HC Staff
    Re:HC8 andMS SQL EXPRESS 2009/06/09 21:12:57 (permalink)
    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
    #4
    allamiro
    Starting Member
    Re:HC8 andMS SQL EXPRESS 2009/06/10 08:15:01 (permalink)
    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.
    #5
    Tahir
    HC Staff
    Re:HC8 andMS SQL EXPRESS 2009/06/10 09:13:08 (permalink)
    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
    #6
    allamiro
    Starting Member
    Re:HC8 andMS SQL EXPRESS 2009/06/10 13:06:12 (permalink)
    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.
    #7
    allamiro
    Starting Member
    Re:HC8 andMS SQL EXPRESS 2009/06/10 13:42:58 (permalink)
    MachineName\SqlExpress
    #8
    Jump to: