Solved

How to fix the installation failure when I install SQL Data Tool for VS 2012?

Posted on 2014-10-14
2
323 Views
Last Modified: 2014-10-28
I downloaded the installation file here, http://www.microsoft.com/en-us/download/details.aspx?id=36843 

I run it and I get the failure report in the attached html file, BlockMixedArchitectureInstall.  
Below please also see my SQL version information( I believe it's SQL 2012).  I have Visual Studio 2012.

Microsoft SQL Server Management Studio                                    11.0.3000.0
Microsoft Analysis Services Client Tools                                    11.0.3000.0
Microsoft Data Access Components (MDAC)                                    6.1.7601.17514
Microsoft MSXML                                    3.0 4.0 6.0
Microsoft Internet Explorer                                    8.0.7601.17514
Microsoft .NET Framework                                    4.0.30319.18444
Operating System                                    6.1.7601

Where can I find the right versino of this sql data tool to install for me environment?
Thank you.
System-Configuration-Check-Report-for-Mi
0
Comment
Question by:lapucca
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 40381085
When Installing you need to select 'New Instance' option.

This is because it gets confused by trying to install an x86 architecture version of sql server 2012 sp1 even though your sql server 2012 version is x64 architecture and is already installed with sp1.

It will not create a new instance even though that is the option you select.

http://technet.microsoft.com/en-us/library/jj856966(v=sql.110).aspx
0
 

Author Closing Comment

by:lapucca
ID: 40409134
Perfect!  It works just as you suggested.  Thank you.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
string fuctions 4 25
SSIS with VPN COnnection 2 70
Help Required 3 92
How to construct an if else statement from existing code 6 19
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question