Encryption of Database.

"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
> Hi,
> Can the SQL Database be encrypted such that no one can access tables and
> views or see that data?
> Do inform.
> Also can we do something such that SQL Can be accessed via the front end
> ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
> Akshay.
>
SQL Server 2005 gives you several options for encrypting data.
Only allowing access thorugh a front-end is neither practical nor prudent.
If you did so, how would you maintain your database, maintain indexes,
backups, restores etc.
BTW: Enterprise Manager is a "front-end" tool.
You can (and should) use the security that is built in to SQL Server to
handle security. Give only those who need access the appropriate
permissions at the server, database and object levels.
HTH
Rick Sawtell
MCT, MCSD, MCDBABefore you do anything like encryption or passwords, please thoroughly read
and understand the section on security in Book-on-Line. Then you will be in
a better position to ask questions about which ever kind of security you
think is best and how to set it up .
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
> Hi,
> Can the SQL Database be encrypted such that no one can access tables and
> views or see that data?
> Do inform.
> Also can we do something such that SQL Can be accessed via the front end
> ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
> Akshay.
>|||If you truly want no one to access the database, you should not install it.
If you want only certain people to access it, you can create the database on
an encrypted filesystem or in SQL Server 2005 you can encrypt critical parts
of the data.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
> Hi,
> Can the SQL Database be encrypted such that no one can access tables and
> views or see that data?
> Do inform.
> Also can we do something such that SQL Can be accessed via the front end
> ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
> Akshay.
>|||Hi,
Can the SQL Database be encrypted such that no one can access tables and
views or see that data?
Do inform.
Also can we do something such that SQL Can be accessed via the front end
ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
Akshay.|||"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
> Hi,
> Can the SQL Database be encrypted such that no one can access tables and
> views or see that data?
> Do inform.
> Also can we do something such that SQL Can be accessed via the front end
> ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
> Akshay.
>
SQL Server 2005 gives you several options for encrypting data.
Only allowing access thorugh a front-end is neither practical nor prudent.
If you did so, how would you maintain your database, maintain indexes,
backups, restores etc.
BTW: Enterprise Manager is a "front-end" tool.
You can (and should) use the security that is built in to SQL Server to
handle security. Give only those who need access the appropriate
permissions at the server, database and object levels.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Before you do anything like encryption or passwords, please thoroughly read
and understand the section on security in Book-on-Line. Then you will be in
a better position to ask questions about which ever kind of security you
think is best and how to set it up .
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
> Hi,
> Can the SQL Database be encrypted such that no one can access tables and
> views or see that data?
> Do inform.
> Also can we do something such that SQL Can be accessed via the front end
> ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
> Akshay.
>|||If you truly want no one to access the database, you should not install it.
If you want only certain people to access it, you can create the database on
an encrypted filesystem or in SQL Server 2005 you can encrypt critical parts
of the data.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
> Hi,
> Can the SQL Database be encrypted such that no one can access tables and
> views or see that data?
> Do inform.
> Also can we do something such that SQL Can be accessed via the front end
> ONLY and not directly via SQL Enterprise Manager? Can such a lock be put?
> Akshay.
>|||Can I get more details on how to encrypt critical parts of the data using SQ
L
Server 2005?
Can I encrypt tables, views all? or just the data within them?
Akshay.
"Roger Wolter[MSFT]" wrote:

> If you truly want no one to access the database, you should not install it
.
> If you want only certain people to access it, you can create the database
on
> an encrypted filesystem or in SQL Server 2005 you can encrypt critical par
ts
> of the data.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "iweb" <iweb@.discussions.microsoft.com> wrote in message
> news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
>
>|||Where can i read these books-on-line?
Akshay.
"Arnie Rowland" wrote:

> Before you do anything like encryption or passwords, please thoroughly rea
d
> and understand the section on security in Book-on-Line. Then you will be i
n
> a better position to ask questions about which ever kind of security you
> think is best and how to set it up .
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "iweb" <iweb@.discussions.microsoft.com> wrote in message
> news:85867998-1755-4B5C-8676-1C03DA8D93A0@.microsoft.com...
>
>|||Books on Line is the SQL Server help documentation. It comes on the SQL
Server installation disks, and you can go to www.Microsoft.com/sql and
download the latest version.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:6DC83526-B0FF-4DAC-89F1-A31A1D15D20C@.microsoft.com...[vbcol=seagreen]
> Where can i read these books-on-line?
> Akshay.
> "Arnie Rowland" wrote:
>