February 10, 2009 at 3:18 pm
Hi. I have installed RSExecutionLog database from SS 2005 Reporting Services book. I have configured a job to execute 'RSExecutionLog_Update.dtsx' on a schedule however the package fails to execute returning error:
10/02/2009 22:04:05
LogSQL Agent (Current - 10/02/2009 22:04:00)
Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\First_Last', error code 0x54b. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Can anyone advise how I should correctly configure the schedule?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 3:29 am
Perhaps you can find the solution on http://msdn.microsoft.com/en-us/library/ms161561.aspx.
Pay special attention to step 10 from "configure and run the package" on that page!!
February 11, 2009 at 4:45 am
Thanks I will take a look.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply