Terminal Server and Office 2007

Discussion in 'Windows Server' started by adamsmith, Dec 1, 2009.

  1. adamsmith

    adamsmith MDL Novice

    Aug 14, 2009
    14
    0
    0
    Hi All,

    Not sure if this is the best section, but seems correct enough....

    Can anyone suggest what needs to be done to get Office 2007 running on a Terminal Server? ;)

    Thanks
     
  2. gentoo

    gentoo MDL Senior Member

    Oct 6, 2009
    394
    9
    10
    #2 gentoo, Dec 1, 2009
    Last edited by a moderator: Apr 20, 2017
  3. gentoo

    gentoo MDL Senior Member

    Oct 6, 2009
    394
    9
    10
    #3 gentoo, Dec 1, 2009
    Last edited by a moderator: Apr 20, 2017
    Deploying Office 2007 with Group Policy Startup Scripts


    To get the most out of your Office 2007 deployment you will need to deploy using SETUP.EXE, not the MSI file. The reason for this is the changes Microsoft has made to Office 2007 setup there are no more transform files, instead customisation is achieved via Windows Installer patch files (.MSP). Using SETUP.EXE for deployment will automatically apply the patch file during installation.
    When deploying applications via a startup script you will need to determine if the software is already installed before attempting to start the install, otherwise the installation will occur on every boot. There are a number of different ways of doing this; the first of which I had hoped would have been a WMI filter such as this:


    Code:
    SELECT * FROM Win32_Product WHERE (IdentifyingNumber <> "{90120000-0030-0000-0000-0000000FF1CE}")
    or this:


    Code:
    SELECT * FROM Win32_Product WHERE (Caption <> "Microsoft Office Enterprise 2007")
    The problem with either of these filters is that they will cause the GPO to apply whether Office is installed or not because they evaluate to TRUE. So unfortunately using a WMI Filter to control when Office is installed is out of the question.
    A method that is similar to the WMI Filter, but uses a VBscript script to detect the presence of the installed Office applications, could work like this:


    Code:
    Set wshShell = WScript.CreateObject("WScript.Shell")
    Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2")
    Set colSoftware = objWMIService.ExecQuery ("Select * from Win32_Product")
    For Each objSoftware in colSoftware
        If objSoftware.Caption = "Microsoft Office Enterprise 2007" Then
            OfficeInstalled = True
            Exit For
        End If
    Next
    If OfficeInstalled <> True Then
        Set oExec = wshShell.Exec ("\\company.local\Public\Applications\Office2007\SETUP.EXE")
        Do While oExec.Status = 0
            WScript.Sleep 100
        Loop
    End If
    This script will detect whether Office Enterprise 2007 is installed and if not start the installation. You could also implement some error checking around this to write an event to the Application log to record errors. One problem with using the Win32_Product WMI class to enumerate installed applications is that the process is slow enumeration takes about 20 seconds on my laptop (Intel Core Duo T2300, 1.6GHz).
    The simplest way to detect if Office is installed before starting the setup program is to check if a file exists. One of the most common files will be WINWORD.EXE. So a script could look like this:


    Code:
    IF NOT EXIST "%ProgramFiles%\Microsoft Office\Office12\WINWORD.EXE" START /WAIT \\company.local\Public\Applications\Office2007\SETUP.EXE
    Deploying Office 2007 via Group Policy will be challenging and may require you to perform more testing than with previous versions. For smaller organisations that have relied on Group Policy previously Office deployment can still be achieved, however perhaps it’s time to look into something a little more flexible. What I’ve seen of System Centre Essentials so far is pretty impressive and I think it’s just the tool for small organisations. Hopefully I’ve given you enough here to get your Office deployment started. I’d be interested in hearing how others are going with their own deployments.​

     
  4. adamsmith

    adamsmith MDL Novice

    Aug 14, 2009
    14
    0
    0
    Hi Gentoo,

    Thanks for taking the time to reply.

    I was probably more looking at alternative ways of getting Office 07 on a terminal for testing purposes.

    I have to ensure some testing is done for work, before our client is willing to spend ten thousand plus on licencing.

    Anyway, thanks for your time and effort.
     
  5. gentoo

    gentoo MDL Senior Member

    Oct 6, 2009
    394
    9
    10
    See if they will get you a Technet subscription.
     
  6. adamsmith

    adamsmith MDL Novice

    Aug 14, 2009
    14
    0
    0
    Thanks for the suggestion. I'll look into it.

    Adam