[isalist] Re: Install of TMG on 2K8 R2

  • From: "Thomas W Shinder" <tshinder@xxxxxxxxxxx>
  • To: <isalist@xxxxxxxxxxxxx>
  • Date: Sat, 19 Jun 2010 13:38:03 -0500

Yo Jerry,

 

Great to meet you ad TechEd!

 

Make sure you deploy DirectAccess ASAP J

 

Tom

 

From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jerry G. Young II
Sent: Saturday, June 19, 2010 12:07 PM
To: isalist@xxxxxxxxxxxxx
Cc: isalist@xxxxxxxxxxxxx
Subject: [isalist] Re: Install of TMG on 2K8 R2

 

Also keep in mind that TMG now wants to control your static routes.  So, to 
avoid making the same, tedious mistake I made, try the following order:

 

1. Manually set single static route to facilitate network connectivity to your 
EMS server (if using one).

2. Pre-configure the static route settings in the Array.

3. Install TMG.

4. Join Array.

 

Don't bother configuring anything on the TMG server prior to joining the Array; 
settings will just get overwritten and you'll get to experience some of the 
wonderful joy I did. :P

Cordially yours,

Jerry G. Young II

+=+ Sent via iPhone +=+


On Jun 19, 2010, at 12:19 PM, Jim Harrison <Jim@xxxxxxxxxxxx> wrote:

        There is no way to join an array as part of the installation.

        This is because the “Join array” wizard that you start from the console 
doesn’t exist until the TMG components are installed.

         

        From: isalist-bounce@xxxxxxxxxxxxx 
[mailto:isalist-bounce@xxxxxxxxxxxxx] On Behalf Of Jerry Young
        Sent: Wednesday, June 16, 2010 12:19 PM
        To: isalist@xxxxxxxxxxxxx
        Subject: [isalist] Re: Install of TMG on 2K8 R2

         

        That's an error with installing SQL Express 2008, not TMG.

         

        It's throwing an error when its checking for the existence of the 
reporting database (doesn't exist).

         

        0x84be03f4 = Checks if the Reporting Services catalog database file 
exists.

        Review http://msdn.microsoft.com/en-us/library/dd981032(SQL.100).aspx, 
specifically near the bottom where it describes the logs that the installer 
writes.  Perhaps there is something in there.

         

        And just for the sake of sanity, check to make sure the W2K8 R2 box 
you're installing TMG on meets the SQL Express 2008 system requirements (.Net 
and all that).

        On Wed, Jun 16, 2010 at 2:59 PM, D PIETRUSZKA USWRN INTERLINK INFRA 
SHIFT MGR <DPietruszka@xxxxxx> wrote:

        Hello all, I have a couple of servers with TMG on it and was trying to 
install another one to make it part of an existing array.

         

        First of all, on ISA 2006 if my memory is not that bad, there was an 
option to install and while installing choose if that box was going to be part 
of an array, so we could pick the CSS then which array you wanted to join (or 
created a new one), etc…..

        On TMG I found the only option to be: Installed as an stand alone TMG 
server and then from the console choose to join an existing array. If I’m wrong 
on that please anybody let me know. But besides that, I tried to install this 
particular TMG server 3 times already and before reinstalling the entire OS I 
wanted to ask for help.

         

        Every time I’m running the installation, when the wizard is on 
“Additional Components (Estimated……..)” the installation fail with this error:

         

        -          Microsoft SQL Express 2008 (reporting instance could not be 
installed). As a result, Forefront TMG installation cannot be completed.

         

        Any help will be appreciated.

         

        ISAWRAP is showing this:

         

        13:01:24 INFO:   Add/Remove entry was created

        13:01:24 INFO:   Installing Additional components...

        13:01:24 INFO:   Activating Extration of SQL Express 2008 SP1 Package, 
command line args = '-s -f 
"C:\Windows\temp\{79FA0C64-EA49-46CB-9CEA-6591E4A9887D}" -e'

        13:01:24 INFO:   SQL Express 2008 SP1 Package path is .\Program 
Files\Microsoft ISA Server\SQLE\SQLExpress2008SP1.exe

        13:02:50 INFO:   Process completed successfully

        13:02:50 INFO:   SQL Express 2008 SP1 Package was sucessfully extracted 
to 'C:\Windows\temp\{79FA0C64-EA49-46CB-9CEA-6591E4A9887D}'

        13:02:50 INFO:   Activating SQL Express installation, command line args 
= '/QUIET /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=MSFW 
/SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /BROWSERSVCSTARTUPTYPE=4 
/SAPWD=************** /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /NPENABLED=0 
/TCPENABLED=0 /SKIPRULES=RebootRequiredCheck /HIDECONSOLE 
/PCUSource="C:\Windows\temp\{79FA0C64-EA49-46CB-9CEA-6591E4A9887D}\PCU"'

        13:02:50 INFO:   SQL Express 2008 installation path is 
C:\Windows\temp\{79FA0C64-EA49-46CB-9CEA-6591E4A9887D}\setup.exe

        13:09:08 INFO:   Process completed successfully

        13:09:08 INFO:   SQL Express 2008 successfully installed

        13:09:08 INFO:   Starting SQL Express service

        13:09:18 INFO:   Changing network service permissions to allow access 
to SQL Express

        13:09:19 INFO:   Changing SQL Express tempdb size

        13:09:19 INFO:   Failed to change Tempdb MAXSIZE, error = ,, 
0x80040e09. Ignoring...

        13:09:19 INFO:   Moving SQL Express tempdb to stingray logging directory

        13:09:24 INFO:   AdjustSSEConfiguration completed successfully.

        13:09:24 INFO:   Activating SQL Express installation, command line args 
= '/QUIET /ACTION=Install /FEATURES=SQLEngine,RS /INSTANCENAME=ISARS 
/SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /BROWSERSVCSTARTUPTYPE=4 
/SAPWD=************** /SECURITYMODE=SQL /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" 
/RSINSTALLMODE=DefaultNativeMode /RSSVCACCOUNT="NT AUTHORITY\SYSTEM" 
/RSSVCStartupType=Automatic /NPENABLED=0 /TCPENABLED=1 
/SKIPRULES=RebootRequiredCheck /HIDECONSOLE 
/PCUSource="C:\Windows\temp\{79FA0C64-EA49-46CB-9CEA-6591E4A9887D}\PCU"'

        13:09:24 INFO:   SQL Express 2008 installation path is 
C:\Windows\temp\{79FA0C64-EA49-46CB-9CEA-6591E4A9887D}\setup.exe

        13:10:37 ERROR:               Setup failed. Error returned: 0x84be03f4

        13:10:37 ERROR:               Installation of SQL Express 2008 failed. 
hr = 0x84be03f4

        13:10:37 ERROR:               Installation failed. hr = 0x84be03f4

        13:10:37 ERROR:               Installation failed, hr=0x84be03f4

        14:24:03 ERROR:               InstallProducts:Install Additional 
components failed, hr=0x84be03f4

        14:24:03 INFO:   Rollback: Performing rollback after installation 
failure.

        14:24:03 INFO:   CMsiAttendantInstaller::Prepare: Upgrade code is not 
set

        14:24:03 INFO:   CMsiAttendantInstaller::Prepare: There is no any 
product code for upgrade code 

        14:24:03 INFO:   CMsiAttendantInstaller::Prepare: Upgrade code is not 
set

        14:24:03 INFO:   CMsiAttendantInstaller::Prepare: There is no any 
product code for upgrade code 

        14:24:03 INFO:   The instance Id of instace MSFW is MSSQL10.MSFW

        14:24:03 INFO:   GetUninstallCode: Prepare: product code is 
{FBD367D1-642F-47CF-B79B-9BE48FB34007}

        14:24:03 ERROR:               CSSEInstaller::GetInstanceId failed to 
read from reg 'ISARS' 

        14:24:03 INFO:   CSSEInstaller::Prepare: Failed to get the instace id 
of ISARS

        14:24:03 INFO:   CMsiAttendantInstaller::Prepare: Upgrade code is not 
set

        14:24:03 INFO:   CMsiAttendantInstaller::Prepare: There is no any 
product code for upgrade code 

        14:24:03 INFO:   The instance Id of instace MSFW is MSSQL10.MSFW

        14:24:03 INFO:   Activating SQL Express uninstallation, command line 
args = '/QUIET /ACTION=Uninstall /FEATURES=SQLEngine /INSTANCENAME=MSFW 
/SKIPRULES=RebootRequiredCheck /HIDECONSOLE'

        14:24:03 INFO:   Uninstall command line is C:\Program Files\Microsoft 
SQL Server\100\Setup Bootstrap\Release\Setup.exe

         

         

        Regards

        Diego R. Pietruszka

         

        
        
        
        -- 
        Cordially yours,
        Jerry G. Young II
        Microsoft Certified Systems Engineer
        Young Consulting & Staffing Services Company - Owner
        www.youngcss.com

Other related posts: