encrypting a database ?

Hi,
does it possible to encrypt an entire database?
I know when can encrypt SP
we have to deploy a home made application based on SQL 2000 but we want to
hide the structure of the database to the users AND the administrators
They can just access the table (for reporting access), but not seeing the
relations, indexes and specific configuration tables.
does it possible?
Thanks.
Jerome.
You can use some 3rd party products. Check, for example, those sites:
http://www.netlib.com/sql-server-encryption.shtml
http://www.ecatenate.com/dblockdown_product_info.html
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:uFC1PjAhEHA.632@.tk2msftngp13.phx.gbl...
> Hi,
> does it possible to encrypt an entire database?
> I know when can encrypt SP
> we have to deploy a home made application based on SQL 2000 but we want to
> hide the structure of the database to the users AND the administrators
> They can just access the table (for reporting access), but not seeing the
> relations, indexes and specific configuration tables.
> does it possible?
> Thanks.
> Jerome.
>

encrypting a database ?

Hi,
does it possible to encrypt an entire database?
I know when can encrypt SP
we have to deploy a home made application based on SQL 2000 but we want to
hide the structure of the database to the users AND the administrators
They can just access the table (for reporting access), but not seeing the
relations, indexes and specific configuration tables.
does it possible?
Thanks.
Jerome.You can use some 3rd party products. Check, for example, those sites:
http://www.netlib.com/sql-server-encryption.shtml
http://www.ecatenate.com/dblockdown_product_info.html
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:uFC1PjAhEHA.632@.tk2msftngp13.phx.gbl...
> Hi,
> does it possible to encrypt an entire database?
> I know when can encrypt SP
> we have to deploy a home made application based on SQL 2000 but we want to
> hide the structure of the database to the users AND the administrators
> They can just access the table (for reporting access), but not seeing the
> relations, indexes and specific configuration tables.
> does it possible?
> Thanks.
> Jerome.
>

encrypting a database ?

Hi,
does it possible to encrypt an entire database?
I know when can encrypt SP
we have to deploy a home made application based on SQL 2000 but we want to
hide the structure of the database to the users AND the administrators
They can just access the table (for reporting access), but not seeing the
relations, indexes and specific configuration tables.
does it possible?
Thanks.
Jerome.You can use some 3rd party products. Check, for example, those sites:
http://www.netlib.com/sql-server-encryption.shtml
http://www.ecatenate.com/dblockdown_product_info.html
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:uFC1PjAhEHA.632@.tk2msftngp13.phx.gbl...
> Hi,
> does it possible to encrypt an entire database?
> I know when can encrypt SP
> we have to deploy a home made application based on SQL 2000 but we want to
> hide the structure of the database to the users AND the administrators
> They can just access the table (for reporting access), but not seeing the
> relations, indexes and specific configuration tables.
> does it possible?
> Thanks.
> Jerome.
>

Empty Report manager page

When I go to http://localhost/Reports I see the page (subscription,
home, ...) but I don't see any tools nor reports.
I have anonymous authentication set to off in IIS for that directory,
and only have integrated authentication turned on. I logged in with
administrator account.
Is there any other way of setting users and roles without using the
'manage reports' page? That way I could make sure administrators has
the correct role.
Thanks in advance,
Stijn Verrept.Are you an administrator on the actual server machine?
Chris
Stijn Verrept wrote:
> When I go to http://localhost/Reports I see the page (subscription,
> home, ...) but I don't see any tools nor reports.
> I have anonymous authentication set to off in IIS for that directory,
> and only have integrated authentication turned on. I logged in with
> administrator account.
> Is there any other way of setting users and roles without using the
> 'manage reports' page? That way I could make sure administrators has
> the correct role.
>
> Thanks in advance,
> Stijn Verrept.|||Chris McGuigan wrote:
> Are you an administrator on the actual server machine?
> Chris
Thanks for the reply, I'm getting desperate :). Yes I am, the server
is a domain controller BTW. I had access earlier but now I don't have
access anymore for some reason, maybe I set something incorrect?|||It does sound like the RS server doesn't recognise you as an
administrator.
I have to say that I did a recent installation on a domain controller
and it went terribly. The main problem seemed to be that the
installation couldn't create the ASPNet user which is essential.
I had to set ASPNet up by hand and had to raise it to administrator
level.
Having said that, your issue seems different. Is it possible that you
changed the role of the administrator in RS so that it didn't have full
rights anymore? If thats a possibility then you will probably have to
reinstall.
Have you had reports running on this installation. If not and you are
trying to set it up for the first time, I would strongly advise you NOT
to put it on a domain controller.
Chris
Stijn Verrept wrote:
> Chris McGuigan wrote:
> > Are you an administrator on the actual server machine?
> >
> > Chris
> Thanks for the reply, I'm getting desperate :). Yes I am, the server
> is a domain controller BTW. I had access earlier but now I don't have
> access anymore for some reason, maybe I set something incorrect?|||Try this url;
http://SERVERNAME/Reports/Pages/SystemSecurity.aspx
If you get access denied, this will prove whether or not you are an
administrator as far as RS is concerned.
Chris
Chris McGuigan wrote:
> It does sound like the RS server doesn't recognise you as an
> administrator.
> I have to say that I did a recent installation on a domain controller
> and it went terribly. The main problem seemed to be that the
> installation couldn't create the ASPNet user which is essential.
> I had to set ASPNet up by hand and had to raise it to administrator
> level.
> Having said that, your issue seems different. Is it possible that you
> changed the role of the administrator in RS so that it didn't have
> full rights anymore? If thats a possibility then you will probably
> have to reinstall.
> Have you had reports running on this installation. If not and you are
> trying to set it up for the first time, I would strongly advise you
> NOT to put it on a domain controller.
> Chris
>
> Stijn Verrept wrote:
> > Chris McGuigan wrote:
> >
> > > Are you an administrator on the actual server machine?
> > >
> > > Chris
> >
> > Thanks for the reply, I'm getting desperate :). Yes I am, the
> > server is a domain controller BTW. I had access earlier but now I
> > don't have access anymore for some reason, maybe I set something
> > incorrect?|||One other thing to consider. Did you enable anonymous access on your
webserver? If anonymous access is enabled then all users are the same (they
are anonymous) and RS does not know you are the administrator. Disable
anonymous access.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:OmiivhMpFHA.272@.TK2MSFTNGP15.phx.gbl...
> It does sound like the RS server doesn't recognise you as an
> administrator.
> I have to say that I did a recent installation on a domain controller
> and it went terribly. The main problem seemed to be that the
> installation couldn't create the ASPNet user which is essential.
> I had to set ASPNet up by hand and had to raise it to administrator
> level.
> Having said that, your issue seems different. Is it possible that you
> changed the role of the administrator in RS so that it didn't have full
> rights anymore? If thats a possibility then you will probably have to
> reinstall.
> Have you had reports running on this installation. If not and you are
> trying to set it up for the first time, I would strongly advise you NOT
> to put it on a domain controller.
> Chris
>
> Stijn Verrept wrote:
>> Chris McGuigan wrote:
>> > Are you an administrator on the actual server machine?
>> >
>> > Chris
>> Thanks for the reply, I'm getting desperate :). Yes I am, the server
>> is a domain controller BTW. I had access earlier but now I don't have
>> access anymore for some reason, maybe I set something incorrect?
>|||I get "You do not have permission to access this page." and I'm logged
in as administrator.|||Bruce L-C [MVP] wrote:
> One other thing to consider. Did you enable anonymous access on your
> webserver? If anonymous access is enabled then all users are the same
> (they are anonymous) and RS does not know you are the administrator.
> Disable anonymous access.
No I only have integrated authentication turned on (mentionned this in
original mail), however, the browser doesn't popup the login screen. I
immediatly get: "You do not have permission to access this page." when
trying to access the page Chris gave me.|||I went back and looked at your original message. You only mentioned the
Reports website, what about Reportserver web. The Reports (report manager)
web is a portal into the reportserver. You need anonymous off for both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stijn Verrept" <stjin@.entrysoft.com> wrote in message
news:OMadnSiPYfnzbJjeRVnytA@.scarlet.biz...
> Bruce L-C [MVP] wrote:
>> One other thing to consider. Did you enable anonymous access on your
>> webserver? If anonymous access is enabled then all users are the same
>> (they are anonymous) and RS does not know you are the administrator.
>> Disable anonymous access.
> No I only have integrated authentication turned on (mentionned this in
> original mail), however, the browser doesn't popup the login screen. I
> immediatly get: "You do not have permission to access this page." when
> trying to access the page Chris gave me.|||Bruce L-C [MVP] wrote:
> I went back and looked at your original message. You only mentioned
> the Reports website, what about Reportserver web. The Reports (report
> manager) web is a portal into the reportserver. You need anonymous
> off for both.
YES!!! Good job mate! That did it, nice observing :). I put it to
anonymous so that anyone can look at report.
Thanks a lot!
Stijn Verrept.