SQL Server Performance Forum – Threads Archive

general questions on SQL server 2005 security

hi all[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />], I have learnt from one of the microsoft sites that encryption of data is a new feature in SQL server 2005, is Encryption not available in SQL Server 2000? I believe it is possible in SQL Server 2000 if so is it equal in all means to SQL server 2005 data encryption. and regarding Password policy in SQL Server 2005, Does this apply to SQL Server Authentication also or only to Windows Authentication? please help me in getting answers to above questions. thanks in advance[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. shashank Dont go on my posts iam still a student (*_*)

Encryption is still available in SQL 2000, but it has been better configure with SQL 2005 version. Yes the password policy is applicable on SQL Server and Windows authentication, only way is Windows Authentication policies after managed by WIndows 2003 security policies. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Thanks satya…..regarding encryption i have one more doubt bothering, can database be encrypted in SQL server 2005 if it can be. was that possible in SQL server 2000 also…. Dont go on my posts iam still a student (*_*)

http://www.microsoft.com/downloads/details.aspx?FamilyID=5e58abac-0328-4f67-ad55-55538f50d7f6&DisplayLang=en
http://www.webopedia.com/TERM/S/symmetric_encryption.html
fyi Just let SQL Server 2005 do the work. It’s got its own key management infrastructure to manage encryption keys for users and groups as well as digital certificates for code signing, SQL Service Broker and Web Services via SSL. It supports both symmetric and asymmetric encryption with widely used algorithms such as Triple DES, RC4 and AES. Not entirely possible in SQL 2000 unless you use third party tools and major security measures. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

thanks…. Dont go on my posts iam still a student (*_*)

]]>