Changing Service Account

We need to change the account that the ReportServer service runs under. Is
it as simple as changing the account that the service logs on with, or is it
more involved?It is more involved because the RS symmetric key is encrypted and stored in
the RS database using the user that the RS Windows service is running under.
If you change the Windows service account RS won't be able to decrypt this
key unless you follow the procedure below.
1. Delete the references to the old key: rskeymgmt -r <installation id> (the
installation ID can be found in the rsreportserver.config file
2. Stop IIS and the Report Server windows service
3. Change the account service runs under to a domain account that can log in
to your reporting database.
4. Start IIS and the Report Server windows service
5. Reapply the encryption key: rskeymgmt -a -f <filename from step
1> -p<password from step 1>.
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"dachrist" <dachrist@.discussions.microsoft.com> wrote in message
news:45676F56-51C9-45D7-9067-D289DE2D91AF@.microsoft.com...
> We need to change the account that the ReportServer service runs under.
Is
> it as simple as changing the account that the service logs on with, or is
it
> more involved?

changing default drives for data and logs

We have attached a SAN to one of our SQL Server 2000 boxes. I want the default drives for data and logs to change to the SAN. I tried to change the model database thru EM but that didn't work. I tried to detach model but that didn't work either.
Is it possible to change the default drives so that when a new database is created the data and log files will default to the SAN drives?
Thanks,
Dan D.
In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab.
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
> Thanks,
> --
> Dan D.
|||Wonderful. Thanks.
Dan D.
"Jacco Schalkwijk" wrote:

> In Enterprise Manager, right click the server, choose properties, and you
> can change the default locations for data and log files on the Database
> Settings tab.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> default drives for data and logs to change to the SAN. I tried to change the
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> created the data and log files will default to the SAN drives?
>
>

changing default drives for data and logs

We have attached a SAN to one of our SQL Server 2000 boxes. I want the default drives for data and logs to change to the SAN. I tried to change the model database thru EM but that didn't work. I tried to detach model but that didn't work either.
Is it possible to change the default drives so that when a new database is created the data and log files will default to the SAN drives?
Thanks,
--
Dan D.In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab.
--
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
> Thanks,
> --
> Dan D.|||Wonderful. Thanks.
--
Dan D.
"Jacco Schalkwijk" wrote:
> In Enterprise Manager, right click the server, choose properties, and you
> can change the default locations for data and log files on the Database
> Settings tab.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> > We have attached a SAN to one of our SQL Server 2000 boxes. I want the
> default drives for data and logs to change to the SAN. I tried to change the
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> >
> > Is it possible to change the default drives so that when a new database is
> created the data and log files will default to the SAN drives?
> >
> > Thanks,
> > --
> > Dan D.
>
>

changing default drives for data and logs

We have attached a SAN to one of our SQL Server 2000 boxes. I want the defau
lt drives for data and logs to change to the SAN. I tried to change the mode
l database thru EM but that didn't work. I tried to detach model but that di
dn't work either.
Is it possible to change the default drives so that when a new database is c
reated the data and log files will default to the SAN drives?
Thanks,
--
Dan D.In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab.
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
> Thanks,
> --
> Dan D.|||Wonderful. Thanks.
--
Dan D.
"Jacco Schalkwijk" wrote:

> In Enterprise Manager, right click the server, choose properties, and you
> can change the default locations for data and log files on the Database
> Settings tab.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> default drives for data and logs to change to the SAN. I tried to change t
he
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> created the data and log files will default to the SAN drives?
>
>