SQL Server 2008 R2 Upgrade advisor fails to check one instance


  • I'm trying to run the Advisor on an instance on my SQL 2008 server.

    It runs and passes 2 of the instances and both the Reporting and Analysis services, but the problem is that at Rule 48 of 105 it stops and gives a status of Error, then in the report says everything is fine, which it can't be.

    I've double checked the permissions etc. and can't see any reason for this failure.

    I can happily log into each instance and the databases are all working as far as I can tell

    Friday, February 15, 2013 3:39 PM

All replies

  • Hi AbsoluteC,

    With the upgrade advisor report, please choose the instance or component under server, and choose “All issues” under “Filter by”, do you can see the error message now? Additionally, can you capture a screenshot of the error message? Please save the screenshot, upload to Skydrive and post the link here.

    Allen Li
    TechNet Community Support

    Monday, February 18, 2013 6:28 AM