Previous Topic: Configuring Microsoft SQL Server Security Settings

Next Topic: Authentication Requirements

Types of Microsoft SQL Server Authentication

Microsoft SQL Server provides two types of user authentication:

Although Microsoft recommends using only Windows authentication wherever possible, in certain instances it is appropriate, or even necessary, to enable Microsoft SQL Server-based authentication. For example, you must use Microsoft SQL Server authentication for Microsoft SQL Server 7.0 or Microsoft SQL Server 2000 when the database is running in a cluster.