Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 22. Authentication and Granular Access > Solutions Fast Track
Solutions Fast Track
Understanding the SQL Server Authentication Modes
|
| SQL Server has two authentication modes: Windows-only and Mixed. |
|
| Windows-only, which does not permit SQL Server-based logins, is preferred. |
|
| Third party and applications connecting from untrusted sources often force Mixed Mode. |
|
| Try and consolidate applications that require SQL Server-based logins to be a subset of your SQL Servers and enforce Windows-only authentication on the rest. |
Endpoint Security
|
| SQL Server 2005 has default endpoints installed for Shared Memory, Named Pipes, TCP/IP, and VIA. On a normal configuration, only Shared Memory and TCP/IP is enabled. |
|
| SQL Server 2005 has the capability of creating HTTP endpoints for SOAP access and TCP endpoints for Service Broker and Database Mirroring Connections. |
|
| HTTP endpoints can use Basic, Digest, NTLM, Kerberos, or Integrated Authentication. |
|
| Created TCP endpoints for Service Broker or Database Mirroring can use NTLM, Kerberos, Negotiate, or Certificate Authentication. |
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint