You are receiving intermittent errors such as: "Database could not be accessed...." when attempting to open an existing database or "Unable to create the database. There is an error connecting to the Microsoft SQL Server" when attempting to create a new database. When you review the Event Viewer under Computer Management, you find the following message: "Login failed for user 'ACTADMIN' because the account is currently locked out. The system administrator can unlock it."
Opening Existing Database
Creating New Database
Failure Audit in Application Event Viewer
Note: The steps below should be followed only if the error message in the event log specifically states as illustrated in the screenshot above, "Login failed for user 'ACTADMIN' because the account is currently locked out. The system administrator can unlock it."
This has been noted to occur when the ACT7 SQL instance was installed manually, and to be a result of Domain Security Policies. These policies can cause the ACTADMIN SQL account for the ACT7 instance to become locked out for a certain duration of time. This will normally occur if a 3rd party application such as backup software is trying to connect to the instance with any password other than the encrypted SA password. This issue may also occur if the password for the ACTADMIN account of the ACT7 instance has expired because of Domain Security Policies. SQL Server 2005 introduced the Enforce Password Policy configuration, which use the Domain policies for password length, complexity and expiration. Depending on how Active Directory, the local policies and rights are setup, these parameters can be reviewed and changed to dictate how SQL Server uses configurations.
Use the following steps to resolve this issue. These steps include the execution of a batch file that will uncheck the Enforce Password Policy for the ACT7 instance and allow access to the database.
- Close ACT! and any other running applications.
- Right-click the ResetSQL.bat file from the File Attachments area near the bottom of this Answer, and then click Save Target As from the shortcut menu. A Save As dialog box appears.
- Click the drop-down arrow at the Save in field, browse to the location:
C:\Program Files\ACT\Act for Window
or for a 64-bit operating system, browse to:
C:\Program Files (x86)\ACT\Act for Windows
- Click Save.
- Double-Click on the ResetSQL.bat file to execute.
- Type "Y" and press Enter when prompted to "Turn off Password Policy".
Note: You can enter "N" when prompted to "Reset SQL password".
- Test opening database in ACT!.
- After completion, the SQL Server will be restarted and the dialog box will close.