none
how & what SQL do I upgrade to on windows 8 so that ACT 2009 will work

    Question

  • how & what SQL do I upgrade to on windows 8 so that ACT 2009 will work
    Wednesday, March 27, 2013 11:15 PM

Answers

  • Hello,

    You should ask this the support of the software vendor of Act, only they can tell you reliable what prequesions are required to get it working.


    Olaf Helper

    Blog Xing

    Thursday, March 28, 2013 7:03 AM
  • Hello Jimmy,

    According to http://download.act.com/system/2009.html , it is SQL Server 2005 which is in the end of life

    ACT! 2009 is obsolete http://na.sage.com/Sage-ACT/support/maintenance-and-support/obsolescence-policies . No more available upgrade to ACT! 2013   in May 2013 as it is discontinued since 12/31/2012.

    ACT! 2013 needs SQL Server 2008 R2 according http://na.sage.com/sage-act/products/system/2013/pro

    I think that you have to upgrade to SQL Server 2008 R2 in emergency. Be careful whether you have a SQL Server Express 2005 : if you have installed SSMSEE ( SQL Server Management Studio Express Edition specific to the 2005 version ) , you have to uninstall SSMSEE and all the Client Tools. If you don't do that and you try to force the upgrade, the install will fail and your SQL Server lost. There were some explanations given by Mike Wachal ( the poster on the SQL Server Express Weblog until 2009 ) in several threads when this kind of problem appeared after the release of SQL Server Express 2008 ( no problem for other 2005 editions as the SSMS was a full application, not a partial one not upgradable )

    Windows 8 is supporting SQL Server 2008,2008 R2, 2012. I have no news for the support by ACT! 2013 of SQL Server Express 2012 ( the main advantage for SQL Server Express 2012 is with the SP1, you have a full SQL Server Management Studio (SSMS) like in Standard  or Entreprise editions ).

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Thursday, March 28, 2013 10:22 AM
    Moderator

All replies

  • Hello,

    You should ask this the support of the software vendor of Act, only they can tell you reliable what prequesions are required to get it working.


    Olaf Helper

    Blog Xing

    Thursday, March 28, 2013 7:03 AM
  • Hello Jimmy,

    According to http://download.act.com/system/2009.html , it is SQL Server 2005 which is in the end of life

    ACT! 2009 is obsolete http://na.sage.com/Sage-ACT/support/maintenance-and-support/obsolescence-policies . No more available upgrade to ACT! 2013   in May 2013 as it is discontinued since 12/31/2012.

    ACT! 2013 needs SQL Server 2008 R2 according http://na.sage.com/sage-act/products/system/2013/pro

    I think that you have to upgrade to SQL Server 2008 R2 in emergency. Be careful whether you have a SQL Server Express 2005 : if you have installed SSMSEE ( SQL Server Management Studio Express Edition specific to the 2005 version ) , you have to uninstall SSMSEE and all the Client Tools. If you don't do that and you try to force the upgrade, the install will fail and your SQL Server lost. There were some explanations given by Mike Wachal ( the poster on the SQL Server Express Weblog until 2009 ) in several threads when this kind of problem appeared after the release of SQL Server Express 2008 ( no problem for other 2005 editions as the SSMS was a full application, not a partial one not upgradable )

    Windows 8 is supporting SQL Server 2008,2008 R2, 2012. I have no news for the support by ACT! 2013 of SQL Server Express 2012 ( the main advantage for SQL Server Express 2012 is with the SP1, you have a full SQL Server Management Studio (SSMS) like in Standard  or Entreprise editions ).

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Thursday, March 28, 2013 10:22 AM
    Moderator