Grant permissions to run Database Engine Tuning Advisor

• Minnesota - Viking

  Hall of Fame

  Points: 3469

  More actions

  August 21, 2012 at 12:28 pm

  #260323

  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]