Report Server Subscriptions - Job Owner

Hi,
I am trying to setup a subscription but I keep running into problems.
I setup the subscription fine, I see that it creates a job in SQL
Server. It shows a specific domain account as the owner and I can't
figure out why. The problem is that this account is in a different
domain and it's having problems authenticating when it runs. I did use
this account for the services and whatnot when I originally set it up,
but I've changed the account that SQL Server and SQL Server Agent run
under, but it still uses this account as the owner. The only other
thing I can think of is that the database owner of
SystemCenterReporting is still this account. Is this why it's listing
this account as the owner of the job? Where else could it be?
Thanks,
Bill"zinck74" <zinck74@.hotmail.com> wrote in message
news:1105995617.343495.223770@.f14g2000cwb.googlegr oups.com...
> Hi,
> I am trying to setup a subscription but I keep running into problems.
> I setup the subscription fine, I see that it creates a job in SQL
> Server. It shows a specific domain account as the owner and I can't
> figure out why. The problem is that this account is in a different
> domain and it's having problems authenticating when it runs. I did use
> this account for the services and whatnot when I originally set it up,
> but I've changed the account that SQL Server and SQL Server Agent run
> under, but it still uses this account as the owner. The only other
> thing I can think of is that the database owner of
> SystemCenterReporting is still this account. Is this why it's listing
> this account as the owner of the job? Where else could it be?
> Thanks,
> Bill

I have no idea about Reporting Services, but the SQL job owner is the SQL
login which creates the job. If RS is running under a certain domain account
to access MSSQL, then I guess that would be the account which owns the
subscription job.

The MS RS Deployment Guide is a bit vague - it seems to recommend a domain
account for the RS service, but doesn't say exactly what permissions it
needs:

http://www.microsoft.com/technet/pr...oy/rsdepgd.mspx

You might get a better response in microsoft.public.sqlserver.reportingsvcs.

Simon|||Thanks. The answer ended up being running the rsconfig.exe utility.
Didn't know this existed, but the account used with this is who the
owner is of the job.