The database version (C.0.8.40) does not match your reporting services installation.

Posted by Wade on June 13, 2007
Commerce Server • SQL Server

As I was preparing a new virtual machine for Commerce Server 2007 (one capable of utilizing the Commerce Server Adapters with BizTalk Server 2006 and Data Warehousing), I ran into a problem when configuring SQL Server Reporting Services.


I had taken a virtual machine that I use as my base installation (e.g. Windows Server 2003 R2, IIS, .NET 2.0, Visual Studio 2005, and the SQL Server 2005 Database Engine) and was following the Commerce Server 2007 Pre-install Requirements and Procedures from the Installation Guide when I encoutered the following error:



The database version (C.0.8.40) does not match your reporting services installation.  You must upgrade your reporting services database.


Couldn’t generate the upgrade script.  There is no upgrade script available for this version.


Turns out that that I had installed Service Pack 2 after I originally installed the Database Engine but before I installed Reporting Services.  Consequently, when I went to configure a reporting database under the Database Setup step it complained that the versions were incorrect.


To resolve the problem, I simply ran the Microsoft SQL Server 2005 Service Pack 2 installation again, and updated the Reporting Services instance.  This allowed me to finish the configuration of SQL Reporting Services without any problems.


A simple little problem, but one that had me baffled for a little while (it’s probably just the sleep deprivation caused by the little one).


I hope this helps!

Comments (10)

  • Daniel Carrasco
    September 15th, 2007 16:18

    Thanks DUDE!!!!!!!!!!!!

    This fixed my problem exactly as you said!

    Thanks for taking the initiave to post the result.

    Daniel.-

  • Wade Wegner
    September 15th, 2007 16:22

    You bet! Glad it helped!!

  • Mirella
    October 9th, 2007 14:24

    Many many many THX!!!!!!!!!!!

    You save my day!!

    Mirella

  • Wade Wegner
    October 11th, 2007 03:13

    You bet!

  • Hemant
    January 24th, 2008 07:37

    Perfect Solution…..You saved my time….

  • Scott S.
    April 23rd, 2008 21:57

    This solution worked for me too. Many thanks.

  • Carlos B.
    April 24th, 2009 00:44

    It also worked for me. Thx!

  • tammy
    June 2nd, 2009 10:34

    I tried this with service pack 3 and I’m still stuck – getting the same error. Does this fix only work with sp2?

  • sumit
    July 8th, 2009 09:35

    I am stuck with same problem.

    My SQL Server already have SP3
    But reporting services doesnot have any SPs installed.they are on seperate servers.
    Now when i tried to install sp3 on reporting server, its failing during the authentication step.

    At the moment I have other components at SP2 level like SSIS, client components etc.
    and SSRS is Still SPless. I even tried installed SP1 for reporting services it didnot work.
    Note: At the moment my reporting services is working fine, but upgradation is not happening.
    Please provide your suggestions.

    Thanks
    Sumit

  • Kennymatic
    December 14th, 2009 19:00

    This helped save me quite a bit of time and got me going with Reporting Services after the database wouldn’t set up properly. Although I’m surprised I didn’t screw something up as I had previously applied SP3 (forgot and thought it was only SP2) and then proceeded to apply SP2 again.

    But all is good and its just a testing environment. Thanks!

Do you have anything to say?

« 
 »