Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Backward compatibility install failed on Windows 2008 R2 Expand / Collapse
Author
Message
Posted Tuesday, December 22, 2009 9:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
All,

First off yes, I realize at this point with SQL2008 we shouldn't be using DTS, but this is out of my control (for now). I need to continue to have support on this new environment.

Anyways, I've been successful using the backward compatibly/DTS designer components and copying the .dll files on Windows 2008 and Windows 7, but it appears that the install fails on Windows 2008 R2:

"Installation of this product failed because it is not supported on this operating system".

Anyone experience this yet and/or find resolution?

Thanks


---
SQLSlayer
Making SQL do what we want it to do.

Post #837999
Posted Monday, December 28, 2009 2:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 1:23 PM
Points: 4, Visits: 82
I'm pretty certain that this is because Windows 2008 R2 is 64-bit whereas the DTS Designer is 32-bit. Although I'd think that it would still run using WOW64, the installer for the DTS backwards-compatibility components may be 16-bit, in which case you're out of luck.
Post #839595
Posted Monday, January 4, 2010 7:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
Thanks for the response Mel. That is quite unfortunate to hear ... but thank you.

---
SQLSlayer
Making SQL do what we want it to do.

Post #841441
Posted Tuesday, January 5, 2010 3:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 2,868, Visits: 3,215
I have successfully installed DTS Designer on W2008 R2. This needs to be followed with copying the DTS Designer dll files to the SQL 2008 program folders as noted in BOL.

You also need the SQL 2005 Backward Compatibility components installed in order for DTS Designer to work.

I also set the Windows environment variable SEE_MASK_NOZONECHECKS to 1 and pause the Windows Update service before running an install, as this prevents come warning messages being produced.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #841949
Posted Tuesday, January 5, 2010 6:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
EdVassie (1/5/2010)
I have successfully installed DTS Designer on W2008 R2. This needs to be followed with copying the DTS Designer dll files to the SQL 2008 program folders as noted in BOL.

You also need the SQL 2005 Backward Compatibility components installed in order for DTS Designer to work.

I also set the Windows environment variable SEE_MASK_NOZONECHECKS to 1 and pause the Windows Update service before running an install, as this prevents come warning messages being produced.


Hi Ed, by changing the NOZONECHECKS, is that how you bypassed the "Installation of this product failed because it is not supported on this operating system" error?


---
SQLSlayer
Making SQL do what we want it to do.

Post #842011
Posted Tuesday, January 5, 2010 6:24 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 2,868, Visits: 3,215
It was originally added to suppress warnings for the unattended install done by FineBuild. It will also suppress some warnings for an interactive install.

I suggest you try it and see what happens.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #842019
Posted Tuesday, January 5, 2010 6:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
Thanks Ed, can you stick with me for a bit longer on this?

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment
- I see no SEE_MASK_NOZONECHECKS on 2008 R2.

What am I missing?


---
SQLSlayer
Making SQL do what we want it to do.

Post #842023
Posted Tuesday, January 5, 2010 6:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 2,868, Visits: 3,215
The SEE_MASK_NOZONECHECKS environment variable does not normally exist. When it does not exist Windows assumes the setting is off. Use the command SET SEE_MASK_NOZONECHECKS=1 to turn it on, and SET SEE_MASK_NOZONECHECKS= to turn it off.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #842049
Posted Tuesday, January 5, 2010 7:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
Ran the SET command, didn't change anything. As soon as I go to install the BC file, it immediately throws that error.

I also tried to install with troubleshoot compatibility. It picked "skip version check" which again did not fix the problem. I'm at a loss to as how you were able to get the install to run.


---
SQLSlayer
Making SQL do what we want it to do.

Post #842062
Posted Tuesday, January 5, 2010 7:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 2,868, Visits: 3,215
Are you running the BC file included in the SQL 2008 media? If you are then it would have been better to have included backward compatibility as one of the features in the SQL install. (Hindsight is wonderful...)

The BC component can be requested for both 32-bit and 64-bit installs of SQL Server 2008, but is only honoured when you do a 64-bit install. If you install on a 32-bit OS then you have to manually run the BC install.

If you are trying to use the SQL 2005 BC media for a SQL 2008 instance this may be the reason it is failing. Look for the SQL2005_BC.msi file in the SQL 2008 media \x64\Setup\x64 folder and run that.

The DTS Designer component is only available in the SQL 2005 Feature Pack, but this version works OK on SQL 2008 (and SQL 2008 R2).


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #842073
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse