Thanks for posting in our newsgroup.
From your description, I know you get the following error:
Source: Report Server Windows Service (MSSQLSERVER)
Event ID: 119
Error: Report Server Windows Service (MSSQLSERVER) has not been granted
access to the catalog content.
To fix this problem we need to repair SQL Databases, so please open a new
post in Microsoft.public.sql newsgroup.
Thanks for your understanding.
If you need further assistance, please don't hesitate to let me know.
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
This posting is provided "AS IS" with no warranties, and confers no rights.
<Thread-Topic: Report Server Windows Service has not been granted access to
<From: =?Utf-8?B?Y2s=?= < XXXX@XXXXX.COM >
<Subject: Report Server Windows Service has not been granted access to the..
<Date: Wed, 27 Jun 2007 04:10:01 -0700
<Message-ID: < XXXX@XXXXX.COM >
<X-Newsreader: Microsoft CDO for Windows 2000
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:46590
<NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
<I know this references SQL but it's on a SBS box and I'm more likely to
<Source: Report Server Windows Service (MSSQLSERVER)
<Event ID: 119
<Error: Report Server Windows Service (MSSQLSERVER) has not been granted
<access to the catalog content.
<How to I correct this issue, before considering the extreme uninstall
<post I've read here?
<Note I don't have any problems with the monitoring servi