User profile for Agilone – Support

Activity overview Badges (0) Posts (1) Comments (2)

Comments

Hi, I made sure that everyone has execute permission on tempdb. Which is now the case. I am now getting another error message: System.Data.SqlClient.SqlException: The user does not have permission to perform this action. You do not have permission to run 'SYS.TRACES'. 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 RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable`1 , SqlCommand ) at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection`1 , SqlDateTime ) at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection`1 , SqlDateTime ) at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName) at #mlhb.#ny2b.#jiUc() at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func`1 func) at #GWeb.#WXM.#P6Uc(Func`1 ) at #mlhb.#ny2b.#xFV() at #mlhb.#ny2b.#aQU(ICollection`1 #vfX, DatabaseObjectIdDictionary`1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc) at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c) at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc) at #GWeb.#VXM.#mYM[#NrPb](Func`2 , ICancellableOperationStatus , IReadonlySourceControlServerCallBacks , IDifferenceSelector , Action ) at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector ) at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector ) at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus ) at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f() at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action) at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke() at #eEc.#Qlg.Invoke() at #JLc.#PLc.#Jfb.#EJf() at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean ) at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action) at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action) Thanks / comments

Hi, I made sure that everyone has execute permission on tempdb. Which is now the case. I am now getting another error message: System.Data.SqlClient.SqlException: The user does not have permission ...

0 votes

Thanks for this detailed answer. However, we also all have the "ALTER" permission and same error. Any workaround ? (sysadmin is not acceptable...) Thank you for your time / comments

Thanks for this detailed answer. However, we also all have the "ALTER" permission and same error. Any workaround ? (sysadmin is not acceptable...) Thank you for your time

0 votes

Total activity: 4
Last activity: February 05, 2025 14:58
Member since: February 05, 2025 07:35

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1