Community

Error running the SQL Server Database Tuning Advisor for non SA users

(Manvendra Singh) A user with db_owner access was trying to run the Database Tuning Advisor (DTA) on a newly built SQL Server, unfortunately he was getting this error message: “Failed to open a new connection. In order to start tuning application needs to create some objects in MSDB database. You h

Read More - Register for Free Membership