anushahanna
asked on
permissions for catalog content.
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
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
ASKER
how i do this in SSRS 2000 (on 2003 OS)
thanks
thanks
Start ? Programs ? SQL Server ? Reporting Services ? Configuration
you should it in there no ?
you should it in there no ?
ASKER
not in 2000...
ASKER
this is what we find,,
ssrs.jpg
ssrs.jpg
rsconfig -c -s<yourservername> -dreportserver -aSQL -u<username> -p<password>
can you try this please ?
can you try this please ?
ASKER
i will be using windows authentication.. and i will be running on local .. so should it be
rsconfig -c -dreportserver
rsconfig -c -dreportserver
even if you're running from local, you need to specify the server name
ASKER
OK - i tried
rsconfig -c -sPOSSAND2 -dreportserver
and got
Missing required argument: authtype
rsconfig -c -sPOSSAND2 -dreportserver
and got
Missing required argument: authtype
rsconfig -c -sPOSSAND2 -aWindows -dReportServer
the last switch -d, replace reportserver with the actual name of the reportserver database.
probably something like POSSANDReportServer
the last switch -d, replace reportserver with the actual name of the reportserver database.
probably something like POSSANDReportServer
ASKER
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. (rsReportServerDatabaseUna vailable) Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
is this related to the original problem?
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. (rsReportServerDatabaseUna
is this related to the original problem?
ok, can you just restart the reporting services service,
I'll get a couple of a commands for you in the mean time.
I'll get a couple of a commands for you in the mean time.
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 ?
are you able to logon to enterprise manager with your windows credentials and query the databases ?
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.
It's just a permissions issue now, once that's sorted it'll come back online.
ASKER
>>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
is that the service name : "ReportServer"
>>are you able to logon to enterprise manager with your windows credentials and query the databases
yes
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.
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.
ASKER
>>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
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
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.
ideally later, you'll change it later to a proper domain a/c.
by the way, if that doesn't work,
then change the a/c to use your windows authentication that you're logged on with.
then change the a/c to use your windows authentication that you're logged on with.
ASKER
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"
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"
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
to the reportserver databases. You can do that in enterprise manager, security.
getting there :-), that's a better error message at least
ASKER
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.
it also says now
Report Server cannot connect to the report server database.
ASKER
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...
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...
ASKER
>>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?
to the reportserver databases. You can do that in enterprise manager, security.
what exact permissions? do_owner?
can you  put it to sysadmin for the moment and you can change it after.
ASKER
yes right now it is the windows account profile i used, and it is already sysadmin.. that is what you meant, right?
RSReportServer.config
can you find that file, and post contents of it here ?
can you find that file, and post contents of it here ?
ASKER
with "local account", do you check where it says "Allow service to interact with desktop"
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..
but please change it from local account, to the windows account you're currently logged on with. that should do the trick I think..
ASKER
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>
ASKER
>>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..
tried both.. right now it is using windows account.. still failed..
ASKER
the path of the config file was C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSRe portServer .config Â
jfyi-
jfyi-
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks very much - it worked.
so it seems like we used 3 commands in all - rskeymgmt rsconfig and rsactivate
so it seems like we used 3 commands in all - rskeymgmt rsconfig and rsactivate
ASKER
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)...
so back to square 2 (you already helped get to where i am from square 1 - in a better place than when started)...
and initialize reporting services against the correct server\database