Solutions to some of the SQL issues when installing ACT! 2011

Re-posted, with permission from Ben Hamilton

This is a set of common issues we have seen when installing SQL 2008 (which is part of Sage ACT! 2011), especially when upgrading a previous version that used SQL 2005

Remove .Net Framework 4.0 before install

The support staff in Sage Business Solutions Melbourne (bless ‘em) gave me a pointer that if “Microsoft .NET Framework 4 Client Profile” is installed it gives troubles. Therefore they suggested uninstalling it prior to commending an SQL 2008 install. I don’t know why or what but this was an important step. Note that just doing this still gave me a failed SQL install. I’d love to know more about the ‘why’ here. I’d also like to have been informed earlier instead of after me jumping up and down and making phone calls. But that’s a topic for another day. For now I’m very happy with their suggestion as it does appear to have contributed to a successful install, which is GOAL NUMBER ONE.


SQL Service Account

During the install you get the option to set which account the SQL Server Database Engine uses, instead of setting to NT AUTHORITY\SYSTEM as per Sage KB26994, leave it as the default. After the installation is complete you then go to services.msc and change it to Local System then.


Avoid Special characters in the path

As per Microsoft KB955666 you can’t use a ‘number’ or ‘pound’ (#) sign in the path name. Now I did NOT have a pound sign in the path, but there was a space in one of the folder names and a ‘plus’ sign (+). So taking to heart Microsoft's admonition, I copied the installer to a folder C:\SQL2008ExpR2\*.* and ran it from there.


Various other issues and resolutions

  • “MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{4AB6A079-178B-4144-B21F-4D1AE71666A2}’. Error code: 1608.. ” See here and here.
  • “Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.” See here.
  • “Error: 15209, Severity: 16, State: 1. An error occurred during encryption.” See here.
  • Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Inst​alled
    Attempting to get registry value DW0200
    Submitted 1 of 1 failures to the Watson data repository
    Refer here, here and here.

Hope this helps someone short cut the time to resolve their SQL install.

Please add Comments with any other issues and resolutions you might find when installing SQL 2008 (especially when upgrading from SQL 2005)

Finding the hidden functions of ACT! with your Consultant

Part 4 of The Seven Day Blogging Challenge - Share a photo I took this week and tell you about it.

I have thought about today’s Challenge post for a while and, with this blog being about ACT!, there was not much I could think of to take a picture that would be relevant.

So I’ve taken a screen shot of a menu that describes how proper use of ACT! will benefit you:

ACT! 2011 Extended

If you can’t find these functions in your copy of ACT!, I suggest you speak to your ACT! Certified Consultant. These are the people who do more that the break-fix support you might get from a vendor support contact.

A good ACC will take the time to understand your business and the workflow of your operations. They will then assist you in designing ACT! in the best possible way to achieve your goals using functions within the product or some of the many powerful add-ons that extend it’s use.

The ACC can then assist with planning and implementing your installation roll-out including importing your data, connecting to other systems and training your users and administrators to properly get the maximum benefit from the product.

An investment in a good Certified Consultant will generate a Return many times in better managing your contacts

When looking at the ACT! Certified Consultant list, you may find many in your area. So here is an article on how you should go about picking the right one for you: How to pick the right CRM consultant

Should you have any questions on this, please let me know by posting the comments here.

Technorati Tags: ,,,,,