Thursday, March 8, 2012

Cannot Launch DTA - Failed to open new connection

Installed SQL 2005 STD and installed SP1 for SQL on a Windows 2003 STD server.

I launch DTA and I am logged in with the same windows account which the SQL services use and I get the following message:

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

Failed to open a new connection.

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

Could not find stored procedure 'msdb..sp_DTA_help_session'. (.Net SqlClient Data Provider)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476


Server Name: FHCMS,1433
Error Number: 2812
Severity: 16
State: 62
Line Number: 1

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.SqlServer.Management.DTA.Client.TuningServer.QuerySessions()
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)

Any help would be appreciated.

Thanks,
Pete

are you using RTM or sp1 version? a MSFT guy told me that there are problems he has heard of with DTA in the RTM build...I would tell you that while I love the product, DTA has not been the most stable of components overall from my expereinces w/it.|||

I am using the SP1 version for SQL 2005, I didn't even check to see if DTA worked before that since it is a brand new server.

I saw a post that stated the user does not have sysadmin rights for SQL and that is what the error message means but I created a Domain Admin account for SQL and that is what I am logged on to the server with.

Thanks,
Pete

|||

have you checked all the usual log locations...

sql exception log

event log

unfortunetly i cannot be of any more help at this point.

|||

I have the same trouble.

No comments:

Post a Comment