Buy
Schedule a Demo
Blog
Contact Us
HOSTING CONTROLLER
CLOUD AUTOMATION PLATFORM
Products
Solutions
Downloads
Support
Resources
About HC
Join us now!
Log in
/
Username
Password
Verification
Stay logged in
Login
Forgot Your Password?
Forgot your Username?
Haven't received registration validation E-mail?
User Control Panel
Log out
Forums
Posts
Latest Posts
Active Posts
Recently Visited
Search Results
View More
Blog
Recent Blog Posts
View More
Photos
Recent Photos
My Favorites
View More
Photo Galleries
PMs
Unread PMs
Inbox
Send New PM
View More
Page Extras
Menu
Forum Themes
Elegant
Progressive
Home
»
[Website Hosting Module]
»
Installation & Configuration / Upgrades / Product Licensing
»
HC8 andMS SQL EXPRESS
Mark Thread Unread
Flat Reading Mode
❐
Locked
HC8 andMS SQL EXPRESS
Author
Post
Essentials Only
Full Version
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
HC Staff
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
HC Staff
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
HC Staff
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:
MS SQL services are not running
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:
Login as Host Admin. Click
My Server---->Services
and then click on
List Services
.
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.
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
:
Jump to
- - - - - - - - - -
[Website Hosting Module]
- - - - Installation & Configuration / Upgrades / Product Licensing
- - - - Linux Control Panel
- - - - Hosting Controller Value Added Utilities
- - - - Technical Discussion
- - - - Web Hosting Providers
[HC Enterprise Modules]
- - - - Hosting Controller Developer Network
- - - - HC Enterprise Module On-Premises
- - - - HC Virtualization Module
- - - - HC Cloud Services
[Miscellaneous]
- - - - Announcements
- - - - Feedback & Suggestions