Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can't open ActDiag

Accepted Solution Solved
Nickel Contributor
Posts: 274
Country: Canada
Accepted Solution

Can't open ActDiag

On Act! Premium v20.0.159.0 update 5. as soon as I launch actdiag.exe, I get:

 

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)
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 ActDiag.Common.GetSQLProductVersion(String saPwd)
at ActDiag.ServerInfo..ctor()
at ActDiag.FormACTDiag.Ԕ()
at ActDiag.FormACTDiag..ctor()
at ActDiag.FormACTDiag.ַ(String[] ָ)

I can connect fine to my databases through Act!.

Gilles Cavin
http://www.exponenciel.com
Make sure you check our free Act! add-ons!
Create Web forms in seconds and import form results directly into Act! with Automatic Web Forms
check our latest add-on: Better Last Activity Date Tracking

Accepted Solutions
Solution
Accepted by topic author gcavin
‎12-13-2017 06:40 AM
Administrator
Posts: 1,372
Country: United_Kingdom

Re: Can't open ActDiag

Sounds like you need to reset the SQL SA password.

The batch file to reset the SA account is attached at the bottom of this KB article:
http://kb.act.com/app/answers/detail/a_id/36794

The actual steps in the article likely don't apply - you should just need to run the batch file (as admin).

View solution in original post


All Replies
Solution
Accepted by topic author gcavin
‎12-13-2017 06:40 AM
Administrator
Posts: 1,372
Country: United_Kingdom

Re: Can't open ActDiag

Sounds like you need to reset the SQL SA password.

The batch file to reset the SA account is attached at the bottom of this KB article:
http://kb.act.com/app/answers/detail/a_id/36794

The actual steps in the article likely don't apply - you should just need to run the batch file (as admin).