November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
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.
Sep 19, 2006 10:06
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
