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...
Friday, March 30, 2012
Reporting Services Subscription Problem
Labels:
agent,
attempts,
database,
error91298,
following,
microsoft,
mysql,
oracle,
reporting,
reportsthe,
server,
services,
sql,
subscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment