I can not start Database Engine Tuning Advisor SQL Server 2014


Good morning, whenever I try to log in I get this error, do you know how to fix it?

Database Engine Tuning Advisor

Failed to open a new connection.


In order to perform tuning you have to be a member of sysadmin fixed server role (DTAClient)

Thank you very much for the help.

asked by AngelPR 21.07.2017 в 15:32

1 answer


The user with whom you are trying to use the Tuning Advisor does not have the sysadmin role. Connect to the instance, then go to security, logins, double click on the one you want and assign it that role.

answered by 24.07.2017 в 20:32