Community
Showing results for 
Search instead for 
Do you mean 
Reply

Terminal Services problem

New Member
Posts: 1
Country: UK

Terminal Services problem

Environment:
Windows Server 2003 SP1 Terminal Server.
Active Directory domain
ACT! 2008 Ex
 
Problem: an ACT! installation that's working well, suddenly can't connect to the database.
 
Other symptoms:
Multiple "Login Failure" messages in the Windows Event Log, followed by messages that the "actadmin" account is locked out. Text of failure message is:
Event Type: Failure Audit
Event Source: MSSQL$ACT7
Event Category: (4)
Event ID: 18456
Date:  31/03/2008
Time:  18:31:57
User:  N/A
Computer: TERMINALSERVER
Description:
Login failed for user 'ACTADMIN'. [CLIENT: <local machine>]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 
I've set the Account Lockout Policy to unlock accounts after a period of time - at this point ACT! works again. (I did use "actdiag" to reset the sa password at this point, too - not sure if I needed to or not.)
 
I noticed that when the account unlocked, I started getting failure messages again (about 1 per minute). 1 user had been logged in to TS for some time - when they logged out, the failure messages stopped. Suspect, therefore, that the problem is TS related.
 
Looking at Task Manager, each user is running the following processes:
Act.Framework.Synchronisation.Service.UI.exe
Act.Outlook.Service.exe
Act.Scheduler.exe
Act.Scheduler.UI.exe
 
The System user is running:
Act.Framework.Synchronisation.Service.exe
Act.Scheduler.exe
 
Suspect that I'm getting problems because a process contains "stale credentials" for the "actadmin" database account.
 
Please can you help with this? (We're due to install a 20 user system on a customer's TS in a few weeks & I want to be confident that it will continue to work)
 
Rob Bracken
Nickel Super Contributor
Posts: 441
Country: UK

Re: Terminal Services problem

Running SecurityCmdLnApp.exe in the ACT! program files directory will reset the password for you.  If that fails copy the attached file into the Program Files directory and run that.
 
**Sorry just realised you can't attach files, batch script text below, just paste into a text file and save as .bat, you will need to put it in the act for windows program files directory***
 
sqlcmd -S(local)\ACT7 -E -Q"sp_password null, 'Mercury!2008!ACT', sa;" -oHardReset_out.txt
SecurityCmdLnApp.exe Mercury!2008!ACT
 
Tom
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Terminal Services problem