All my reports are working fine in my application, but I have a problem. When I connect to the DB I have 2 groups of users.
1. DB users;
2. Domain users(intergrated security users);
To make db connection for these users the connectionString will change with or without ";domain=<domainname>". The problem is that I can specify only one connectionString in my web.xml file, so I can only use one of these user groups.
The datasource to connect the users to is specified in the report.
Is there a way to enable intergrated security for SQL server?
Is there a way to change the connectionString at runtime outside the web.xml when a user logs in?
Please help to find out a solution to my problem...