Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

MS Forecaster W2008 Server R2

Posted on by 75,730

Can MS Forecaster 7.0 be installed on  a W2008 R2 64 bit server? I just tried and the installation of the SQL Client and Management files fail and if I try to continue, the installation of Forecaster fails. I am doing the installation from the 7.0RTM download. None of the SPs help because they need Forecaster their first.

*This post is locked for comments

  • michelle brayton Profile Picture
    michelle brayton 95 on at
    RE: MS Forecaster W2008 Server R2

    Beat, I have been searching FOREVER for this resolution.  Stupid admin privileges.  :)

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: MS Forecaster W2008 Server R2

    Hi Everyone,

    I was finally able to get around that damn Web Port error message with the SP3 FCWA setup...

    After spending several hours on the phone with MS Tech support guy, a light came up about the way to install MSI files on a Win2008R2 system (and by extend to Win7 too). When using a .EXE file, you can right-click on it and run it with Administrator Privileges... not so with an .MSI... somehow MS doesn't want them to be treated equal to EXE files...  

    So at point 10 of the above instructions from Ryan, instead of double-clicking on the FC70SP3.msi, you have to open a command-line prompt windows in elevated Administrator privileges in order to execute the MSI file... after that all was perfect and the update went without a hitch. The FCWA site was created on IIS and the only thing that is left is to change the authentication mode in IIS (depending on your needs, but Anonymous has definitely to be disabled). Keep only Windows or Basic authentication.

    Also, when you're going to create the DB links to your FC SQL DB server, you'll have to run the MS Forecaster Database Creation Tool in Admin mode, otherwise your company links will not show up in the FCWA login page... only a number 1 will be available in the pull-down menu (this may be due to the 64-bit environment of the server, reminds me somehow the ODBC issues with Win7 64-bit and GP).

    The FC HF5 files could be installed without problems (since it's an MSI packaged in an EXE file) by right-clicking on the file and run as Administrator.

    Write this down somewhere for your next Forecaster 7.0 deployment or update on Win2008R2 64-bit.

    Wish you all a nice X-mas and Happy Holidays.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: MS Forecaster W2008 Server R2

    Hi Everyone,

    I'm facing a very particular situation... After moving our Dynamics GP databases and the Forecaster DB's to a new SQL 2008R2 (on Win2k8R2) server, we realized that the Forecaster Web was not being able to authenticate the users anymore if it is not installed on the same system... This seems to be due to a limitation of the Windows Authentication token pass-thru, which cannot hop more then one system.

    I now tried to install the Forecaster 7.0 by following the instructions above, but at some point in time something went wrong and now I'm stuck and cannot apply any fixes or uninstall the FC ... the error messages I'm getting are :

    " The service pack installation could not detect a valid Microsoft Forecaster 7.0 version on this machine. Please ensure that a valid version has been installed and try again"

    My last successful install was the SP3 and the HF4, but then somehow the process was interrupted in between and cancelled, which now led to this situation.

    When trying to launch the HF4 again, I get invariably the message " The upgrade patch cannot be installed by the windows installer service, because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program.[...]"

    I checked in the registry and didn't found anything useful. The program folder itself doesn't even exist...

    Thanks for any tip about this issue.

    UPDATE :

    I managed to be able the relaunch the initial FC 7.0 setup after I copied the whole program folder from the old server. Since the new server is running 64-bit, I put it into the x86 program folders. After applying the SP3 and trying to install the FC Web portion, I'm now stuck with the Virtual Directory and Port number assignment... the system keeps telling me that  "The port entered does not represent a valid website on this computer. Enter a valid port to continue"... nothing is accepted, no matter what I put in the port number (80, 81, 8080, etc).

    Any suggestions ?

  • Deborah Bussin Profile Picture
    Deborah Bussin 205 on at
    Re: MS Forecaster W2008 Server R2

    Thank you.  I followed the KB article above.  When trying to create a database I was not able to make a connection.  I followed article ID 962541, which reinstalled the SQL Native Client and SQWL Management Object Collections updates, which fixed the connectivity issue.

  • Deborah Bussin Profile Picture
    Deborah Bussin 205 on at
    Re: MS Forecaster W2008 Server R2

    Thank you.  I do have an account on CustomerSource, but could not locate this kb article.  I will work on this.

  • Verified answer
    Re: MS Forecaster W2008 Server R2

    It may not paste well, but here you are. If you want access to this type of content ask your Dynamics partner with assistance on creating an account on CustomerSource for you.

    How to install Microsoft Forecaster 7.0 and the Microsoft Management Reporter Application Service on the same Microsoft Windows Server 2008 64-bit IIS server

    View products that this article applies to.

    Confidential Article

    (The information in this article is provided to you in accordance with your Confidentiality Agreement)

    Expand all | Collapse all

    SUMMARY

    Describes how to install Microsoft Forecaster 7.0 and the Microsoft Management R...

    Describes how to install Microsoft Forecaster 7.0 and the Microsoft Management Reporter Application Service on the same Microsoft Windows Server 2008 64-bit server.

    MORE INFORMATION

    1. Prepare the Windows Server 2008 64-bit Server Running IIS. First, turn...

    1. Prepare the Windows Server 2008 64-bit Server Running IIS. First, turn off the User Account Control (UAC) by following these steps:

    a. Click Start, and then click Run.

    b. Type UserAccountControlSettings.exe and then click OK.

    c. In the User Account Control Settings window that opens, move the slider bar to the bottom to the Never Notify position.

    d. Click OK.

    e. Restart the server.

    Note You are not presented with an on-screen message. However, you must restart your computer to finish the change. Review the Action Center in Control Panel for more information.

    2. Make sure all required IIS components are installed for Microsoft Forecaster 7.0 by using these steps:

    a. Click Start, and then click Server Manager.

    b. Expand Roles.

    c. Select the Web Server (IIS) role.

    d. Scroll down to the Role Services section.

    e. Click Add Role Services.

    f. Select the following Role Services to install if they are not already installed:

    i. Under the Application Development section, select:

    1. ASP.NET

    2. ASP

    ii. Under the IIS 6 Management Compatibility section, select:

    1. IIS 6 Metabase Compatibility

    2. IIS 6 WMI Compatibility

    3. IIS 6 Scripting Tools

    g. Complete the Add Role Services wizard to install any missing role services.

    h. Restart the server, if it is required, after you complete the wizard.

    3. Make sure all required features are installed for Microsoft Management Reporter. To do this, follow these steps:

    a. Click Start, and then click Server Manager.

    b. Select Features.

    c. Click Add Features.

    d. Expand .NET Framework 3.5.1 Features and check WCF Activation. If you are prompted, click Add Required Features to add the additional required features.

    e. Click Next.

    f. Click Install.

    g. Restart the server, if it is required, after you complete the wizard.

    4. Enable the IIS 32-bit mode, which will enable Microsoft Forecaster 7.0 to run on a 64-bit operating system. To do this, follow these steps:

    a. Click Start, and then click Server Manager.

    b. Expand Roles.

    c. Expand the Web Server (IIS) role.

    d. Select Internet Information Services (IIS) Manager.

    e. In IIS Manager, expand the server name and then select Application Pools.

    f. In the Actions pane, click Set Application Pool Defaults.

    g. Change the Enable 32-Bit Applications value to True.

    h. Click OK to save the change.

    5. Install the 64-bit versions of the following prerequisites for Microsoft SQL Server in the following order:

    a. Microsoft SQL Server Native Client

    Note The file name is sqlncli_x64.msi.

    b. Microsoft SQL Server 2005 Management Objects Collection

    Note The file name is SQLServer2005_XMO_x64.msi.

    c. You can obtain each of these items from the following link:

    www.microsoft.com/.../details.aspx (www.microsoft.com/.../details.aspx)

    6. Download the Microsoft Forecaster 7.0 full installation package. You can obtain this by using the following link:

    mbs.microsoft.com/.../Installforecaster7 (mbs.microsoft.com/.../Installforecaster7)

    7. Extract the contents of the Microsoft Forecaster 7.0 installer, and then run the Microsoft Forecaster 7.0 installer by using these steps:

    a. Double-click Setup.exe.

    b. You are prompted to install any prerequisites that were not detected on the 64-bit operating system. This includes the following:

    i. Microsoft SQL Server Native Client

    ii. Microsoft SQL Server Management Objects Collection

    c. Click Install.

    d. You will receive the following error message:

    Microsoft SQL Server Management Objects Collection: Installation of this product failed because it is not supported on this operating system. For more information about supported configurations, see the product documentation.

    Note The error message is caused by the Microsoft Forecaster 7.0 installer trying to install the 32-bit version of the Microsoft SQL Server Management Objects Collection. This is not supported on a 64-bit operating system. The error is expected and can be safely ignored.

    e. Click OK to continue past the error.

    f. Click Yes when you are prompted with the message Failed to install Microsoft SQL Server Management Objects Collection. Continue with other components?

    g. The Microsoft Forecaster 7.0 Setup wizard starts. Click Next on the first screen.

    h. Click to accept the license agreement and then click Next.

    i. On the Select the features you would like to install on your computer screen, clear Microsoft Forecaster Web Access. This installation will be completed later.

    Note If you try to install the Web Access piece of Microsoft Forecaster, you will receive the following error because of the incompatibility of Web Access in the original Microsoft Forecaster 7.0 install with Windows Server 2008:

    Failed to schedule install of IIS Virtual Directories (-2147023728)

    j. Click Next.

    Note If you select the Enable Advanced Customization option, make sure that the installation directory for Microsoft Forecaster is the Program Files (x86) directory.

    k. After the setup summary screen, review the options displayed and then click Install.

    l. When the installation is complete, click Finish.

    8. Download Microsoft Forecaster 7.0 Service Pack 3 from the following link:

    mbs.microsoft.com/.../frxfor70poverview.htm (mbs.microsoft.com/.../frxfor70poverview.htm)

    Note: The file name is FC70SP3.zip.

    9. Locate the Microsoft Forecaster 7.0 Service Pack 3 zip file that you downloaded and extract the contents.

    10. Install Microsoft Forecaster 7.0 Service Pack 3. To do this, follow these steps:

    a. Double-click the Microsoft Forecaster 7.0 Service Pack 3 setup file (FC70SP3.msi).

    b. The Microsoft Forecaster 7.0 Service Pack 3 setup wizard starts. Click Next.

    c. Click to accept the license agreement and then click Next.

    d. Click Install.

    e. Click Finish when the Microsoft Forecaster 7.0 Service Pack 3 Setup wizard is completed.

    11. Install Microsoft Forecaster 7.0 Web Access.

    a. Double-click the Microsoft Forecaster 7.0 Service Pack 3 setup file (FC70SP3.msi).

    b. The service pack installer will detect that the service pack is already applied. Select Add or Remove Features, and then click Next.

    c. Check the Microsoft Forecaster Web Access option, and then click Next.

    d. Enter a name to use in the Virtual Directory field. This will be used when you access the Microsoft Forecaster Web Access website.

    e. Enter a port number in the Port field. We recommend that you use the default port 80.

    f. In the Host Name field, enter the host name that will be used to access the Microsoft Forecaster Web Access site.

    g. Click Next.

    h. Click Modify on the Microsoft Forecaster 7.0 Service Pack 3 setup summary screen.

    i. Click Finish when the Microsoft Forecaster 7.0 Service Pack 3 Setup wizard has finished.

    12. Download Hotfix 4 for Microsoft Forecaster 7.0 SP3 from the following link:

    mbs.microsoft.com/.../frxfor70poverview.htm (mbs.microsoft.com/.../frxfor70poverview.htm)

    Note The file name is FC073HF4.zip.

    13. Install Hotfix 4 for Microsoft Forecaster 7.0 SP3 . To do this, follow these steps:

    a. Locate the Microsoft Forecaster 7.0 Service Pack 3 Hotfix 4 .zip file that you downloaded and extract the contents.

    b. Double-click the Microsoft Forecaster 7.0 Service Pack 3 Hotfix 4 setup file (FC073HF4.msi).

    c. The Microsoft Forecaster 7.0 Service Pack 3 Hotfix 4 Setup wizard starts. Click Next.

    d. Click to accept the license agreement and then click Next.

    e. Click Install.

    f. Click Finish when the Microsoft Forecaster 7.0 Service Pack 3 Hotfix 4 Setup wizard has finished.

    14. Microsoft Forecaster 7.0 is now installed and the Microsoft Forecaster Web Access website created. Additional steps are required to configure Microsoft Forecaster, create the database, and configure the link to the database for the Web Access portion to work. Refer to the Microsoft Forecaster 7.0 installation guide for more information. You can find these files inside the “Help” directory on the Microsoft Forecaster 7.0 installation source. You can also review the installation guide at the following link:

    mbs.microsoft.com/.../Installforecaster7 (mbs.microsoft.com/.../Installforecaster7)

    15. Prepare the server that is running IIS to install Microsoft Management Reporter. To do this, follow these steps:

    a. Click Start, and then click Server Manager.

    b. Expand Roles.

    c. Expand the Web Server (IIS) role.

    d. Select Internet Information Services (IIS) Manager.

    e. In IIS Manager, expand the server name and then select Application Pools.

    f. In the Actions pane, click Set Application Pool Defaults.

    g. Change the Enable 32-Bit Applications value to False.

    h. Click OK to save the change.

    i. Right-click the Microsoft Forecaster 7.0 Service Pack 3 application pool and then click Advanced Settings.

    j. Make sure that the Enable 32-Bit Applications value is set to True.

    k. Click OK to save the setting.

    16. Download Microsoft Management Reporter from the following link:

    mbs.microsoft.com/.../mroverview.htm (mbs.microsoft.com/.../mroverview.htm)

    17. Extract the zip files that are used for the Microsoft Management Reporter installation. No additional steps are required to install Microsoft Management Reporter as Microsoft Management Reporter will run on a 64-bit operating system. Make sure that the system requirements are met and install Microsoft Management Reporter by using the recommended installation process in the available installation guide. You can obtain the system requirements and installation guide for Microsoft Management Reporter from the following link:

    www.microsoft.com/.../details.aspx (www.microsoft.com/.../details.aspx)

    Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (go.microsoft.com/fwlink) for other considerations.

  • Deborah Bussin Profile Picture
    Deborah Bussin 205 on at
    Re: MS Forecaster W2008 Server R2

    I am not able to retrieve KB2491967.  Is there another way to obtain the instructions?

    Thank you

  • Suggested answer
    Re: MS Forecaster W2008 Server R2

    Hi Richard,

    For a 64-bit Operating System you will need to manually download the 64-bit versions of the components that the installer tries to install. If you click on the install and write down the few components, and then download the 64-bit versions from microsoft.com/downloads.

    Then you can install base Forecaster 7.0, but not web access. Support for Server 2008 was added with SP3. Upgrade to SP3, and then choose to add/remove components and install web access.

    KB2491967 (How to install Microsoft Forecaster 7.0 and the Microsoft Management Reporter Application Service on the same Microsoft Windows Server 2008 64-bit IIS server) has complete steps for installation, just ignore the Management Reporter portion for now.

    Thanks,

    Ryan

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: MS Forecaster W2008 Server R2

    It appears that it does.  This is from Microsoft's website (www.microsoft.com/.../forecaster.aspx and fact sheet links are on the right side of the screen):

    Server requirements

    Forecaster is supported on the following server platforms:

    Component Database Server Requirements

    Processor Dual processor 800 MHz or higher recommended

    RAM 1 GB recommended

    Hard disk 5+ GB preferred

    Note

    5 GB may be sufficient. However, specific disk requirements vary widely and must be planned for based on the volume of data to be created, stored, and analyzed. These recommendations are only initial configuration guidelines.

    Operating system • Windows Server® 2008, Windows Server 2003 R2 or Windows® 2000 Server Service Pack 4 (SP4). Both x86-64 and x86-32 are supported.

    • Operating system compatible with Oracle.

    Component Database Server Requirements

    Database • Microsoft SQL Server® 2008. Both x86-64 and x86-32 are supported.

    • Microsoft SQL Server 2005 Service Pack 2 (SP2). Both x86-64 and x86-32 are supported.

    • Microsoft SQL Server 2005 Express Edition. Both x86-64 and x86-32 are supported.

    • SQL Server 2000 Service Pack 3 (SP3) preferred

    • Oracle 10g Standard Edition and Enterprise Edition

    (Forecaster ExpressLink and FRx® DirectLink are not supported on Oracle platforms.)

    • Oracle 9i Standard Edition and Enterprise Edition

    (Forecaster ExpressLink and FRx DirectLink are not supported on Oracle platforms.)

    Protocols Forecaster works with virtually any database-supported network protocols.

    Component Web Server Requirements (applicable only if using Forecaster Web Access option)

    Processor 800 MHz or higher recommended

    RAM 1 GB or higher recommended

    Hard disk 500 MB preferred

    Note

    Hard disk space requirements will vary depending on configuration and database platform. 20 MB is recommended free to install Forecaster Web Access. In some cases, prerequisite software may also be installed and account for an additional 500 MB of free disk space.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans