Hi,

it's so important to know if the below is feasible or not and how to do it:

i'm using DNN 4.8.4 and , DB : Microsoft SQL Server 2005.

I have multiple users on my DNN, and I want to give them the privilege to connect to an analysis database (Analysis DB, that uses the Active directory authentication).

I want to group my users under different groups, where the connection to my Analysis DB would be under 1 authenticated user (registered in my Active directory) for each group.

Exp:

User created on DNN: 

user1

user2

user3

Users in the Active Directory that have the privilege to connect to analysis:

userad1

userad2

I want that:

User 1 can connect to my DNN using his user name but the connection to analysis will be under the user name: userad1.

User 2 can connect to my DNN using his user name but the connection to analysis will be under the user name: userad1

User 3 connects and. to my DNN using his user name but the connection to analysis will be under the user name: userad2.

Thanks for your help.

Regards,

Elie

thanks mike for the reply,

sorry to hear that it's not feasible (Only by code) :(

i won't use ur solution cause i don't want the AD Password to my users. hope that i'll find another approche to do this.

thanks again.

Regards,

Elie