By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Report Server Subscriptions - Job Owner

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"zinck74" <zi*****@hotmail.com> wrote in message
news:11**********************@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/pro...y/rsdepgd.mspx

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

Simon
Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.