Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL Login Password Encryption

 
   Database Forums (Home) -> Security RSS
Next:  Urgent help with CASE statement  
Author Message
alw

External


Since: Dec 22, 2005
Posts: 5



(Msg. 1) Posted: Mon Oct 13, 2008 10:28 am
Post subject: SQL Login Password Encryption
Archived from groups: microsoft>public>sqlserver>security (more info?)

Are SQL Server 2008 Logins (not integrated logins) passwords automatically
encrypted on the wire (I know they are on the hard drive) by default, or is
there a certain combinations of settings that must be used to have the
passwords encrypted on the wire.

If so, what settings.

Thanks. Ann

 >> Stay informed about: SQL Login Password Encryption 
Back to top
Login to vote
Bob Beauchemin

External


Since: Oct 11, 2008
Posts: 3



(Msg. 2) Posted: Mon Oct 13, 2008 9:44 pm
Post subject: Re: SQL Login Password Encryption [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

SQL Logins are always encrypted on the wire as of SQL Server 2005. From
http://msdn.microsoft.com/en-us/library/ms131691.aspx

Cheers,
Bob Beauchemin
SQLskills

"alw" wrote in message

> Are SQL Server 2008 Logins (not integrated logins) passwords automatically
> encrypted on the wire (I know they are on the hard drive) by default, or
> is
> there a certain combinations of settings that must be used to have the
> passwords encrypted on the wire.
>
> If so, what settings.
>
> Thanks. Ann

 >> Stay informed about: SQL Login Password Encryption 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Where to hide encryption key password? Please help! - If access to SQL Server 2005 is based on role and a column needs to be encrypted, Is there a way to hide encryption key password? All I want is to avoid hard coding encryption key password in the code. Is there a way to decrypt a column based on the..

Symmetric Keys - Encryption by Password - Clarification Pl.. - Please clarify/verify Symmetric Keys - Encryption by Password. The following scenario is included for convienience and elaboration. 1. SQL Server 2005 offers a Password Encrypted Symmetric Key. a) SQL Server 2005 uses the (Strong) Password to...

"hashed" password on alter login command - Hi, I need to synchronise logins between 2 SQL2005 instances on a regular basis - while you can copy the passwords to the destination using the "HASHED" keyword on the CREATE LOGIN command, it appears that "HASHED" is missing from ...

Difference in Login Deny vs Login Disable - What would be the difference between login deny vs login disable ? I see those 2 options and feel they sound the same. When would I use one vs the other ?

PGP encryption - Question for everyone here. I've been asked if it is possible, and how to, PGP encrypt single transactions and then provide the public key for a banking institution to then unencrypt those transactions when they receive it. Looking for documentation....
   Database Forums (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]