 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / December 2008windows or mixed mode
Hi experts. I have a site over internet. MSDN: When possible, use Windows Authentication. please see : http://msdn.microsoft.com/en-us/library/aa905171.aspx What is this reson? which mode is realy secure over internet? Windows Authentication mode has more features, for instance it can use Kerberos. However it requires a domain to authenticate the user, so if the client and the server are the same domain or a trusted domain, you'll have to use SQL Server Authentication. It's not bad. It just doesn't have the full Windows infrastructure behind it. Here is the description from Books Online. http://msdn.microsoft.com/en-us/library/ms144284.aspx  SignatureRick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. > Hi experts. > I have a site over internet. > MSDN: When possible, use Windows Authentication. > please see : http://msdn.microsoft.com/en-us/library/aa905171.aspx > What is this reson? > which mode is realy secure over internet? Rick > so if the client and the server are the same domain or a trusted domain, > you'll have to use SQL Server Authentication Perhaps yopu mean not at the same domain.... > Windows Authentication mode has more features, for instance it can use > Kerberos. However it requires a domain to authenticate the user, so if the [quoted text clipped - 9 lines] >> What is this reson? >> which mode is realy secure over internet? Yes. Sorry about that. I meant "the client and the server are NOT in the same domain or a trusted domain, you'll have to use SQL Server Authentication." SignatureRick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. > Rick >> so if the client and the server are the same domain or a trusted domain, [quoted text clipped - 15 lines] >>> What is this reson? >>> which mode is realy secure over internet? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.