Friday, March 30, 2012

Reporting Services Subscription Problem

I have a subscription set up in reporting services. When SQL Agent attempts to send out the subscription it reports
the following error:
[298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'DOMAIN\MACHINE$'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Where DOMAIN is the domain name and MACHINE is the name of the machine Reporting Service is running on.
Reporting services runs on a separate machine from SQL server. Both machine run Windows 2003 Server. Any suggestion about how to fix this?
--Tom
What is your sql server account running as? You may need to use sql auth to
connect to the report server database. You can use rsconfig.exe to change
this setting.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"tom777@.newsgroups.nospam" <anonymous@.discussions.microsoft.com> wrote in
message news:DF3DA2CA-BC34-471D-BDB0-E476CA043577@.microsoft.com...
> I have a subscription set up in reporting services. When SQL Agent
attempts to send out the subscription it reports
> the following error:
> [298] SQLServer Error: 8198, Could not obtain information about Windows NT
group/user 'DOMAIN\MACHINE$'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
> Where DOMAIN is the domain name and MACHINE is the name of the machine
Reporting Service is running on.
> Reporting services runs on a separate machine from SQL server. Both
machine run Windows 2003 Server. Any suggestion about how to fix this?
> --Tom
|||Look also to services MSSQLSERVER AND SQLSERVERAGENT... If they have been started with an other profile you can have this problem...when you try to use database Maintenance plan...

No comments:

Post a Comment