Post reply

Upgrade advisor: not sure what to do with reported problems.

  • January 25, 2013 at 10:17 am

    #273414

    I've got a server currently running SQL Server 2005 express, I need to upgrade it to 2012 std. I installed and ran the "upgrade advisor" to see if there are any potential problems, and the report found a couple of things that I don't know how to handle.

    Here's the relevant portion of the output from the report (in csv format):

    "Database Server","PreUpgrade","The SELECT permission was denied on the object 'sysproxies', database 'msdb', schema 'dbo'.","ACTIVEXSUBSYSTEM",

    "Database Server","PreUpgrade","The SELECT permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'.","SQLAGENTTOKENREPLACEMENT",

    The tool didn't offer any more information or suggestions of how to fix these, just indicated that they should be fixed before upgrade. Any wisdom on this?

    Thanks in advance...

  • January 26, 2013 at 6:57 am

    #1581282

    You can ignore them. SQL Express does not include SQL Server Agent and those tables are only relevant in support of Agent Jobs.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 28, 2013 at 8:03 am

    #1581642

    Thank you for your help!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply