DTA (Database Engine Tuning Advisor) error when opening connection

Hi all,

I've got some problem to launch DTA, after the connection, I've got this message :

===================================

Failed to open a new connection.

===================================

Failed to initialize MSDB database for tuning (exit code: -1). (DTAClient)

Program Location:

at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeTuningParametersDatabase()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeConnection()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.Connect()
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServerInternal(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServer(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.connectButton_Click(Object sender, EventArgs e)

===================================

Failed to establish a connection to the server.

Any ideas ?

Information : SQL Server 2005 beta 2 Enterprise edition CTP June 2005

Thanks for your futurse answers.

Hello Herve
This was a known problem in Beta 2 Yukon bits. We have addressed this in the later bits of Yukon (Post Beta 2) -
Thanks
Manoj

|||

Manojas wrote:

Hello Herve
This was a known problem in Beta 2 Yukon bits. We have addressed this in the later bits of Yukon (Post Beta 2) -
Thanks
Manoj

I am using the evaluation copy of SQL2005 that I downloaded yesterday and having the same or similar problem. I can use the Management Studio to connect to the database without any problem.

The following is the details of the error:

===================================

Failed to open a new connection.

===================================

Failed to initialize MSDB database for tuning (exit code: -1). (DTAClient)

Program Location:

at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeTuningParametersDatabase()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeConnection()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.Connect()
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServerInternal(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServer(SqlConnectionInfo connectionInfo, SqlConnection connection)
at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.OnConnect(Object sender, EventArgs e)

===================================

Failed to establish a connection to the server.