ReportServer Service and Encryption Key

In troublshooting a rights issue I changed the ReportServer service to
run under a domain acount (rather than network service).
I believe this may have affected my ability to run subscriptions as
well as random authentication issues.
I am unable to extract the encryption key which I believe is tied to
making the account change above.
Is it adviseable to delete the key and re-specify the values with
rsconfig?Changing the report server windows serivce account is not a trivial
operation as I'm sure you've discovered :-(.
Regarding deleteing the secure information - if you have a back up of you
symmetric key (which is highly recommended) or are in a web farm
configuration where at least one of the other report servers still can
decrypt the key, then you shouldn't need to.
If you do not have the symmetric key:
Yes. Deleteing the secure information is required to reuse the report server
database. This will not alter your reports, but you will need to reenter
any information for data source connection strings and username/password
combinations.
As a note on changing the windows service account user - if your report
server database is remote, you will need to use a network enabled account.
The easiest way to change the account is acutally to reinstall :-(. The
reason for this is that the account you choose needs permissions on many
folders in the file system. Enumerating these is challenging and you'd have
an easier time reinstalling.
Best of luck,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106872525.453713.36200@.f14g2000cwb.googlegroups.com...
> In troublshooting a rights issue I changed the ReportServer service to
> run under a domain acount (rather than network service).
> I believe this may have affected my ability to run subscriptions as
> well as random authentication issues.
> I am unable to extract the encryption key which I believe is tied to
> making the account change above.
> Is it adviseable to delete the key and re-specify the values with
> rsconfig?
>

reporting user access rights on SQL7

I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000 (i
n
another domain 2).
To map the users from the domains, I need to know which users are configured
on the databases, plus which access rights and roles they have.
Can I get a report of this?
Does SQL have a default stored procedure for this?
Best regards,
-Peter-
Peter Geelen
System Engineer
www.identitymanagement.bePeter
Start quering sysusers system table , sp_helprotect system stored procedure
"Peter Geelen" <PeterGeelen@.discussions.microsoft.com> wrote in message
news:F767749C-6397-4791-8986-FE3A28D25D41@.microsoft.com...
>I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000
>(in
> another domain 2).
> To map the users from the domains, I need to know which users are
> configured
> on the databases, plus which access rights and roles they have.
> Can I get a report of this?
> Does SQL have a default stored procedure for this?
> Best regards,
> -Peter-
>
> Peter Geelen
> System Engineer
> www.identitymanagement.be

reporting user access rights on SQL7

I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000 (in
another domain 2).
To map the users from the domains, I need to know which users are configured
on the databases, plus which access rights and roles they have.
Can I get a report of this?
Does SQL have a default stored procedure for this?
Best regards,
-Peter-
Peter Geelen
System Engineer
www.identitymanagement.bePeter
Start quering sysusers system table , sp_helprotect system stored procedure
"Peter Geelen" <PeterGeelen@.discussions.microsoft.com> wrote in message
news:F767749C-6397-4791-8986-FE3A28D25D41@.microsoft.com...
>I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000
>(in
> another domain 2).
> To map the users from the domains, I need to know which users are
> configured
> on the databases, plus which access rights and roles they have.
> Can I get a report of this?
> Does SQL have a default stored procedure for this?
> Best regards,
> -Peter-
>
> Peter Geelen
> System Engineer
> www.identitymanagement.be