Can't Open Database Tuning Adviser Tool

Question

Hello,

            This morning I tried to use DTA tool, but when In try to connect following error occured

When I proceed by clicking OK I got following error

I tried different solutions that are available on forum (running script) but still I didn't managed to resolve the issue. Please let me know, if their is any alternative to solve this issue. Thanks in advance.

Answer 1

Hi,

Can you provide the followings please?

• OS version + patch level,
• sql server version + patch level,
• DTA version + patch level
• DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS output.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me

Answer 2

Hi Janos,

                I'm using Windows Server 2008 SP1 and sql server: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1), and output of DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS says Commands completed successfully. 

Krishna

                

Answer 3

Hi,

Eval edition allows 6 month trial. Is that possible that you are over 6 months? Did you try to update SQL Server with the latest SP?

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me

Answer 4

Hi,

       I just Installed Eval edition last month. Even in Sql Server 2012 Eval edition I'm facing same problem.

Krishna 

Answer 5

Can zou check this thread please? http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/287bf86c-ec72-410c-b916-933c687c6269

It may help.

Janos

 

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me

Answer 6

Hi Kriuk,

When we are running DTA, it will looking for the following in MSDB:Tables:
'DTA_input',
'DTA_progress',
'DTA_output',
'DTA_tuninglog',
'DTA_reports_database',
'DTA_reports_partitionfunction',
'DTA_reports_partitionscheme',
'DTA_reports_table',
'DTA_reports_tableview',
'DTA_reports_query',
'DTA_reports_querytable',
'DTA_reports_querydatabase',
'DTA_reports_index',
'DTA_reports_queryindex',
'DTA_reports_column',
'DTA_reports_indexcolumn',
'DTA_reports_querycolumn'

Stored Procedures:
'sp_DTA_add_session',
'sp_DTA_delete_session',
'sp_DTA_help_session',
'sp_DTA_update_session',
'sp_DTA_get_tuninglog',
'sp_DTA_update_session',
'sp_DTA_get_session_report',
'sp_DTA_get_tuninglog',
'sp_DTA_get_session_tuning_results',
'sp_DTA_set_interactivestatus'

These objects were missing from the server that was failing, you can scripted them from the server that was working, and Database Tuning Advisor will work.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.