SQL Server Issue upon installation

[GMANTEL]

Hi there! I have just installed ACT! Premium 2008 and there was some issue with Microsoft's SQL Server 2005. So I deleted this off my system (Windows XP Pro) thinking I could just reinstall or download from the Microsoft site. Well, I couldn't, so I installed the H2 SQL Server instead.

I am unable to create a new database or open new ones. ACT! is still trying to associate with the MS SQL Server. How do I get it to use the H2 SQL server?

Thanks very much for your assistance!

[mwood]

Hello there, I believe the SQLH2 is a health and history tool used for SQL server. You're going to need MSSQL 2005; the express version can be downloaded for free and is also included in the act installation media.

Here is the link to the Microsoft download site for SQL 2005 express. 

[Llessur Niak]

- Clean up the installation using the uninstall utility from Sage

- http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1933...

- reboot the machine and temporarily turn off any antivirus software.

- Install Microsoft SQL server using the following article:

- http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1938...

- assuming the previous steps were successful install ACT! as per normal.