Use intergrated security

Hi there,

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