07-09-2008 12:42 PM - edited 07-09-2008 02:34 PM
I am upgrading from ACT! 2006 to ACT! 2008 and am having a problem installing. I've installed ACT successfully on the PC, and installed ACT on the laptop and when I go to unpack and restore a remote database on the laptop, I get this error message:
Failed to restore remote database. The SQL database instance is unavailable.
I found that the SQL Server (ACT 7) wasn't installed on the laptop and followed the instructions for installing and it says that the ACT7 is started and the SQL Server Browser is started. I still can't restore a remote database and I can't even create a new database without the error message:
Unable to create the database. There is an error connecting to the Microsoft SQL server.
What do I do now?
07-10-2008 02:59 AM
Something must have prevented SQL from properly setting up.
This is a procedure I wrote to get the most clean install possible:
Uninstall any version of ACT! from Windows Control Panel | Add/Remove Programs
Use the Uninstaller.exe from the ACT! KB 19338 (the exe, not the manual uninstall) - select to remove SQL also.
Uninstall .Net Framework (all versions) - this does NOT apply to Vista users as .Net 2.0 is part of the OS and can't be uninstalled
Uninstall any MS SQL items from the Control Panel if still there
Uninstall MSXML 6 Services from Control Panel if it's still there
Perform a Selective restart with MSCONFIG as per ACT! KB 14499
Install .Net 2.0 Framework (only 2.0 for ACT! 9/10) from MS web site (only XP, not Vista)-
Manually install MS SQL as per ACT! KB 19386
Install ACT! 10.0 full install
Install ACT! 10.02 patch if the previous install was the previous build
Restore from Selective Startup Mode with MSCONFIG
Let us know if any of the steps fail