Security Models available in SQL Server 2000 sp3a

[tforr]

Hi,

Am I right in thinking that the security models available are:

Windows Authentication Mode

AND

Mixed Mode

Or is this something else.

Hope you can help.

Thanks and kind regards,

Tom

 

[JayKusch]

Nope ... that pretty much covers it ...

Windows authentication mode: With Windows authentication, you do not have to specify a login name and password, to connect to SQL Server. Instead, your access to SQL Server is controlled by your Windows NT/2000 account (or the group to which your account belongs to), that you used to login to the Windows operating system on the client computer/workstation. A DBA must first specify to SQL Server, all the Microsoft Windows NT/2000 accounts or groups that can connect to SQL Server

Mixed mode: Mixed mode allows users to connect using Windows authentication or SQL Server authentication. Your DBA must first create valid SQL Server login accounts and passwords. These are not related to your Microsoft Windows NT/2000 accounts. With this authentication mode, you must supply the SQL Server login and password when you connect to SQL Server. If you do not specify SQL Server login name and password, or request Windows Authentication, you will be authenticated using Windows Authentication.




Thanks

J. Kusch

 

[tforr]

What sercuity models are available with SQL server 2000

 

[JayKusch]

Same

Thanks

J. Kusch