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]