Syed Jahanzaib Personal Blog to Share Knowledge !

February 23, 2012

Forefront TMG 2010 installation failed “SQL Installation Error” [Solved]


Today at my company I was installing TMG 2010 on Windows 2008 R2 64bit on MS Hyper-visor VM and encounter following errors during installation related to SQL 2008  ,
Example:
# Forefront TMG Installation terminates – SQL Express 2008 Could Not Be Installed
# Error installing TMG 2010: failed to install SQL Express 2008 (reporting instance)
After some googling, I managed to resolved this problem. This is what I did:

#    Go to Control Panel   >   Uninstall Programs
#    Uninstall Microsoft SQL Server 2008
#    Uninstall Microsoft SQL Server 2008 Native Client
#    Go to C:\Program Files
#    Delete folders ‘Microsoft Forefront Threat Management Gateway‘ and ‘Microsoft SQL Server’
#    Go to C:\Program Files (x86)
#    Delete folders ‘Microsoft SQL Server’
#    Reboot your windows
#    Right click on TMG Setup and select ‘Run as Administrator‘ , and follow on the screen setup.

This time installation went smooth.

After this I installed TMG SP1 and SUP1 from

You can download SP1 from : http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=f0fd5770-7360-4916-a5be-a88a0fd76c7c

and you can download SU1 from : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=695d0709-0d8b-45ee-afdb-727c4428ca4d

Afterwards, download TMG SP2 , and install it.

http://www.microsoft.com/download/en/details.aspx?id=27603

 

 

 

Forefront Remote Management Tool error
Refresh Failed. The parameter is incorrect.

If you have installed Forefront Remote Management tool to manage your tmg remotely via your workstation, and you received following error

Forefront Remote Management Tool error
Refresh Failed. The parameter is incorrect.

error

 

Make sure that you have the same level of Service packs and patches that are installed on TMG Server. Also make sure that your ip is added TMG Rmote Management Policy Section. (In Firewall System Policy)
E.g:

SU1,  SP1 , SP2  (Software Update 1, Service Pack 1, Service Pack 2)

I hope these steps will help you too 🙂

Regard’s

Syed Jahanzaib

5 Comments »

  1. very helpfull,
    Thnx a lot.

    mms

    Comment by mms — May 29, 2012 @ 8:40 PM

  2. Very informative blog…

    Comment by Muzammil — January 8, 2013 @ 9:52 PM

  3. didn’t work.

    Comment by Frank — November 27, 2013 @ 6:41 AM

  4. […] Forefront TMG 2010 installation failed “SQL Installation … – Feb 23, 2012 · Today at my company I was installing TMG 2010 on Windows 2008 R2 64bit on MS Hyper-visor VM and encounter following errors during installation related …… […]

    Pingback by Fix Forefront Tmg 2010 Error 502 Windows XP, Vista, 7, 8 [Solved] — November 22, 2014 @ 9:12 AM

  5. This error occurs mainly because of access permission for TMG installation. Whenever we install TMG in some other location other than default C drive we will face this issue. I know how to resolve.

    Comment by anonymous — September 28, 2015 @ 7:25 PM


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: