Backing up Microsoft SQL Server
168
SonicWALL CDP 6.0 Administrator’s Guide
•
Windows Authentication Mode (Windows Authentication)
•
Mixed Mode (Windows Authentication and SQL Server Authentication)
Windows Authentication mode allows a user to connect through a Microsoft Windows user
account.
Mixed Mode allows users to connect to an instance of SQL Server using either Windows
Authentication or SQL Server Authentication. Users who connect through a Windows user
account can make use of trusted connections in either Windows Authentication Mode or Mixed
Mode.
SQL Server Authentication is provided for backward compatibility. For example, if you create a
single Windows 2000 group and add all necessary users to that group, you will need to grant
the Windows 2000 group login rights to SQL Server and access to any necessary databases.
About Windows Authentication
When a user connects through a Windows user account, SQL Server revalidates the account
name and password by calling back to Windows for the information.
SQL Server achieves login security integration with Windows by using the security attributes of
a network user to control login access. A user's network security attributes are established at
network login time and are validated by a Windows domain controller. When a network user
tries to connect, SQL Server uses Windows-based facilities to determine the validated network
user name. SQL Server then verifies that the person is who they say they are, and then permits
or denies login access based on that network user name alone, without requiring a separate
login name and password.
Login security integration operates over any supported network protocol in SQL Server.
Note that if a user attempts to connect to an instance of SQL Server providing a blank login
name, SQL Server uses Windows Authentication. Additionally, if a user attempts to connect to
an instance of SQL Server configured for Windows Authentication Mode by using a specific
login, the login is ignored and Windows Authentication is used.
Windows Authentication has certain benefits over SQL Server Authentication, primarily due to
its integration with Windows security system. Windows security provides more features, such
as secure validation and encryption of passwords, auditing, password expiration, minimum
password length, and account lockout after multiple invalid login requests.
Because Windows users and groups are maintained only by Windows, SQL Server reads
information about a user's membership in groups when the user connects. If changes are made
to the accessibility rights of a connected user, the changes become effective the next time the
user connects to an instance of SQL Server or logs on to Windows (depending on the type of
change).
Summary of Contents for CDP 6.0
Page 15: ...xiv SonicWALL CDP 6 0 Administrator s Guide...
Page 99: ...Creating a Global Policy 84 SonicWALL CDP 6 0 Administrator s Guide...
Page 215: ...Recovering Data from Microsoft SQL Server 200 SonicWALL CDP 6 0 Administrator s Guide...
Page 229: ...Replacing the Downstream CDP Appliance 214 SonicWALL CDP 6 0 Administrator s Guide...
Page 267: ...Contributors 252 SonicWALL CDP 6 0 Administrator s Guide...
