Domain user as database user?

Vote:
 
Is it possible to use a domain user (from Active Directory) as a database user when running EPiServer? If not, for what reason? We have tried, with negative results. The only reason we are trying is a customer's IT policy stating that all users, even database users, should be in Active Directory. If it doesn't work we will use SQL security instead, however it would be nice to be able to explain why it won't work.
#12780
Sep 19, 2006 10:06
Vote:
 
I think you need to use integrated security and impersonation in order to do this. It depends on what type of site this is. If it is an intranet, you could give access to all users to the database using AD groups, and use sspi with impersonation in ASP.NET to have each user authenticate against the database. Be aware that this influences the license costs. There are a lot of articles about this out there: http://idunno.org/dotNet/trustedConnections.aspx http://support.microsoft.com/kb/316989/ http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGPractices0001.asp http://support.microsoft.com/kb/810572/ http://support.microsoft.com/kb/329290/ /Steve
#14886
Sep 19, 2006 14:17
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.