sql server reporting services: how to change the user of the application pool and keep RS to work? -- sql server reporting services

how to change the user of the application pool and keep RS to work?

Jéjé
12/23/2004 8:32:29 AM

sql server reporting services:

Hi,

actually my application pool run under the network user, but I have to
change this to a specific user.
When I change my application pool, RS stop working.

How to do this?
What are the required steps?

Thanks.

Jerome.

Re: how to change the user of the application pool and keep RS to work?

Daniel Reib [MSFT]
12/29/2004 10:14:49 AM

You will need to reapply your symmetric key. Before changing the App Pool
Identity, run rskeymgmt to export the symmetric key. Once you change the
identity, run rskeymgmt to import the symmetric key. This should get you up
and running under the new identity.

Also, if you are using integrated security to connect to the RS catalog you
will have to give the new user permission to log in to SQL and place that
user in the RSExec role located in the two RS databases, plus master and
msdb.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]