Hi all, we are about to move our SQL Server database onto a different machin
e from the machine that houses our web server (IIS). Currently our web appl
ication uses "windows authentication" - but once we move it to a different m
achine will we have to chan
ge the security mode? Or is there another way for our web server machine to
flow the identity to the other machine.
I tried looking this issue up online - but I saw no reference to it. I did
find this:
databasesecurity.asp" target="_blank">http://msdn.microsoft.com/library/d...asesecurity.asp
and it seems that the advice from Microsoft is that if you just create an id
entical account on both machines (including password) you can effectively co
nnect from the one machine to the other.
Or have I misunderstood?
Thanks for any advice,
NoviceYes. Either the web server could connect as the IUSR account, or if both
machines are in a domain, you could enable Security Delegation to allow the
end users credentials to pass thru and connect using Windows
Authentication. It depends on the security requirements of your
application and the environment.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment