mixed & windows authentication

Hi,
i am confused by the windows & mixed mode authentication
Under Windows Authentication , do i need to create a login
in SQL server ?
thks & rdgsHi,
Under Windows Authentication , do i need to create a login in SQL server ?
No need to create a login in SQL server if you are using in Windows
Authentication, Instead you just grant permission to Windows user or group
account to connect to Microsoft SQL Server ( refer sp_grantlogin in books
online) . But while allowing the access automatically a entry will put in to
SYSXLOGINS system table in Master database. All the User policies / Password
policies like password expiration, Password length , password
combination,... will be maintained by OS itself.
Windows Authentication:-
Only Windows users/groups will be able to connect to SQL Server.
Mixed Authentication:
Mixed Mode allows users to connect to an instance of SQL Server, through
either a Windows user account
or a SQL Server login.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
> Hi,
> i am confused by the windows & mixed mode authentication
> Under Windows Authentication , do i need to create a login
> in SQL server ?
> thks & rdgs|||thks Hari
>--Original Message--
>Hi,
>Under Windows Authentication , do i need to create a
login in SQL server ?
>No need to create a login in SQL server if you are using
in Windows
>Authentication, Instead you just grant permission to
Windows user or group
>account to connect to Microsoft SQL Server ( refer
sp_grantlogin in books
>online) . But while allowing the access automatically a
entry will put in to
>SYSXLOGINS system table in Master database. All the User
policies / Password
>policies like password expiration, Password length ,
password
>combination,... will be maintained by OS itself.
>Windows Authentication:-
>Only Windows users/groups will be able to connect to SQL
Server.
>Mixed Authentication:
>Mixed Mode allows users to connect to an instance of SQL
Server, through
>either a Windows user account
>or a SQL Server login.
>Thanks
>Hari
>MCDBA
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
>> Hi,
>> i am confused by the windows & mixed mode
authentication
>> Under Windows Authentication , do i need to create a
login
>> in SQL server ?
>> thks & rdgs
>
>.
>