SQL server reporting services : Database version (C.0.8.40) does not match
Al hacer clic en el boton “Upgrade” de la base de datos del ReportingService de SQL 2005 nos encontramos con dos errores:
"Verify Database Version" First Yellow "!" : The database version (C.0.8.40) does not match your reporting services installation. You must upgrade your reporting services database. "Create Upgrade Script for Database Version" Second Yellow "!" say: Couldn't generate the upgrade script. There is no upgrade script available for this version.
Mas alla de estas advertencias, la base queda marcada en “Database Setup” con una “X” roja
Esto se presenta al instlar el Reporting Service despues de haber aplicado el SP1 al SQL Server 2005.
Abrir la línea de comandos en el servidor SQL
Ejecutar este comando:
rsconfig -c -s < SQLSERVERNAME > -d reportserver -a Windows -u < MYDOMAIN\MYACCOUNT > -p < PASSWORD >
Event Type: Error Event Source: Report Server Windows Service (MSSQLSERVER) Event Category: Startup/Shutdown Event ID: 117 Date: 7/8/2011 Time: 3:14:33 PM User: N/A Computer: S001084 Description: The report server database is an invalid version. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.