01-20-2014 12:50 PM
I am hoping that reinstalling Act from the downloaded setup file (Oct 2012) will fix my SQL Server problem. It was an upgrade from Act Pro 2011.
It is an older versioon than Is now running. If it is reinstalled can it then be updated to the current version without problems?: My OS is Windows 7 Home Premium 64 bit.
01-23-2014 10:18 AM
When you uninstall Act! it does not uninstall SQL Server, that has to be done separately.
If you downloaded Sage ACT! Pro 2013 and did not install Service Pack 1 after installing, then you would be able to uninstall and reinstall the program from the old download and still access your database without having to do any additional steps. If you did apply Service Pack 1, you would need to download and install it again before being able. You can tell if you have it Service Pack 1 installed if you open Act! then click Help > About ACT!. Look for the version number. If it says 15.1, you've installed Service Pack 1
What SQL Server issue are you experiencing? It might not be necessary to go to all of that trouble, depending on the issue.
01-23-2014 01:18 PM
Thanks for your reply. Unfortunately, after reinstalling SQL Server R2 I was unable to get Act to run. I first Installed Act Pro 2011 from the disk and the ungraded from the downloads for Pro 2013.
The program version is 15.0.301.0. It did load correctly on the new machine I bought out of desperation.
The machine with the problem also has SQL Server 2005 Compact Edition (ENU). Would that affect the instal and should it be removed?
I believe this all started because of a disk problem that caused the SQL files to become corrupted. Unless you have another idea, I have backed up may data and am going to restore it to a date shortly before the problem began.
Any other thoughts you have would be greatly appreciated.
01-24-2014 09:55 AM
SQL Server 2005 Compact Edition (ENU) would not affect the install of Act!. No version of Act! even used this, so I would recommend that you do not touch this. From the sound of it, it doesn't seem like Act! itself is the problem, rather an issue with the SQL Server instance. Are you able to load the program and at least get to the welcome screen where it asks you to either create a database or open an existing database? Can you even open the demo database? If not, it is likely that what you will need to do is uninstall Microsoft SQL Server 2008 R2 and then manually install the SQL Server instance. To do this, you do not need to uninstall the Act! program itself, you only need to uninstall and reinstall SQL.
For instructions on uninstalling the Microsoft SQL Server 2008 R2 (ACT7) instance, refer to the following Knowledgebase article: http://kb.swiftpage.com/app/answers/detail/a_id/29039
To manually create the Microsoft SQL Server 2008 R2 (ACT7) instance, refer to the following Knowledgebase article: http://kb.swiftpage.com/app/answers/detail/a_id/27039
Make sure that you are logged into the machine as a Windows Administrator when completing these tasks
01-24-2014 10:40 AM
The Act program fails immediately and never opens. The erro message "an unhandled win32 exception occurred in ActSage.exe . I do have .net 4
In the new machine running on Windows 8 64 bit I was able to update through Hot Fix 2, but not beyond and it also has .Net 4.0
Any thought on either situation?
01-28-2014 10:16 AM
Try to uninstall what you have on there currently and install the most recent update for it and see if that works. You can find that here: http://cdn.act.dlm.swiftpage.com/2445/act_pro_2013_us_ca_la.exe
03-04-2014 06:43 AM
The problem is partially solved.
I found out that the source of the problem was a faulty Windows "upgrade" from April 2013, KB2840149, which Microsoft didn't apply to my machine until Jan 7 2014. I have now turned off automatic updating and removed it.
I first tried to directly reinstall 2013, but that didn't include SQL Server and I couldn't access any databases.
When that failed, I tried reinstalling 2011 and then upgrading, but then 2013 wouldn't work at all.
What finally worked was to install and remove 2011, so that SQL Server 2008 remains, and then reinstall 2013.
However, now it doesn't recognize any of my user names. Also, if I try to create a new database, it says that I first need to open it as an administrator. How do I fix this?