Forecaster 7's recently released service pack (Service Pack 4) appears to have a change in pre-requisite dependencies related specifically to ExpressLink and the Database Wizard. These two components now require three (3) specific SQL Server 2008 client components to be installed, even if you are using SQL Server 2005 as your database. Forecaster's installation does NOT install these components and these are not currently listed in the supporting documentation or system requirements from Microsoft.
Without these SQL Server 2008 components, the Database Wizard will crash when you click "Next" on the first screen, and ExpressLink fails to run. The only visible error message (in the Windows Event Log), states that Forecaster failed with a .net framework (2.0) system.io.filenotfound error.
Microsoft has been made aware of this issue and is investigating updates to product documentation to describe the situation.
To take care of this scenario, do the following:
Select the appropriate 32-bit or 64-bit versions of the following three client installations:
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server System CLR Types
Microsoft SQL Server 2008 Management Objects
Please note that this issue directly impacts ExpressLink and the Database Wizard only. The full Forecaster client and Forecaster Web Access are unaffected by this issue and will function as expected with either the SQL 2005 or SQL 2008 client components.
As an additional note, this requirements change appears to resolve the issue described here: http://boards.msxgroup.com/post?id=4856519. It is not yet clear if SP4 renders the workaround described in the referenced post unnecessary, but preliminary testing indicates that no additioanl effort is necessary to connect to SQL Server 2008 databases after applying Forecaster Service Pack 4 and following the above pre-requisite installation steps.
Microsoft posted the following KB article relating to this issue on August 30, 2011: http://support.microsoft.com/kb/2607590
As always, the MSX Group is here to help you with your Forecaster needs. If you have questions or problems with this solution or Forecaster, please feel free to contact us.