I can not start Database Engine Tuning Advisor SQL Server 2014

Navigation
2

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.

ADDITIONAL INFORMATION:

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
source

1 answer

1

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
How can I undo my last commit in Git? [duplicate] Differences between SetCursorPosition and CursorTop, CursorLeft in C #