We have deployed an Umbraco website onto a clients server and we are getting intermittent errors. We are confident it is the clients server as we are hosting the same website on our server without any issues.

Below is one of the errors that we are getting.

System.Data.SqlClient.SqlException (0x80131904): Logon failed for login '...' due to trigger execution.    
Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command.  The results, if any, should be discarded.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect)
    at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
    at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel)
    at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
    at StackExchange.Profiling.Data.ProfiledDbConnection.BeginDbTransaction(IsolationLevel isolationLevel) in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbConnection.cs:line 138
    at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
    at Umbraco.Core.Persistence.FaultHandling.RetryDbConnection.BeginDbTransaction(IsolationLevel isolationLevel) in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryDbConnection.cs:line 30
    at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
    at NPoco.Database.BeginTransaction(IsolationLevel isolationLevel)
    at Umbraco.Core.Scoping.Scope.get_Database() in d:\a\1\s\src\Umbraco.Core\Scoping\Scope.cs:line 244
    at Umbraco.Core.Scoping.Scope.WriteLock(Int32[] lockIds) in d:\a\1\s\src\Umbraco.Core\Scoping\Scope.cs:line 512
    at Umbraco.Core.Services.Implement.ContentService.<PerformScheduledPublishInternal>d__59.MoveNext() in d:\a\1\s\src\Umbraco.Core\Services\Implement\ContentService.cs:line 1298
    at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
    at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
    at Umbraco.Core.Services.Implement.ContentService.PerformScheduledPublish(DateTime date) in d:\a\1\s\src\Umbraco.Core\Services\Implement\ContentService.cs:line 1287
    at Umbraco.Web.Scheduling.ScheduledPublishing.PerformRun() in d:\a\1\s\src\Umbraco.Web\Scheduling\ScheduledPublishing.cs:line 72
ClientConnectionId:f3038aae-e5e1-4c6a-b932-2165f082b05f
Error Number:17892,State:1,Class:14

Any help would be greatly appreciated.