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

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

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

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.;

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

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: Open IE, click Tools-> Internet Options. Click the "Security" tab, click "Trusted site", and click "Sites".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.On the IE "Security" tab, click "Custom level..." 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

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 YinMike Yin TechNet Community Support

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