Hi,
Did anyone faced this issue?
Amanda login to Tessitura ( without windows authentication) and it crashed after she opens a constituent Record. Based on the logs, her account was using INTREPIDMUSEUM\acatherall and got SQL connection FAILED error. Her account was not set up for AD login. Her account was working perfectly with other PC so, we gave her a new PC. Her new PC was working perfectly until Friday and it started to produce the same issue.
I’m attaching the log to this email.
We did
-Drop and create a login
-double-checked the SQL server and she don’t have direct access to SQL
- We did clean up on her PC.
- Created a new log with a new user name and password
-Set up a new PC ( it worked for a few days and started showing the same issue again)
This is the log for the PC .
Date|Component|Logger|Location|WindowsLogin|UserId|UserGroup|Level|Message
2021-12-17 13:01:34.8984|TessituraClient|ApplicationLogger|9066-D-L-M700|INTREPIDMUSEUM\acatherall|||Error|SQL connection FAILED
2021-12-17 13:01:34.9503|TessituraClient|ApplicationLogger|9066-D-L-M700|INTREPIDMUSEUM\acatherall|||Error|Login failed for user 'INTREPIDMUSEUM\acatherall'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Tessitura.App.LoginWindow.Helpers.DatabaseConnectionHelper.CheckIntegratedSecurity()
Did any one resolve issues like this?
Please advise
We ran into a similar issue if someone had the Grammarly App installed on the PC.