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

  • From: Jerry Young <jerrygyoungii@xxxxxxxxx>
  • To: isalist@xxxxxxxxxxxxx
  • Date: Thu, 24 Jun 2010 13:33:49 -0400

On the Array Properties under the Configuration Storage Tab, what
authentication type are you using for the connections from the array
members?  Windows authentication or Authentication over SSL encrypted
channel?

On Thu, Jun 24, 2010 at 12:47 PM, D PIETRUSZKA USWRN INTERLINK INFRA SHIFT
MGR <DPietruszka@xxxxxx> wrote:

>  That is exactly what I did.
>
> It is actually my own account what I’m using. But the error is weird and I
> can’t find any more info on event viewer to help to troubleshoot.
>
>
>
> I’m trying to see if anybody else have experience with that issue or I will
> have to open a case with Microsoft for it.
>
>
>
> Regards
>
> *Diego R. Pietruszka*
>
>
>
> *From:* isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
> *On Behalf Of *Jerry Young
> *Sent:* Thursday, June 24, 2010 12:38 PM
> *To:* isalist@xxxxxxxxxxxxx
> *Subject:* [isalist] Re: Install of TMG on 2K8 R2
>
>
>
> Same yourself a headache and use the same account to join the server to the
> array that you used to install the EMS server (I think that's a requirement,
> anyway??).
>
> On Thu, Jun 24, 2010 at 12:34 PM, D PIETRUSZKA USWRN INTERLINK INFRA SHIFT
> MGR <DPietruszka@xxxxxx> wrote:
>
> Tired of not being able to install TMG, I reinstall the OS and TMG
> installed right away after that.
>
>
>
> But now I have another weird problem. When I try to join the new server to
> an existing array manage by an EMS server it always return the below error.
>
>
>
> *The Operation Failed*
>
> *You do not have the necessary permissions to perform this action*
>
>
>
> The user I’m using to join the server to the array, is Array administrator
> on the new server, Array administrator on the Array it is trying to join to
> and enterprise administrator on the EMS server. Also is local administrator
> on all those servers. So what can be wrong? I mean, which other permission
> it needs?
>
>
>
> Thanks
>
>
>
> Regards
>
> *Diego R. Pietruszka*
>
>
>
> *From:* isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
> *On Behalf Of *Jim Harrison
> *Sent:* Saturday, June 19, 2010 5:24 PM
> *To:* isalist@xxxxxxxxxxxxx
> *Subject:* [isalist] Re: Install of TMG on 2K8 R2
>
>
>
> Once you’ve failed a TGM installation, you need to ensure that you:
>
> 1.       Close the installer
>
> 2.       Remove all vestiges of TMG, AD-LDS or SQL that may have been
> partially installed via Control Panel, Programs and Features
>
> 3.       Delete any installation folders that may have been created for
> those applications:
>
> a.       %programfiles%\Microsoft Forefront Threat Management Gateway
>
> b.      %programfiles%\Microsoft SQL Server
>
> c.       %programfiles(x86)%\ Microsoft SQL Server
>
>
>
> Jim
>
>
>
> *From:* isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
> *On Behalf Of *D PIETRUSZKA USWRN INTERLINK INFRA SHIFT MGR
> *Sent:* Saturday, June 19, 2010 2:14 PM
> *To:* isalist@xxxxxxxxxxxxx
> *Subject:* [isalist] Re: Install of TMG on 2K8 R2
>
>
>
> Well, that is basically what I did. With the exception of the static routes
> because both servers are on the same subnet.
>
> But the error keep coming.
>
>
>
> Regards
>
> *Diego R. Pietruszka*
>
>
>
> *From:* isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
> *On Behalf Of *Jerry G. Young II
> *Sent:* Saturday, June 19, 2010 1: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
>
>
>
>
> --
> Cordially yours,
> Jerry G. Young II
> Microsoft Certified Systems Engineer
> Young Consulting & Staffing Services Company - Owner
> www.youngcss.com
>



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

Other related posts: