Mixed Mode Authentication

[cpaige]

Hi,
I currently have a SQL 2000 Server that is setup as SQL Authentication. I have been reading about Mixed Mode authentication and wondering how exactly it worked.

If the SQL 2000 Server is using SQL authentication , is it already using Mixed Mode?

When using Mixed Mode does the server check both the SQL Login and the Windows Login?

In Mixed Mode, is that password transfered to the SQL Server in plan text?

Thanks,


Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[ClaireHCM]

For security,you will see only 2 choices one is Windows authentication,the other is mixed mode which include windows and sql server authentication.

If you right click on the server name in Enterprise manager,go to security tab,you will see two choices ,if you select Mixed mode ,you can connect to sql server in 2 ways .
Go to Query analyzer,you will be asking about the way to connect to sql server,you can either check "Windows Authentication" and click "OK",because windows already check the pwd for that user name,SQL Server trust the security provided by windows, or you can check SQL Server Authentication and insert the login name and pwd which can be any logine name which has been added in sql server,here windows doesnt provide the security checking,so you need to insert pwd by yourself.

If you just choose Windows Authentication,you can only check windows authentication and click ok.

 

[cpaige]

ok,
But, when you have a Server set to Mixed Mode, does it Authenticate both at the same time?



Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[ClaireHCM]

No.it just provide you double way to connect to sql server.
Either you choose SQL authentication or windows authentication.

 

[cpaige]

So, if I expire the Windows Login, the user could still connection via the SQL Authenication?

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[ClaireHCM]

yes..but you have to provide the correct login name and password

 

[cpaige]

Thank you, you have been a great help

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[ClaireHCM]

NOT A PROB!