11-30-2008 01:40 PM
I am running the following ACT for web verison:
ACT! by Sage Premium 2009 (11.0) Version 126.96.36.1997
I installed ACT via the demo CD, the SQL server option was grayed out.
I have created a database but it creates a .pad file. I would like to use SQL Server Express. I have installed SQL Express on my server. How do I go about configuring ACT to work with SQL Server instead of using the .pad files?
11-30-2008 09:13 PM
I don't understand the question
The PAD file is simply a Pointer to the ACT! Database. It just contains the location (server and path) of the database.
ACT! uses SQL Server Express, unless you purchased the ST version, then it would install SQL Server Standard.
12-01-2008 05:35 AM
Thanks for clearing that up.
We are using the 'EX' version which means we're on SQL Express. If I already owned SQL Standard how would I go about using that with the 'EX' version? Can I use SQL Server Enterprise?
Finally, how do I get into the actual database via SQL Management Studio? I am having login issues because I don't know the password for sa.
Thanks for your help.
12-01-2008 05:50 AM
If you alredy have SQL ST, you can create your own ACT instance as per these ACT! Knowledge Base articles:
The SA pass is available as an optionforCorporate users on the Premium version, but this is not usually necessary and CANNOT be used to write to the database. What are you looking to do?
12-01-2008 06:04 AM
You can write reports via OLEDB - How to Manually Start OLEDB
Or the Actreader account - Unable to Locate the ACT! Reader Utility
02-04-2010 09:40 AM
just found this regarding the OLE DB, works like a charm! thanks! (had trouble with an unknown ACTREADER password)
You might have a look at these: