SQL Prompt not working on SQL 2005 after Update to 10.14.6.5992

sworthy

Here is the error log.  Tried reinstalling already.  Used to work fine on 10.14.1

2024-01-30 16:16:15.450 -08:00 [Information] [servername].[master] loading skipped

2024-01-30 16:16:51.790 -08:00 [Information] Chosen server capabilities "Sql2005"

2024-01-30 16:16:51.799 -08:00 [Information] Resource Pools suggestions are not supported for Sql2005 servers

2024-01-30 16:16:51.801 -08:00 [Warning] Failed to load server servername

Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sys.dm_xe_objects'.

   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()

   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader()

   at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.GetPackageFromDatabase(SqlConnection serverLevelConnection)

   at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()

ClientConnectionId:384f9534-33a4-44d8-be7d-77b5f618f041

Error Number:208,State:1,Class:16

2024-01-30 16:16:51.953 -08:00 [Information] [servername].[master] loading skipped

Ben_P

Hi, thank you for your post. Is this for SQL Server 2005? If so, then this is not supported. The earliest version that SQL Prompt supports is 2012.