I'm using Windows 7 Home premium.
I am trying to create a Report project in VS2015 with Sql Server 2012
Express. I can run SSMS OK. I added the AdventureWorks2012 DB to test. I am
using Windows Authentication. In VS 2015 when I try to add a connection
to the AdventureWorks2012 Db I can see the DB in the drop down but when I
hit OK I get an error that
Unable to add data connection.
Could not load file or assembly
Microsoft.SqlServer.Management.Sdk.Sfc, Version 220.127.116.11
BUT I have run both ENU\x64\SharedManagementObjects.msi and
SQLSysClrTypes.msi. I still get that error but no direction about what
to do next.
I also installed the following (as viewed from Programs and Features):
Sql Server 2012 (64-bit)
Sql Server 2012 Native Client
Sql Server 2012 Setup
Sql Server 2012 Transact-SQL Compiler Services
Sql Server 2012 Transact-SQL ScriptDom
Sql Server 2012 Data Tools -enu (14.0.60203.0)
Sql Server 2012 Datatools 2015
Sql Server 2012 CLR Types for SQL Server 2012 (x64)
Any help about what to do next is GREATLY appreciated!