Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: “Cannot connect to DDM server,port” while connecting to SQLserver management studio
Problem Description

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,4000
A connection was successfully established with the server, but then an error occured during the login process. (Microsoft SQL Server error, Error: 10054)

Cause
This issue occurs if there is a mismatch in the SQLserver ip address configured in the site management console and the configuration file.
Solution

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/civic
frontend_ip = 0.0.0.0
frontend_port = 4000
backend_ip = 10.65.401.109
backend_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.

More Information
Applies To
Product: Dynamic Data Masking
Problem Type:
User Type:
Project Phase:
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:2/19/2013 3:03 AMID:142798
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)