Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Contributor
jutamind
Posts: 27
Country: Malaysia
Message 1 of 14 (5,350 Views)

ACT! 2010 version with SQL Server 2005/2008 Standard database engine

I'm thinking of upgrading my ACT! 7 to ACT! 2010 and i have a few questions as below:

 

  1. I'm looking at ACT! by Sage Premium 2010. Does this version support SQL Server 2005/2008 Standard edition?
  2. Does ACT! by Sage Premium 2010 come with 2 CDs/DVDs as well whereas CD1 is for ACT! installation and CD2 is for SQL installation?
  3. If ACT! Premium 2010 only installs with SQL Express 2010, how do i upgrade the back end database engine in the server to at least SQL Server 2005 standard edition?
  4. Is there any document to install (from scratch) ACT! Premium 2010 with SQL Server 2005 standard edition as the database engine? ACT! Premium 2010 installation guide only shows the installation of ACT! with SQL Express 2005 back end.
Appreciate your feedback.
Please use plain text.
Copper Contributor
alexserenity
Posts: 27
Country: United States
Message 2 of 14 (5,325 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

[ Edited ]

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.

3.n/a

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...

Message Edited by dlunceford on 10-21-2009 01:21 PM
-Alex
Serenity Group Insurance
Please use plain text.
Copper Contributor
jutamind
Posts: 27
Country: Malaysia
Message 3 of 14 (5,320 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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?

Please use plain text.
Copper Contributor
alexserenity
Posts: 27
Country: United States
Message 4 of 14 (5,315 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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.

-Alex
Serenity Group Insurance
Please use plain text.
Copper Contributor
jutamind
Posts: 27
Country: Malaysia
Message 5 of 14 (5,311 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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.

Please use plain text.
Copper Contributor
alexserenity
Posts: 27
Country: United States
Message 6 of 14 (5,309 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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). 

-Alex
Serenity Group Insurance
Please use plain text.
Copper Contributor
jutamind
Posts: 27
Country: Malaysia
Message 7 of 14 (5,306 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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)?

Please use plain text.
Copper Contributor
alexserenity
Posts: 27
Country: United States
Message 8 of 14 (5,304 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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!

-Alex
Serenity Group Insurance
Please use plain text.
Copper Contributor
alexserenity
Posts: 27
Country: United States
Message 9 of 14 (5,296 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

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.

-Alex
Serenity Group Insurance
Please use plain text.
Nickel Super Contributor
AJones
Posts: 584
Country: USA
Message 10 of 14 (5,255 Views)

Re: ACT! 2010 version with SQL Server 2005/2008 Standard database engine

Alex,

 

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.

 

Thanks,

Amanda

Please use plain text.