SQLTeam.com | Weblogs | Forums

Database Engine Tuning Advisor

sql2014

#1

Hello all,

I am taking my first steps into computer science and I am starting out in SQL server 2014.

--I am receiving a error message and was hoping someone would have a solution (preferable a hyperlink if something needs to be installed)

-- Message
Failed to open a new connection.
Additional information:
Data base tuning advisor does not support SQL Express. (DTAClient)


#2

Database Tuning Advisor is not supported in Sql Express edition. It is supported in standard,enterprise,developer and evaluation editions. You can refer this link for the different features supported in different editions.

https://msdn.microsoft.com/en-us/library/ms174202.aspx


#3

If you would like to use DTA, you will need to purchase and install Developer edition. You could do a free trial though if you just want to play around with it for a bit.