I've recently moved an ACT SQL database from a Windows 2008 r2 server (same SQL version) to a Windows 2012 server with SQL 2012, the database restored fine but Act now when opening the (edited) .PAD file returns to the previous screen without any message.
If we try to open the .adf file directly the error "Failed to open a connection to the database"
The event viewer shows an error:
Log Name: Application
Date: 10/06/2015 09:42:17
Event ID: 18456
Task Category: Logon
Keywords: Classic,Audit Failure
Login failed for user 'ACTACCESS'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]
SQL has mixed authentication enabled and active. Also port 1434 has been opened on the server but I cannot telnet to it as suggested elsewhere online.
Any ideas, anyone?