In Dynamic Data Masking (DDM), when connecting to the SQL server management studio with the DDM sqlserver server name and DDM port number, the following error is displayed:
Cannot connect to INW00004086,4000A connection was successfully established with the server, but then an error occured during the login process. (Microsoft SQL Server error, Error: 10054)
All the SQL server databases created from the site management console will be entered in the activebasemssql.conf file within the gs folder.Check the proxy area for the particular SQLserver log in which the error is displayed.
[proxy2]proxy_name = Site/civicfrontend_ip = 0.0.0.0frontend_port = 4000backend_ip = 10.65.401.109backend_port = 1433
Here the backend_ip value is different from the one configured from the front end and is not correct. Correct this file, save it and then log into the SQL server management studio.
What can we do to improve this information (2000 or fewer characters)