Hello, I am trying to configure Reporting Services after installing reporting services and installing SP4. Prior to reporting services I had the base install of SQL Server with the latest patches. In the configuration manager I went to database setup, selected the server and created a new database and when prompted to upgrade I chose to upgrade. Now when I go to the report server website I get this error The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) I tried re-installing SP4, deleting the reporting server databases and re-creating them. Also tried naming them something different than the default. Everything I am finding on google is basically telling me to do what I have been trying. Any ideas?

Have a read of the following to see if they fix your problem http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/79fb0c96-41b2-4785-987a-fd37fa410e02 Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

I tried that, I ended up fixing that issue and finding another. I fixed that issue by changing the default database for the service account to the reporting services database, it was set to master. My new issue is that I get this error The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. In the config file the login info is blank. To fix this I tried 1. Opened Reporting Services Configuration Manager 2. Selected "Windows Service Identity" 3. Filled in service account info using DOMAIN\username format, entered password 4. Clicked apply In the task status it gave all green check marks, but on the left hand side it has the not configured icon next to the Windows Service identity. When I go back to "Windows Service Identity" it has the correct service account listed. It also says not configured next to the web service identity even though I filled that out. I tried using the rsconfig tool but got the error using 2 different tries rsconfig -c -s <SERVERNAME> -i <REPORTINGINSTANCE> -d ReportServer -a Windows -u DOMAIN\username -p password rsconfig -c -s <SERVERNAME> -d ReportServer -a Windows -u DOMAIN\username -p password both tries give the following error No reporting Services instance found on localhost. The reporting services instance is not the same as the sql server instance. sql server instance is default, reporting services is named. This is due to prior to putting 2005 reporting on, I installed 2008 sql server with reporting and when I went to add 2005 it would not let me use the same instance as the 2005 server. Any ideas on how to fix this error The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file.

Hello, Navigate to the following location: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer Edit rsreportserver.config file in notepad...Make sure that you have specified your account name... Once at Ln 44 Once at Ln 55 This is according to my config file... Kind Regards, WCC44

Do you mean <LogonUser></LogonUser> <LogonDomain></LogonDomain> <LogonCred></LogonCred> These fields were empty, but filling them in did nothing. or the login fields under <UnattendedExecutionAccount>, those fields are filled in but everything is encrypted so I cant see what values it has. It looks like it is connecting to the database because using the profilers it looks like it executes 2 sql statements when i try to load the website. They are exec sp_executesql N' declare @BatchID uniqueidentifier set @BatchID = newid() UPDATE [Notifications] WITH (TABLOCKX) SET [BatchID] = @BatchID, [ProcessStart] = GETUTCDATE(), [ProcessHeartbeat] = GETUTCDATE() FROM ( SELECT TOP 4 [NotificationID] FROM [Notifications] WITH (TABLOCKX) WHERE ProcessStart is NULL and (ProcessAfter is NULL or ProcessAfter < GETUTCDATE()) ORDER BY [NotificationEntered] ) AS t1 WHERE [Notifications].[NotificationID] = t1.[NotificationID] select top 4 -- Notification data N.[NotificationID], N.[SubscriptionID], N.[ActivationID], N.[ReportID], N.[SnapShotDate], N.[DeliveryExtension], N.[ExtensionSettings], N.[Locale], N.[Parameters], N.[SubscriptionLastRunTime], N.[ProcessStart], N.[NotificationEntered], N.[Attempt], N.[IsDataDriven], SUSER_SNAME(Owner.[Sid]), Owner.[UserName], -- Report Data O.[Path], O.[Type], SD.NtSecDescPrimary, N.[Version] from [Notifications] N with (TABLOCKX) inner join [Catalog] O on O.[ItemID] = N.[ReportID] inner join [Users] Owner on N.SubscriptionOwnerID = Owner.UserID left outer join [SecData] SD on O.[PolicyID] = SD.[PolicyID] AND SD.AuthType = @AuthType where N.[BatchID] = @BatchID ORDER BY [NotificationEntered] ',N'@AuthType tinyint',@AuthType=1 AND declare @BatchID uniqueidentifier set @BatchID = NEWID() UPDATE [Event] WITH (TABLOCKX) SET [BatchID] = @BatchID, [ProcessStart] = GETUTCDATE(), [ProcessHeartbeat] = GETUTCDATE() FROM ( SELECT TOP 4 [EventID] FROM [Event] WITH (TABLOCKX) WHERE [ProcessStart] is NULL ORDER BY [TimeEntered] ) AS t1 WHERE [Event].[EventID] = t1.[EventID] select top 4 E.[EventID], E.[EventType], E.[EventData] from [Event] E WITH (TABLOCKX) where [BatchID] = @BatchID ORDER BY [TimeEntered] Any other things I should try?

Hello, Please review this solution... http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/ac4a55f7-6fc8-4099-8de4-6f99ebf0d8da/ Kind Regards, WCC44

Setting the <WebServiceAccount> to the service account fixed it.