Community
Showing results for 
Search instead for 
Do you mean 
Reply

actdiag error about sa password.

Accepted Solution Solved
New Member
Posts: 3
Country: United_Kingdom
Accepted Solution

actdiag error about sa password.

Hi, we have Act Pro 2012 and can connect ok using the Act software. we can access the sql backend ok (by resetting the SA password) however now actdiag doesnt connect, it is complaining about the sa password. I know the sa password, is there anyway to specify the password actdiag uses? or reset the sa password to something actdiag is happy with?

 

I only needed the sql backed access for a quick db compare for some dev work I am doing. I havent restarted the server or sql instances yet just incase my ability to actually log into Act stops working.

 

Thank,

 

Michael.


Accepted Solutions
Solution
Accepted by topic author bhlgroup
‎09-25-2015 03:20 AM
Nickel Contributor
Posts: 173
Country: Australia

Re: actdiag error about sa password.

Try the setps in this article.
http://kb.sagesoftwareonline.com/app/answers/detail/a_id/26741/kw/SecurityCmdLnApp/session/L3RpbWUvM...
Travis Rosevear ACC for
Act Today Australia and New Zealand

View solution in original post


All Replies
Solution
Accepted by topic author bhlgroup
‎09-25-2015 03:20 AM
Nickel Contributor
Posts: 173
Country: Australia

Re: actdiag error about sa password.

Try the setps in this article.
http://kb.sagesoftwareonline.com/app/answers/detail/a_id/26741/kw/SecurityCmdLnApp/session/L3RpbWUvM...
Travis Rosevear ACC for
Act Today Australia and New Zealand
New Member
Posts: 3
Country: United_Kingdom

Re: actdiag error about sa password.

thanks, running the SecurityCmdLnApp.exe seems to have reset the sa password and actdiag is happy. I can no longer connect to the sql using the sa account but I created another admin account before running that .exe and I still have full db access.

 

Fingers crossed that everything else is working.