About Me

Colorado
Paul has 18 years experience with Microsoft SQL Server. He has worked in the roles of production DBA, database developer, database architect, applications developer, business intelligence and data warehouse developer, and instructor for students aspiring for MCDBA certification. He has performed numerous data migrations and supported large databases (3 Terabyte, 1+ billion rows) with high transactions. He is a member of PASS, blogs about lessons learned from a developer’s approach to SQL Server administration, and has been the president of the Boulder SQL Server Users’ Group for 11 years, from January 2009 to 2020.

Friday, May 15, 2015

Workaround for error with installing SSDT-BI for SQL 2014

While installing SSDT –BI for SQL 2014 (aka SQL Server Data Tools - Business Intelligence for Visual Studio 2013), you might get this error if you have a pre-existing instance of SQL 2014 and you had opted to use the existing instance.
Same architecture installation


When you click on View detailed report, you will find this message:

BlockMixedArchitectureInstall
The CPU architecture of installing feature(s) is different than the instance specified.  To continue, add features to this instance with the same architecture.

Solution
Apparently this is a bug, because if you go back a couple of dialog windows and select Perform a new installation of SQL Server 2014, it will actually use the existing instance without installing a new one.





No comments:

Post a Comment