Verify the SQL server host and make sure that it is accessible with the supplied credentials - Solution

[PranayaSahu]

Issue:
Verify the SQL server host and make sure that it is accessible with the supplied credentials

Few of the identified root causes are:
The ODBC driver is configured to use SQL Server native client .
User DBA admin team has to reconfigure to SQL Server ODBC driver instead of native client

{Steps to verify : Verify it from Orchestrator server }
Check the SQL Database connection with ODBC Data Source using the below steps.

1. Go to Start menu and enter ODBC Data Source and press enter. Following windows will appear and click on Add Button.
   
2. Choose SQL Server from the following options.(Not the SQL Server native client)
   
3. Enter the name, description (any) and choose the server that you are trying to connect. (Server name can be typed to avoid ‘(Not responding)’ error if we have more server lists)
   
4. Select With SQL Authentication… and enter the same credentials that you are trying to connect.
   
5. Check if you could successfully connect with the server.
   
   

The connection should be successful. In case not please reach out to your DBA team.