Disclosure Management – using Windows Authentication for SQL connection
By default, the Disclosure Management application will use a SQL server authenticated user for connection to the database server (by default, it creates the CDMUser for this)
If you want to use a Windows Authenticated user, you can use the following steps
Unfortunately, you are forced to install with a SQL Server authenticated user (you can use ‘sa’ for example)
After the installation is completed, perform the following steps
2. In IIS, change the identity of the Disclosure Management application pool to the windows user
In the file C:\inetpub\wwwroot\SAP\SAP Disclosure Management\bin\cundus.enterpriseReporting.Services.dll.config
Make this change in the connection string
<add name=”enterpriseReporting” connectionString=”Data Source=SQLServerName;Initial Catalog=DMDatabaseName;Integrated Security=False; User Id=; Password=;MultipleActiveResultSets=False” providerName=”System.Data.SqlClient”></add>
4. Restart the Disclosure Management website
Now, the connection will use the windows account.
Optional : you can turn off the SQL Server authentication
Good Document, Thanks for sharing!!
I applied your instructions and I changed the cundus.enterpriseReporting.Services.dll.config file. Our original file contained the encrypted connection string, so I applied your instructions.
The result is that I cannot access the DM and the file is automatically updated by the system that updates with the encrypted connection string.
Have you experienced this case?