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 Repor
ting 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?
--TomWhat 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[/co
lor]
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 s
tarted with an other profile you can have this problem...when you try to use
database Maintenance plan...

No comments:

Post a Comment