| Author |
Message |
zinck74
Guest
|
 Posted:
Wed Jan 19, 2005 6:48 am Post subject:
Reporting Services Job Owner |
|
|
Hi,
I am trying to setup a subscription for my MOM reports 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 MOM accounts (Action, DAS, etc) are using this problem
account. Could this be it? I figured this was more of a Reporting
Services issue than a MOM issue so I don't see why any MOM accounts
would factor into this, but who knows. I've ried to change everything
I could, but is still popping up as the owner of the job. Any ideas?
Thanks,
Bill |
|
| Back to top |
|
 |
Bill Hodghead [MSFT]
Guest
|
| Posted:
Thu Jan 20, 2005 1:08 pm Post subject:
Re: Reporting Services Job Owner |
|
|
The SQL job your looking at is for grooming the warehouse and has nothing to
do with reporting.
The DTS job that moves data into the warehouse is a scheduled task that you
can find in the windows control panel.
The account that SQL Reporting Services uses for all the MOM reports to
access the data in the datawarehouse is set in the SCDW connection in the
root folder under http://localhost/reports.
"zinck74" <zinck74@hotmail.com> wrote in message
news:1106097163.492390.279540@z14g2000cwz.googlegroups.com...
| Quote: | Hi,
I am trying to setup a subscription for my MOM reports 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 MOM accounts (Action, DAS, etc) are using this problem
account. Could this be it? I figured this was more of a Reporting
Services issue than a MOM issue so I don't see why any MOM accounts
would factor into this, but who knows. I've ried to change everything
I could, but is still popping up as the owner of the job. Any ideas?
Thanks,
Bill
|
|
|
| Back to top |
|
|
zinck74
Guest
|
| Posted:
Tue Jan 25, 2005 12:41 am Post subject:
Re: Reporting Services Job Owner |
|
|
Actually the SQL job I was looking at was for reporting. The job name
is some sort of GUID that is produced when a new subscription is setup.
The answer was to run the rsconfig utility for reporting services and
specify a different account.
Thanks,
Bill |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in