Technical Articles
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
- Installation
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
3.
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
Dear Marc,
Good Document, Thanks for sharing!!
Best Regards,
Repakula Manoj
Dear Marc,
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?
Many thanks
Giuseppe