Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problem with SQL instance

New Member
Posts: 2
Country: USA

Problem with SQL instance

[ Edited ]

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?

Message Edited by SPI_MB on 07-09-2008 02:34 PM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Problem with SQL instance

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)-
http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en
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
Reboot

 

Let us know if any of the steps fail