SQL Server 2012 Management Tools - Basic not working

1
votes

I made a fresh install of SQL Server 2012 Express and Management Tools - Basic onto a new computer and none of the tools in the Integration Services folder will run. It gives the following message:

ERROR: The Execute Package Utility requires Management Tools - Basic or Business Intelligence Studio to be installed by the SQL Server 2012 Standard, Enterprise, Business Intelligence, or Evaluation Edition.

Its the Execute Package Utility that I'm after, but the Deployment Wizard and Project Conversion Wizard also give the error.

I've tried uninstalling and reinstalling but that doesn't seem to make a difference. This is on Windows 7 Pro 64 bit computer.

Tools install succeeded notice

1
sql-serversql-server-2012sql-server-express

1 Answers

1
votes

It seems obvious now, but the problem was that I was installing a SQL Server Express version. Even though it installed the needed components it would not run them. I downloaded the Eval version and it worked.

In my defense, the Microsoft SQL Server 2012 site does list SSDT as included with Express with Advanced Services:

https://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx