I'm looking for a way to access data in an ACT! database for a data migration to a custom application.
The ACT! software uses SQLServer 2005.
The data conversion script and new application will be written on a Linux system using Python and Postgresql.
My problem is getting my hands on the data !
I don't know how ACT! has their SQLServer installation configured.
Initially I installed Microsoft SQL Server Management Studio Express to see if I could view and query the data.
I currently have ...
- Windows XP machine
- ACT! 2009 version 126.96.36.1997
- Microsoft SQL Server Management Studio Express version 9.00.2047.00
There are two instances of the SQLServer running. One for the ACT! software and one that was loaded with the Studio Express installation.
In Studio Express I can connect to the latter instance but not to the SQLServer for the ACT! database.
Using the Windows Authentication login I get
Login failed for user ... Error 18456.
I don't know what the SQL Server Authentication login would be.
Is there a way around the connection/login issue ?
Can the second instance of SQLServer be configured to see the ACT! database ?
Copy the database files ... ?