Grant permissions to run Database Engine Tuning Advisor

  • I have a Microsoft SQL Server 2005 - 9.00.5057.00 (X64)

    Trying to grant permissions to a user who is a member of the fixed db role 'db_owner', so that the user can run DTA on his own. But the user is unable to run DTA.

    Attached is the error message the user is receiving.

    I'm doing/did/re-did what Microsoft is suggesting.

    Please suggest, I heard that some cleanup (previous DTA history) might be required on servers that were upgraded from earlier versions.

    [font="Verdana"]
    Today is the tomorrow you worried about yesterday:-)
    [/font]

Viewing post 1 (of 1 total)

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