Restrict SA access & encrypt whole DB in SQL 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Restrict SA access & encrypt whole DB in SQL 2005

Author

Topic

anjum
Starting Member

1 Post

Posted - 2008-03-06 : 08:52:03

Dear Gurus,

I need to do the following in SQL Server 2005:

1. Restrict access of user SA to my database

2. Encrypt contents of the whole database. Is there anything available in SQL Server 2005 (server or DB settings) which encrypt the contents. I do not want to explicitly encrypt individual columns !!

Thanks in advance
Anjum

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-03-06 : 08:53:06

why would you want to restrict the user of 'sa'? no one should have that password anyway.

Poor planning on your part does not constitute an emergency on my part.