Subscribe to SQL Server Magazine | See More Security Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

A. If you use multi-protocol net-lib with encryption then SQL standard security userids/passwords are encrypted along with the data.

When using an NT userid/trusted connection then passwords are not passed at all - the sids are used as in all NT credential checks.

If you are using SQL 7.0 client drivers talking to a 7.0 server then the SQL standard security userid/password is encrypted regardless of net-lib.

In any other case then the SQL standard security userid/password is sent in clear.

End of Article


Post Your Comments Here

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now

 
 

ADS BY GOOGLE