Failing to create connection between IIS Server and MSSQL Server dynamically.

[ASadhu]

What are the steps to obtain the decrypted connection string from the configuration file to set up a connection between IIS and MSSQL servers through pattern-based discovery?
The Connection strings are available in .exe file. we need to parse the connection details from .exe encrypted file.

Please help.

[Abbas_5]

Hello @ASadhu,
Similar kind of requirement, please refer to the link below:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780736

If it is helpful, please mark it as helpful and accept the correct solution.
Thanks & Regards,
Abbas Shaik

[AJ-TechTrek]

Hi @ASadhu 

You can ask the Config.xml file from source sever to make a connection to destination server and once you parse the config file you can use the operation whatever available and required to parse the data from config file, That will help to resolve you issue.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.

Thanks

Ajay Kumar

[SiD2]

Hi @ASadhu 

I would recommend getting started with the service mapping so it discovers until the IIS server and also the connections to MSSQL most probably.

If not you can go through the pattern logs and then figure out what's missing to create connections as there are multiple approaches done to create connections in IIS pattern already OOB.