10-20-2009 11:56 PM
I'm thinking of upgrading my ACT! 7 to ACT! 2010 and i have a few questions as below:
10-21-2009 06:46 AM - last edited on 10-21-2009 10:21 AM by dlunceford
We are running on SQL 2008 standard and could answer some of your Questions
1. ACT by Sage Premuim does support SQL 2005 & 2008 ST
2. Im not sure, I have a downloaded copy but it should have a copy of SQL 2005 on the disc.
4. When you install ACT! 2010 it will automatically install SQL 2005 as well.
My recommondation is, if you are going to be running ACT! on SQL 2008 I would recommend installing SQL 2008 by itself first then install ACT. I tried to upgrade from 2005 and it was not finding the ACT7 instance. ACT support had the same problem.
Here is the documentation to manually install SQL 2008: http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2522...
10-21-2009 06:57 AM
Thanks for the feedback. When you install SQL Server 2008 in the server, do you use the CD/files downloaded from ACT! or you use Microsoft SQL Server CD to initiate the SQL installation?
After the SQL installation, do you just run ACT! installation CD/file and the installation process manage to detect the SQL instance?
10-21-2009 07:22 AM
I dont believe the CD contains SQL 2008, only 2005. I used the Microsoft SQL server CD.
After you have installed SQL 2008, you run the act installation from the CD and it will detect the ACT7 instance as long as you followed everything correctly as shown in the documentation.The instance can only be named "ACT7" , otherwise it may not detect it. Make sure you follow exactly as shown and make sure you enter the correct password the guide gives you, because it will ask you again for the password when you install ACT.
10-21-2009 07:40 AM
ok i got you. so it seems like you do have to specify an instance name and sa password when you manually install SQL 2008.
what about the client side database engine? do you need to upgrade the database engine for remote databases to SQL Express 2008 as well? i believe by default ACT! Premium 2010 only install SQL Express 2005 on the clients.
10-21-2009 07:55 AM
Yes that is correct.
On the client side all you need to do is run the installation from
the CD, it will install sql 2005 configuration tools (not sure why).
10-21-2009 08:04 AM
hmmm...this is weird. your setup means that in the server you have SQL Server 2008, whereas on the laptops/desktops, you have SQL Express 2005 as the database back end.
have you tried any synchronization from the laptops to the main database in the server? any errors or problems related to different SQL versions (in server vs in laptops)?
10-21-2009 08:12 AM
Im not exactly sure why it does that or If i need to upgrade every machine to sql 2008. We are on a network and everything seems to be working just fine so I dont see a reason to upgrade the clients to 2008. Maybe someone else has the answer to that...Sorry!
10-21-2009 09:00 AM
Ok, so it looks like you can upgarde the clients computers to SQL 2008 after it has been installed. Im not sure if it can be done when you first install ACT. I just finished upgrading mine and everything works just fine. I will have to see if anything changed as far as peformance etc.
10-21-2009 02:22 PM
If you are not seeing the ACT7 instance, please note the following:
If you are using a 32-bit edition of SQL Server Express 2005, you must select to install a 32-bit edition of SQL Server 2008.
- From the task list on the left, select Options. Then, under Processor Type, select x86.