Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

839


Chapter 32: Authentication Types in SQL Server


32


Best Practice


If Kerberos implementation is necessary, avoid the use of unconstrained delegation at all costs.

Summary


SQL Server 2012 supports both Windows-only authentication and SQL and Windows authen-
tication. Windows-only authentication is the preferred authentication type because it
provides additional security and management advantages. Use SQL authentication for back-
ward compatibility reasons only or in non-Windows domain environments.

c32.indd 839c32.indd 839 7/31/2012 10:01:03 AM7/31/2012 10:01:03 AM


http://www.it-ebooks.info
Free download pdf