Solved

permissions for catalog content.

Posted on 2010-11-09
35
1,242 Views
Last Modified: 2012-05-10
what does the error
RS has not been granted access to the catalog content.
could mean-

where can this be checked/changed in the DB or in the server?

thanks
0
Comment
Question by:anushahanna
  • 19
  • 16
35 Comments
 
LVL 10

Expert Comment

by:Humpdy
ID: 34091954
Can you run reporting services configuration
and initialize reporting services against the correct server\database
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34092801
how i do this in SSRS 2000 (on 2003 OS)

thanks
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34092964
Start ? Programs ? SQL Server ? Reporting Services ? Configuration

you should it in there no ?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34092971
not in 2000...
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34092983
this is what we find,,
ssrs.jpg
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093026
rsconfig -c -s<yourservername> -dreportserver -aSQL -u<username> -p<password>

can you try this please ?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093070
i will be using windows authentication.. and i will be running on local .. so should it be

rsconfig -c -dreportserver
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093092
even if you're running from local, you need to specify the server name

0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093107
OK - i tried
rsconfig -c -sPOSSAND2 -dreportserver
and got
Missing required argument: authtype
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093135
rsconfig -c -sPOSSAND2 -aWindows -dReportServer

the last switch -d, replace reportserver with the actual name of the reportserver database.
probably something like POSSANDReportServer
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093224
thanks very much - that worked!

before the error was
*Report Server has not been granted access to the catalog content.

after running the command, i get
*The RSReportServer.config file has been modified.
*Schedule and Delivery Processor cannot connect to the report server database.
 
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

is this related to the original problem?
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093246
ok, can you just restart the reporting services service,
I'll get a couple of a commands for you in the mean time.
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093291
ok, the windows logon, you are connected with, which you did the rsconfig command,
are you able to logon to enterprise manager with your windows credentials and query the databases ?

0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093408
also, just try changing the reporting services service account to use Local System instead of Network Service.
It's just a permissions issue now, once that's sorted it'll come back online.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093564
>>ok, can you just restart the reporting services service,

is that the service name : "ReportServer"

>>are you able to logon to enterprise manager with your windows credentials and query the databases

yes

0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093592
correct,
if you click on run, type in services.msc, you should see reporting services or report server.
double click on that, and change the logon for it to localsystem.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093619
>>just try changing the reporting services service account to use Local System instead of Network Service.

you mean here, right? will we be coming back to using Network Service? then i need to make sure first that i have the password secured and ready..
RS.bmp
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 10

Expert Comment

by:Humpdy
ID: 34093640
no, it'll be ok, you can change it to local system for good.
ideally later, you'll change it later to a proper domain a/c.
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093653
by the way, if that doesn't work,
then change the a/c to use your windows authentication that you're logged on with.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093835
thank you-

I change it to LOCAL SYSTEM

before changing, the error was
Schedule and Delivery Processor cannot connect to the report server database.

Now the error is
Schedule and Delivery Processor has not been granted access to the catalog content.

Do you see the play of words "cannot" vs "has not been granted"
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093868
ok, so you now need to give the local system account permissions in SQL
to the reportserver databases. You can do that in enterprise manager, security.

getting there :-), that's a better error message at least
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093920
OK- right after it said "Schedule and Delivery Processor has not been granted access to the catalog content."
it also says now
Report Server cannot connect to the report server database.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093949
I tried my own domain account...

it says "Schedule and Delivery Processor has not been granted access to the catalog content."

the account i used is sysadmin on the database.. so should have all permissions to access the database...
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34093962
>>so you now need to give the local system account permissions in SQL
to the reportserver databases. You can do that in enterprise manager, security.

what exact permissions? do_owner?
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34093984
can you  put it to sysadmin for the moment and you can change it after.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34094069
yes right now it is the windows account profile i used, and it is already sysadmin.. that is what you meant, right?

0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34094079
RSReportServer.config

can you find that file, and post contents of it here ?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34094086
with "local account", do you check where it says "Allow service to interact with desktop"
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34094098
no need for that no.
but please change it from local account, to the windows account you're currently logged on with. that should do the trick I think..
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34094114
here it is..
<Configuration>

	<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7WwWPP04NUWcRthO9VUsAAQAAAAiAAAAUgBlAHAAbwBy

AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAANIvvgDApcab3HYeZwjqi7wAAAAA

BIAAAKAAAAAQAAAACACJAsFRh1xm1smPZYuWhiABAADbg+kWiDk9uteP8V+Sw6UT7xQfbHqpRS98

gSPv6ixa4CaBS4oGCWU7ddlz/U0iXfmsOjwFDy4XKJPFg6ofV5uYOwZUtmXH4qhRxtXBfG97ysrL

KUvMo5QvnGKt5wHXppnNA0ni8+JSTVllHiHHd+rDxJQ7cqKe9RSpHECr4NxvpsnA6TOJ86ZrPeTH

vRnEUpwGNY/dXikIPfN38uj+8w4QQb9mLio1cE94kvom1IIk6U2upi2JVzRNScIYGLVaIBGzxdhE

Zxb2Ue1bpYDq78npHjVnXrUwv9Yct97M3NKfzJSxqbQWXltjGOLRl1K57sCOlWfah4P5SXyDtGUx

JzfTmWuL/oIwdzbuest/jtYbNQeUXhGNj8onFjkjFBO0NJMUAAAAsoqNxXzhfL8YzYBqfGWxe+t0

P+U=</Dsn>

	<ConnectionType>Default</ConnectionType>

	<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7WwWPP04NUWcRthO9VUsAAQAAAAiAAAAUgBlAHAAbwBy

AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHsA1r/vPumyPwHbEPU403oAAAAA

BIAAAKAAAAAQAAAA6qW//NPcagxpxPblBF56SSAAAACN7t01LQE95XVRoE+igqVcDs/gYVpykhAH

uWGj343IthQAAAAZLEWj5PbcBST3T5ZwJoooPibZ+g==</LogonUser>

	<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7WwWPP04NUWcRthO9VUsAAQAAAAiAAAAUgBlAHAAbwBy

AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFfyd1e9lSEFxDPAJfv/HAUAAAAA

BIAAAKAAAAAQAAAApx8VomxmpMqzHf68281IPhAAAABnreZTPNElBKchGATAzvhCFAAAAIHNVK1j

nIr2d4M+z+qxwzJuUin7

</LogonDomain>

	<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA7WwWPP04NUWcRthO9VUsAAQAAAAiAAAAUgBlAHAAbwBy

AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAKRozeQuqACdcEQL5PS1SloAAAAA

BIAAAKAAAAAQAAAAJCsQY8tcfz1ILAjon25H+hgAAACFU1cb380DfZjNDcoWPQpP8cpoIUPgOYkU

AAAAgTJN0pxpUdHHcz9mNfjL7E1m8eo=</LogonCred>

	<InstanceId>MSSQL.1</InstanceId>

	<InstallationID>{b06a53ac-f26e-4ecd-9073-dc6680f6aa8f}</InstallationID>

	<Add Key="SecureConnectionLevel" Value="0"/>

	<Add Key="InstanceName" Value="MSSQLSERVER"/>

	<Add Key="ProcessRecycleOptions" Value="0"/>

	<Add Key="CleanupCycleMinutes" Value="10"/>

	<Add Key="SQLCommandTimeoutSeconds" Value="60"/>

	<Add Key="MaxActiveReqForOneUser" Value="20"/>

	<Add Key="DatabaseQueryTimeout" Value="120"/>

	<Add Key="RunningRequestsScavengerCycle" Value="60"/>

	<Add Key="RunningRequestsDbCycle" Value="60"/>

	<Add Key="RunningRequestsAge" Value="30"/>

	<Add Key="MaxScheduleWait" Value="5"/>

	<Add Key="DisplayErrorLink" Value="true"/>

	<Service>

		<IsSchedulingService>True</IsSchedulingService>

		<IsNotificationService>True</IsNotificationService>

		<IsEventService>True</IsEventService>

		<PollingInterval>10</PollingInterval>

		<MemoryLimit>60</MemoryLimit>

		<RecycleTime>720</RecycleTime>

		<MaximumMemoryLimit>80</MaximumMemoryLimit>

		<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>

		<MaxQueueThreads>0</MaxQueueThreads>

		<UrlRoot>http://POSSAND2/ReportServer</UrlRoot>

		<UnattendedExecutionAccount>

			<UserName></UserName>

			<Password></Password>

			<Domain></Domain>

		</UnattendedExecutionAccount>

		<PolicyLevel>rssrvpolicy.config</PolicyLevel>

	</Service>

	<Extensions>

		<Delivery>

			<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">

				<MaxRetries>3</MaxRetries>

				<SecondsBeforeRetry>900</SecondsBeforeRetry>

				<Configuration>

					<FileShareConfiguration>

						<ExcludedRenderFormats>

							<RenderingExtension>HTMLOWC</RenderingExtension>

							<RenderingExtension>NULL</RenderingExtension>

						</ExcludedRenderFormats>

					</FileShareConfiguration>

				</Configuration>

			</Extension>

			<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">

				<MaxRetries>3</MaxRetries>

				<SecondsBeforeRetry>900</SecondsBeforeRetry>

				<Configuration>

					<RSEmailDPConfiguration>

						<SMTPServer>mail.state.pa.us</SMTPServer>

						<SMTPServerPort></SMTPServerPort>

						<SMTPAccountName></SMTPAccountName>

						<SMTPConnectionTimeout></SMTPConnectionTimeout>

						<SMTPServerPickupDirectory></SMTPServerPickupDirectory>

						<SMTPUseSSL></SMTPUseSSL>

						<SendUsing></SendUsing>

						<SMTPAuthenticate></SMTPAuthenticate>

						<From>POSSAND2</From>

						<EmbeddedRenderFormats>

							<RenderingExtension>MHTML</RenderingExtension>

						</EmbeddedRenderFormats>

						<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>

						<ExcludedRenderFormats>

							<RenderingExtension>HTMLOWC</RenderingExtension>

							<RenderingExtension>NULL</RenderingExtension>

						</ExcludedRenderFormats>

						<SendEmailToUserAlias>True</SendEmailToUserAlias>

						<DefaultHostName></DefaultHostName>

						<PermittedHosts></PermittedHosts>

					</RSEmailDPConfiguration>

				</Configuration>

			</Extension>

			<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>

		</Delivery>

		<Render>

			<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>

			<Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

			<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>

			<Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>

			<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>

			<Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

			<Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

			<Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>

			<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

			<Extension Name="HTMLOWC" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">

				<Configuration>

					<OWCConfiguration>

						<OWCDownloadLocation language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>

						<OWCDownloadLocation language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>

					</OWCConfiguration>

				</Configuration>

			</Extension>

		</Render>

		<Data>

			<Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

			<Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

			<Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

			<Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

		</Data>

		<Security>

			<Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>

		</Security>

		<Authentication>

			<Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>

		</Authentication>

		<EventProcessing>

			<Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

				<Event>

					<Type>ReportHistorySnapshotCreated</Type>

				</Event>

			</Extension>

			<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

				<Event>

					<Type>TimedSubscription</Type>

				</Event>

			</Extension>

			<Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

				<Event>

					<Type>SnapshotUpdated</Type>

				</Event>

			</Extension>

		</EventProcessing>

	</Extensions>

</Configuration>

Open in new window

0
 
LVL 6

Author Comment

by:anushahanna
ID: 34094119
>>but please change it from local account, to the windows account you're currently logged on with. that should do the trick I think

tried both.. right now it is using windows account.. still failed..
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34094135
the path of the config file was C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config  

jfyi-
0
 
LVL 10

Accepted Solution

by:
Humpdy earned 500 total points
ID: 34094162
http://POSSAND2/ReportServer

can you do a print screen of what you see when you go to this address please
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34094558
Thanks very much - it worked.

so it seems like we used 3 commands in all - rskeymgmt rsconfig and rsactivate
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34095638
Humpdy, sorry i jumped too quickly.. it worked only when given credentials.. but users are all getting prompts and should not be...

so back to square 2 (you already helped get to where i am from square 1 - in a better place than when started)...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now