Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Server Issue upon installation

New Member
Posts: 2
Country: USA

SQL Server Issue upon installation

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!

Employee
Posts: 1,163
Country: USA

Re: SQL Server Issue upon installation

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. 

Matthew Wood
Act! SDK Support
Community Moderator
Copper Contributor
Posts: 11
Country: Poland

Re: SQL Server Issue upon installation

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