Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can't open ActDiag

Accepted Solution Solved
Nickel Contributor
Posts: 241
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
Fill in PDF Forms without retyping data using Act! to PDF Forms

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).