Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backward compatibility install failed on Windows 2008 R2


Backward compatibility install failed on Windows 2008 R2

Author
Message
Adam Bean
Adam Bean
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1215 Visits: 2160
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.
Mel Lusk
Mel Lusk
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 88
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.
Adam Bean
Adam Bean
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1215 Visits: 2160
Thanks for the response Mel. That is quite unfortunate to hear ... but thank you.

---
SQLSlayer
Making SQL do what we want it to do.
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 3816
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Adam Bean
Adam Bean
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1215 Visits: 2160
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.
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 3816
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Adam Bean
Adam Bean
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1215 Visits: 2160
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.
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 3816
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Adam Bean
Adam Bean
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1215 Visits: 2160
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.
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 3816
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search