Configure Planning Server prerequisites for Kerberos authentication

Before you deploy Planning Server, you must ensure that your environment meets the following prerequisites.

  • SQL Server Analysis Services and any services that you want to connect with are installed, preferably from a fresh installation source that has not been imaged. We recommend that you use a computer that has not been renamed. This is because the setSPN tool that is described later in this article is easier to configure from a fresh installation on a server that has its original computer name.

  • The Active Directory service is configured with Windows 2000 Server or Windows Server 2003. You must have Active Directory configured in at least Native Mode of Windows 2000 Server. For more information about domain functional levels, see Active Directory Functional Levels (https://go.microsoft.com/fwlink/?LinkId=99679).

  • All users are part of the same Active Directory domain.

If Planning Business Modeler or PerformancePoint Add-in for Excel are installed on a computer running Windows Server 2003, you need to have Service Pack 2 installed. Additionally, if you want to specify a Web site by its port, the service principal name (SPN) needs to reflect that, and the following procedure might be necessary to configure the registery so that Internet Explorer 6.0 can connect to the associated PORT.

For more information, see the following article in the Microsoft Knowledge Base: Internet Explorer 6 cannot use the Kerberos authentication protocol to connect to a Web site that uses a non-standard port on Windows XP, Windows Server 2003 or Windows Vista (https://go.microsoft.com/fwlink/?LinkId=99681).

Use the following procedure to manually specify a Web site port in Windows Server 2003.

To manually specify a Web site port in Windows Server 2003

  1. Click Start, click Run, type regedit, and then click OK.

  2. In the Registry Editor, locate and then right-click the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl

  3. On the menu that appears, point to New, and then click Key.

  4. Type FEATURE_INCLUDE_PORT_IN_SPN_KB908209, and then press ENTER.

  5. On the Edit menu, point to New, and then click DWORD Value.

  6. Type iexplore.exe, and then press ENTER.

  7. On the Edit menu, click Modify.

  8. In the Value data box, type 1, and then click OK.

  9. Exit Registry Editor.