SQL Server Connection Error while Workflow Manager Configuration

SQL Server Connection Error while Workflow Manager Configuration

1.       Error : While configuration workflow manager getting SQL Connection error

 

    Solution:

a.       Create UDL test file an check connection

                                       i.      IF SQL test connection failed

                                     ii.      Run command prompt ip address of SQL server in Workflow Manager Server.

                                    iii.      C:\Ping SQL Server Name

                                   iv.      Still connection failed, Run UDL

                                     v.      Created test Udl file like below shown steps.

1. Open notepad and save file name with "Sql.Udl".
2. Double Click on "Sql.Udl" file.
3. Enter the Sql Server name and select any one contentDB name in dropdown
4. Click on test connection

 

2.       While configuration workflow manager getting SQL Connection

Error: Failing connection to SQL Server.

Solution:

IF you uncheck "Enable SSL Connection with SQL Server instance" it will work.

Because SSL certificate not checking in internet option.

Please find the below steps:

                                       i.            Go to Internet explorer settings

                                     ii.            Click on Internet options

                                    iii.            Click on Advanced settings

                                   iv.            Use SSL 1.0 and 2.0 Unchecked.