Tuesday, November 26, 2013

Upgrade Error - Valid Database compatibility level and successful connection rule

Recently when I was trying to upgrade an SQL Server 2008 R2 instance to SQL Server 2012, I was presented with an error during the upgrade rules validation.
The error message was, "The report server database is not a supported compatibility level or a connection cannot be established."



When I checked the reporting server databases, the databases had the right compatibility level.
Then I found that the SQL Server Name defined in the Reporting services configuration manager was not existing. This caused the validation rule to fail.
After changing the SQL Server Name to right server name, all the validations passed and it let me upgrade the SQL Server Instance. 

16 comments:

  1. AnonymousJanuary 9, 2014 at 7:33 AM

    thank you for the solution, i have same problem and now all passed fixed ready to upgrade from SS2008R2 SS2012, may God blessing you all.

    ReplyDelete
  2. AnonymousFebruary 6, 2014 at 5:07 AM

    thank you, i have had the same problem and I resolved it, but know I have No customs security extensions failed

    ReplyDelete
  3. AnonymousMarch 8, 2014 at 7:55 AM

    Thanks - I had the same problem...

    ReplyDelete
  4. SalesApex DeveloperApril 10, 2014 at 10:22 PM

    Thanks, I had this exact error upgrading one of our server to SQL2014. You saved me a lot of time and effort. Much appreciated.

    ReplyDelete
  5. AnonymousApril 24, 2014 at 7:34 PM

    Thanks

    ReplyDelete
  6. AnonymousMay 7, 2014 at 6:20 AM

    saved my a$$ thanks so much!!

    ReplyDelete
  7. VU3NGBNovember 28, 2014 at 8:40 AM

    Thanks

    ReplyDelete
  8. UnknownJanuary 22, 2015 at 6:07 AM

    Mil Gracias, me ayudó muchísimo... resulta que cuando instalé el servidor la pc se llamaba SERVIDOR, luego se cambio a SERVER, al momento de instalar esos nombres se guardan y habido que cambiarlos manualmente como tu dices. gracias

    ReplyDelete
  9. David LamblFebruary 24, 2015 at 12:51 AM

    This helped me. Thank you!

    ReplyDelete
  10. KeremMay 14, 2015 at 1:47 AM

    Thanks mate, you saved hours for me ;)

    ReplyDelete
  11. ZachariahAugust 26, 2015 at 3:19 PM

    May the eternal blessing of the Tao surround and support you, and your family find favour with all the beauty the universe can provide, your guide is excellent and most effective.

    ReplyDelete
  12. UnknownOctober 13, 2015 at 12:59 PM

    Gracias!

    ReplyDelete
  13. Byron WrightDecember 6, 2015 at 4:30 AM

    Thank you. First hit in the Google search. I would never have figured that out on my own.

    ReplyDelete
  14. ShailendraJanuary 14, 2016 at 1:03 PM

    Thank You. issue resolved....

    ReplyDelete
  15. drcomputerFebruary 4, 2016 at 11:48 PM

    Teşekkürler Üstat

    ReplyDelete
  16. -=JLK=-February 20, 2016 at 7:42 AM

    Wow, thanks for taking the time to post this solution. Mine didn't seem to be wrong, but just walking through the database connection wizard eliminated the problem.

    ReplyDelete