- MS SQL services are not running
- Hosting Controller is not properly configured.
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 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 Preferences and then click on MS SQL Settings.
- In SQL Server Name box, provide ¬local¬ (without quotes) if SQL is on local machine, otherwise provide the IP of the machine where MS SQL is installed.
- Provide valid SQL server administrator login name in SQL Server Administrator Name box and valid password in SQL Server Administrator Password box.
Note: Default MS SQL administrator login name is ¬sa¬. If you don¬t know its password, it may be reset from MS SQL MMC.
- In SQL Server IP Address box, provide the IP of the server. In Available SQL Servers box, enter the IP of the machine, NetBIOS name of the machine and keyword (local). Keyword (local) is given only if MS SQL is on local machine.
- Enable SQL Server on Remote Machine check box if MS SQL is on remote machine. Click Save Settings button.