Skip to Content
Technical Articles
Author's profile photo Marc Kuipers

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

 

  1. 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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Repakula Manoj
      Repakula Manoj

      Dear Marc,

      Good Document, Thanks for sharing!!

       

      Best Regards,

      Repakula Manoj

       

       

      Author's profile photo Giuseppe Leggio
      Giuseppe Leggio

      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