Databases Reference
In-Depth Information
Figure 11-7
Authentication options.
account name, default database, and server access permissions. User accounts,
passwords, and group membership are managed through Windows and Active
Directory management utilities.
In SQL Server, members of the Administrators group as the default admin-
istrator account are granted login privileges during installation. Any additional
login accounts must be configured manually. When you attempt to connect
using Windows authentication, the user is passed to Windows for authentica-
tion and the status (whether or not you are authenticated as a valid user) and
group membership are passed back to SQL Server.
If you choose mixed authentication, you can also create SQL Server logins.
These are managed separately from Windows, with the accounts and passwords
authenticated by the database server. The only SQL Server login account cre-
ated by default is the
sa account,
which is a system administrator account with
