Community
Showing results for 
Search instead for 
Do you mean 
Reply

Login failed for user 'sa'

Tuned Listener
Posts: 77
Country: United States

Login failed for user 'sa'

[ Edited ]

Using ACT Premium Version 18.0.50.501.0 Hit Fix 5

 

Wasnt able to send emails so went into ACTDIAG and while running a Repair Database, ACTDIAG stopped working and I had to close it through the task manager.

 

From that time, ACTDIAG has stop working - giving the following message - see Image-1.

 

 

Each time I now run ACTDIAG and try to List Database List - I am getting the results of Image-1.

 

When I try to open ACT - it give message in Image-3, when i click OK, it gives the message in Image-4. My database does not have a password.

I downloaded and ran SingleUserModeError_KB31714 - see Image-2.

 

All other databases are opening ok except this one.

 

Can anyone please help?

 

Thanks .. Steven

 

 

Administrator
Posts: 4,024
Country: United_Kingdom

Re: Login failed for user 'sa'

[ Edited ]

Hi Steven,

Please could you try running the ResetSQL.bat file after following the steps detailed in the following Knowledgebase article: http://kb.act.com/app/answers/detail/a_id/23446

After this, try accessing the database list in ActDiag again.

 

P.S. Image 4 does not seem to be attached.

Tuned Listener
Posts: 77
Country: United States

Re: Login failed for user 'sa'

[ Edited ]

Thank you.

 

I ran ResetSQL.bat and got "System Error 5 has occurred, Access denied" (see Message from Reset SQL).

Tried ACT DIag anyway and got message - see "ACTDiag After Running ResetSQL"

 

Administrator
Posts: 4,024
Country: United_Kingdom

Re: Login failed for user 'sa'

Hi Steven,

Please try running the .bat file as administrator in Windows, or log into a Windows account that has admin privileges.
Tuned Listener
Posts: 77
Country: United States

Re: Login failed for user 'sa'

I contacted tech support and they did several things - can't really say exactly but it got resolved.