MSSQL database is not creating in the HC

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

Answer:
This error may occur for the following reasons:

MSSQL Instance is not properly configured in HC

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