MSSQL database is not creating in the HC

Question: When I try to add MS SQL database, I get error "unable to connect to database".

This error may occur due to the following reasons:

MSSQL Instance is not properly configured in HC

  • Login in HC Panel as Host Admin go to Cluster configurations :: Manage Servers :: My Servers :: Edit Server :: Database Server Setting
  • In SQL Server Name box, provide SQL Server instance Name exactly as it displays when you open SQL Management Studio.
  • Provide  SQL Server Administrator " SA " login credentials, make sure it is correct and you can connect with same login in SQL Management Studio.

If you are using MSSQL 2008 (any version) then install these necessary SQL client utilities Link.
Once you install it then restart HCRemoting Service.