locked
The permissions granted to user 'x' are insufficient for performing this operation. (rsAccessDenied) - no workaround works for me RRS feed

  • Question

  • Installed SSRS 2008 R2 Express with Advanced Services today on Windows 7 Ultimate SP1.  Installed latest updates

    Computer name is POIPU.

    User "x" has Windows admin authority on POIPU.

    SQL Server Reporting Services windows service is started.

    rsreportserver.config (in C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\ReportServer) has: 

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

    RS Config Manager shows:

        Virtual Directory = ReportServer

        TCP Port 80

        No SSL, no SSL port

        URL: http://POIPU:80/ReportServer

    Click">http://POIPU:80/ReportServer

    I click the URL and am prompted for userid/password.

    Type userid x and associated password. Domain is POIPU.

    Get the "permission granted to user 'x' are insufficient" error.

    Open IE9 and type URL: http://localhost/reportserver

    Type userid x and associated password. Domain is POIPU.

    Get same error.

    Why?

    DadCat

    Monday, August 6, 2012 10:42 PM

Answers

  • Hi DadCat,

    Thanks for your posting.

    Based on the current information, the insufficient permission issue when accessing the Web Service URL may be caused by the Internet Explorer security settings. At this time, I suggest that you refer to the following steps:

    1. Open IE, click Tools-> Internet Options.
    2. Click the "Security" tab, click "Trusted site", and click "Sites".
    3. Make sure the "Require server verification (https:) for all sites in this zone" option is unchecked, and then add http://POIPU to the trusted sites list. Click Close.
    4. On the IE "Security" tab, click "Custom level..."
    5. Scroll down the scrollbar and locate the "User Authentication" item, make sure either "Automatic logon in Intranet zone" or "Automatic logon with current user name and password" is checked.

    After it is done, restart the IE as administrator and type the Web Service URL in the address bar to access it again.

    Hope this helps.

    Regards,
    Mike Yin

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.


    Mike Yin

    TechNet Community Support

    • Proposed as answer by Mike Yin Thursday, August 16, 2012 5:32 PM
    • Marked as answer by Mike Yin Sunday, August 19, 2012 3:51 PM
    Monday, August 13, 2012 6:05 PM

All replies

  • Hi,

    Did you try the suggestion work-around in this blog post? http://shahfaisalmuhammed.blogspot.com/2011/10/reporting-services-access-error-caused.html

    Also, try adding the Report Server URL to your trusted sites in Internet Explorer.


    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com


    Monday, August 6, 2012 11:28 PM
  • Hi There

    Please also have a look on this thread

    http://tanveeronline.blogspot.co.nz/2011/07/ssrs-2008-r2-unable-to-connect-to.html

    http://social.msdn.microsoft.com/Forums/hu-HU/sqlreportingservices/thread/f8a0a3f5-3985-4356-8404-3b408f790747

    http://www.networksteve.com/enterprise/topic.php?TopicId=24217

    In the last section of this thread it get resolved by

    "Changing the ports. Configured TCP port to 9000 and SSL port to 9001.
    And then

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

    Its value was 2, changed it to 0."

    Please also have a look on this

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/11ce1dfd-38da-469b-a45a-abe69646d9e6/

    Many thanks

    Syed Qazafi Anjum

    Tuesday, August 7, 2012 1:24 AM
  • I read those threads before I posted the problem, and none helped.

    I set http://localhost as a trusted site, ran IE9 as administrator, and verified that SecureConnectionLevel = 0. Didn't fix the problem.

    The report server log is below. Could the connection errors related to the report server database being in "script update mode" (in bold) be causing my problem? 

    I can't tell if it retried successfully or not...

    DadCat

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1617.00 ((KJ_RTM_GDR).110422-1901 )</Product>
      <Locale>English (United States)</Locale>
      <TimeZone>Central Daylight Time</TimeZone>
      <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\Logfiles\ReportServerService__08_07_2012_08_33_55.log</Path>
      <SystemName>POIPU</SystemName>
      <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
      <OSVersion>6.1.7601</OSVersion>
      <ProcessID>6100</ProcessID>
      <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!1100!08/07/2012-08:33:55:: i INFO: CLR runtime is initialized.
    rshost!rshost!1100!08/07/2012-08:33:55:: i INFO: Derived memory configuration based on physical memory as 8370596 KB
    appdomainmanager!DefaultDomain!1bac!08/07/2012-08:33:55:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing AuthenticationTypes to '5'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
    library!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
    resourceutilities!DefaultDomain!10f0!08/07/2012-08:33:55:: i INFO: Reporting Services starting SKU: Express
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension XML is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension NULL is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension CSV is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension MHTML is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension SQLAZURE is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension SQLPDW is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension OLEDB is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension OLEDB-MD is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension ORACLE is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension ODBC is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension XML is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension SHAREPOINTLIST is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension SAPBW is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension ESSBASE is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Extension TERADATA is not supported on this edition of Reporting Services and has been removed
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Using report server external url http://POIPU:80/ReportServer.
    configmanager!DefaultDomain!10f0!08/07/2012-08:33:56:: i INFO: Using url root http://POIPU:80/ReportServer.
    rshost!rshost!10f0!08/07/2012-08:33:56:: i INFO: Configuring maxPhysicalCpu=1, minLogicalCpu=0
    rshost!rshost!10f0!08/07/2012-08:33:56:: i INFO: Logical processor per physical processor 8
    rshost!rshost!10f0!08/07/2012-08:33:56:: i INFO: Maximum logical CPU is 8
    library!DefaultDomain!10f0!08/07/2012-08:33:58:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
       --- End of inner exception stack trace ---;
    servicecontroller!DefaultDomain!10f0!08/07/2012-08:33:58:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time.
    appdomainmanager!DefaultDomain!10f0!08/07/2012-08:33:58:: i INFO: Appdomain:2 WindowsService_0 started.
    library!WindowsService_0!10f0!08/07/2012-08:33:58:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
       --- End of inner exception stack trace ---;
    servicecontroller!WindowsService_0!10f0!08/07/2012-08:33:58:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time.
    resourceutilities!WindowsService_0!10f0!08/07/2012-08:33:59:: i INFO: Reporting Services starting SKU: Express
    library!WindowsService_0!1544!08/07/2012-08:33:59:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time.
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
       --- End of inner exception stack trace ---;
    rshost!rshost!1bc4!08/07/2012-08:33:59:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\ReportServer.
    rshost!rshost!1bc4!08/07/2012-08:33:59:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    rshost!rshost!14b0!08/07/2012-08:33:59:: i INFO: Registered url=http://+:80/Reports_SQLEXPRESS/, vdir=/Reports_SQLEXPRESS, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\ReportManager.
    rshost!rshost!14b0!08/07/2012-08:33:59:: i INFO: Currently registered url http://+:80/Reports_SQLEXPRESS/ on endpoint 3
    rshost!rshost!16f0!08/07/2012-08:33:59:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\ReportServer\ReportBuilder.
    resourceutilities!DefaultDomain!10f0!08/07/2012-08:33:59:: i INFO: Maximum memory limit is 4096Mb
    rshost!rshost!10f0!08/07/2012-08:33:59:: i INFO: Derived memory configuration based on physical memory as 4194304 KB
    servicecontroller!DefaultDomain!bf8!08/07/2012-08:33:59:: i INFO: Total Physical memory: 8571490304
    library!WindowsService_0!1544!08/07/2012-08:33:59:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time.
    library!WindowsService_0!1544!08/07/2012-08:33:59:: e ERROR: ServiceStartThread: Attempting to start service again...
    rpcserver!DefaultDomain!17cc!08/07/2012-08:33:59:: i INFO: Process monitoring started.
    rpcserver!DefaultDomain!1544!08/07/2012-08:33:59:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!1544!08/07/2012-08:33:59:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.SQLEXPRESS'
    configmanager!DefaultDomain!1544!08/07/2012-08:34:14:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!1544!08/07/2012-08:34:14:: i INFO: Using report server external url http://POIPU:80/ReportServer.
    configmanager!DefaultDomain!1544!08/07/2012-08:34:14:: i INFO: Using url root http://POIPU:80/ReportServer.
    rpcserver!DefaultDomain!1544!08/07/2012-08:34:14:: i INFO: RPC Server stopped.
    servicecontroller!DefaultDomain!1544!08/07/2012-08:34:14:: i INFO: RPC Server stopped.
    rshost!rshost!f84!08/07/2012-08:34:14:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    rshost!rshost!f84!08/07/2012-08:34:14:: i INFO: Currently registered url http://+:80/Reports_SQLEXPRESS/ on endpoint 3
    rshost!rshost!f84!08/07/2012-08:34:14:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SQLEXPRESS\Reporting Services\ReportServer\ReportBuilder.
    rshost!rshost!bf8!08/07/2012-08:34:14:: i INFO: Derived memory configuration based on physical memory as 4194304 KB
    servicecontroller!DefaultDomain!bf8!08/07/2012-08:34:14:: i INFO: Recycling the service from the default domain
    library!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Catalog SQL Server Edition = Express
    crypto!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
    crypto!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Exporting public key
    crypto!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Performing sku validation
    crypto!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Importing existing encryption key
    configmanager!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Using report server external url http://POIPU:80/ReportServer.
    configmanager!WindowsService_0!1544!08/07/2012-08:34:14:: i INFO: Using url root http://POIPU:80/ReportServer.
    rshost!rshost!bf8!08/07/2012-08:34:14:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.
    appdomainmanager!DefaultDomain!bf8!08/07/2012-08:34:14:: i INFO: Appdomain:3 WindowsService_1 started.
    resourceutilities!WindowsService_1!bf8!08/07/2012-08:34:14:: i INFO: Reporting Services starting SKU: Express
    servicecontroller!WindowsService_0!bf8!08/07/2012-08:34:14:: i INFO: Service controller exiting.
    appdomainmanager!DefaultDomain!bf8!08/07/2012-08:34:14:: i INFO: Appdomain:2 unregistered.
    appdomainmanager!DefaultDomain!bf8!08/07/2012-08:34:14:: i INFO: Appdomain:2 WindowsService_0 unloading.
    appdomainmanager!DefaultDomain!14b0!08/07/2012-08:34:14:: i INFO: AppDomain:2 0 pending unload(s)
    library!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: Catalog SQL Server Edition = Express
    crypto!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
    crypto!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: Exporting public key
    crypto!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: Performing sku validation
    crypto!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: Importing existing encryption key
    configmanager!WindowsService_1!f84!08/07/2012-08:34:14:: w WARN: Restricted feature: Scheduling
    configmanager!WindowsService_1!f84!08/07/2012-08:34:14:: w WARN: Restricted feature: Delivery
    configmanager!WindowsService_1!f84!08/07/2012-08:34:14:: w WARN: Restricted feature: Scheduling
    dbpolling!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_1!16f0!08/07/2012-08:34:14:: i INFO: PollingMaintenance: Polling started
    resourceutilities!WindowsService_1!16f0!08/07/2012-08:34:14:: i INFO: Maximum memory limit is 4096Mb
    rpcserver!DefaultDomain!f84!08/07/2012-08:34:14:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!f84!08/07/2012-08:34:14:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.SQLEXPRESS'
    appdomainmanager!WindowsService_1!f84!08/07/2012-08:34:14:: i INFO: Appdomain:3 WindowsService_1 initialized.
    library!WindowsService_1!1880!08/07/2012-08:44:14:: i INFO: Call to CleanBatch()
    library!WindowsService_1!1880!08/07/2012-08:44:15:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!1880!08/07/2012-08:44:15:: i INFO: Call to CleanBatch() ends
    appdomainmanager!DefaultDomain!1544!08/07/2012-08:46:11:: i INFO: Appdomain:4 ReportServer_SQLEXPRESS_0-1-129888207713141231 started.
    appdomainmanager!ReportServer_0-1!1544!08/07/2012-08:46:15:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!1544!08/07/2012-08:46:16:: i INFO: Appdomain:4 ReportServer_SQLEXPRESS_0-1-129888207713141231 initialized (#1).
    webserver!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Reporting Web Server started
    resourceutilities!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Reporting Services starting SKU: Express
    resourceutilities!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Maximum memory limit is 4096Mb
    library!ReportServer_0-1!1544!08/07/2012-08:46:28:: Call to GetItemTypeAction(/).
    library!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Catalog SQL Server Edition = Express
    crypto!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
    crypto!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Exporting public key
    crypto!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Performing sku validation
    crypto!ReportServer_0-1!1544!08/07/2012-08:46:28:: i INFO: Importing existing encryption key
    library!ReportServer_0-1!1544!08/07/2012-08:46:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'POIPU\dathom' are insufficient for performing this operation.;
    library!ReportServer_0-1!1a6c!08/07/2012-08:49:34:: Call to GetItemTypeAction(/).
    library!ReportServer_0-1!1a6c!08/07/2012-08:49:34:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'POIPU\dathom' are insufficient for performing this operation.;

    Tuesday, August 7, 2012 2:10 PM
  • OK, I decided to start over...

    I un-installed SQL Server and cleaned-up anything related to SQL Server... even renamed the old \Program Files\SQL Server and \Program Files (x86)\SQL Server folders, then rebooted...

    Did a fresh install of SQL Server 2008 R2 Express with Advanced Services from an .exe I downloaded from MS this week. Installed on Win 7 Ultimate 64 with SP1 and latest updates.

    Accepted all default settings. Rebooted.

    Checked that SecureConnectionLevel = 0 in rsreportserver.config.

    Verified ReportServer$SQLEXPRESS and ReportServer$SQLEXPRESSTempDB databases were present, and I could access them via SSMS.

    Opened Reporting Services Configuration Manager and verified the settings under Web Service URL: 

       Virtual Directory = ReportServer_SQLEXPRESS

       IP Address: All Assigned

       TCP Port: 80

       SSL: not selected

       Web Service URLs: http://POIPU:80/ReportServer_SQLEXPRESS

    Clicked on the web service URL (above), entered my userid (which has administrative permissions) and password,  and got the 'permissions are insufficient' error.

    Started Reporting Services Configuration Manager  as administrator. Got same error.

    Started IE9 64-bit as administrator. Browsed to http://localhost/Report_Server_SQLEXPRESS   Got same error.

    Anyone know of a real solution to this problem?

    DadCat

    Tuesday, August 7, 2012 3:50 PM
  • Hi DadCat,

    Thanks for your posting.

    Based on the current information, the insufficient permission issue when accessing the Web Service URL may be caused by the Internet Explorer security settings. At this time, I suggest that you refer to the following steps:

    1. Open IE, click Tools-> Internet Options.
    2. Click the "Security" tab, click "Trusted site", and click "Sites".
    3. Make sure the "Require server verification (https:) for all sites in this zone" option is unchecked, and then add http://POIPU to the trusted sites list. Click Close.
    4. On the IE "Security" tab, click "Custom level..."
    5. Scroll down the scrollbar and locate the "User Authentication" item, make sure either "Automatic logon in Intranet zone" or "Automatic logon with current user name and password" is checked.

    After it is done, restart the IE as administrator and type the Web Service URL in the address bar to access it again.

    Hope this helps.

    Regards,
    Mike Yin

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.


    Mike Yin

    TechNet Community Support

    • Proposed as answer by Mike Yin Thursday, August 16, 2012 5:32 PM
    • Marked as answer by Mike Yin Sunday, August 19, 2012 3:51 PM
    Monday, August 13, 2012 6:05 PM
  • Hi DadCat,

    I have marked my last post as answer. If it doesn't help, please unmark it, and then elaborate the issue for further analysis.

    Regards,
    Mike Yin


    Mike Yin

    TechNet Community Support

    Sunday, August 19, 2012 3:53 PM
  • Hi,

    log onto the Report Manger in IE as the administrator,

    go to Site Settings, Security, new role assignment, and add your user 'x'.

    then go to Folder Settings, and add your user that you wish to have access, and grant them whichever permission they require...

    hope this helps

    Stephen

    Tuesday, October 23, 2012 2:18 PM
  • Dadcat,

    In case you have not got an answer to this yet then there is something you can try. I have also like you looked into most of these options (I have ssrs 2012 on windows 8). I took 6 hours to get it solved. But then try giving the user full control on the reportingservices folder under the Microsoft sql server folder. For me that did the trick


    Ramachandran

    Saturday, November 2, 2013 12:54 PM