ReportServer Error - Please help!

How should I resolve the following error message when attempting to access
ReportServer? (i.e. http://wardteserv/reportserver or /reports)
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 'C.0.8.38'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase)So it looks like you installed a new version of RS 2005 and attached to an
older version of the DB. There isn't a supported way to upgrade from
intermin builds like this. In this case you are fairly lucky in that the
Database changes are fairly easy and you should be able to make them
manually.
Here they are:
In the ReportServer DB run the following T-SQL:
ALTER TABLE [dbo].[ServerParametersInstance] ADD [ParentID] nvarchar(32)
NULL
also update the following Stored procs:
CREATE PROCEDURE [dbo].[StoreServerParameters]
@.ServerParametersID nvarchar(32),
@.Path nvarchar(425),
@.CurrentDate datetime,
@.Timeout int,
@.Expiration datetime,
@.ParametersValues image,
@.ParentParametersID nvarchar(32) = NULL
AS
DECLARE @.ExistingServerParametersID as nvarchar(32)
SET @.ExistingServerParametersID = (SELECT ServerParametersID from
[dbo].[ServerParametersInstance] WHERE ServerParametersID =@.ServerParametersID)
IF @.ExistingServerParametersID IS NULL -- new row
BEGIN
INSERT INTO [dbo].[ServerParametersInstance]
(ServerParametersID, ParentID, Path, CreateDate, ModifiedDate, Timeout,
Expiration, ParametersValues)
VALUES
(@.ServerParametersID, @.ParentParametersID, @.Path, @.CurrentDate,
@.CurrentDate, @.Timeout, @.Expiration, @.ParametersValues)
END
ELSE
BEGIN
UPDATE [dbo].[ServerParametersInstance]
SET Timeout = @.Timeout,
Expiration = @.Expiration,
ParametersValues = @.ParametersValues,
ModifiedDate = @.CurrentDate,
Path = @.Path,
ParentID = @.ParentParametersID
WHERE ServerParametersID = @.ServerParametersID
END
GO
CREATE PROCEDURE [dbo].[GetServerParameters]
@.ServerParametersID nvarchar(32)
AS
DECLARE @.now as DATETIME
SET @.now = GETDATE()
SELECT Child.Path, Child.ParametersValues, Parent.ParametersValues
FROM [dbo].[ServerParametersInstance] Child
LEFT OUTER JOIN [dbo].[ServerParametersInstance] Parent
ON Child.ParentID = Parent.ServerParametersID
WHERE Child.ServerParametersID = @.ServerParametersID
AND Child.Expiration > @.now
GO
finally change the GetDBVersion stored proc to:
CREATE PROCEDURE [dbo].[GetDBVersion]
@.DBVersion nvarchar(32) OUTPUT
AS
set @.DBVersion = 'C.0.8.39'
GO
That should get you up and running.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:864DDB7A-6271-42D8-B8C5-E5EB71E5E374@.microsoft.com...
> How should I resolve the following error message when attempting to access
> ReportServer? (i.e. http://wardteserv/reportserver or /reports)
> 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 'C.0.8.38'. The expected
> version is 'C.0.8.39'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
>|||Can anyone please tell What does this table ServerParametersInstance does in SSRS 2005
From http://www.google.co.in/search?q=ServerParametersInstance&hl=en&safe=off&filter=
Posted via DevelopmentNow.com Group
http://www.developmentnow.com