User profile for Agilone – Support

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

Activity overview

Latest activity by Agilone

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

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

[Error] The execute permission was denied ...

Hi, First and foremost, thanks for this tool, it makes it much easier to work with SQL. However, I am having trouble to commit a small number of databases. I have the following error message when t...

3 followers 5 comments 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