Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0 Error
I have recently installed SQL Server Express and Visual Studio 2012 on my PC. when I opened Server Explorer in Visual Studio 2012 to create a new Database. I got the below error:
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0
I have recently installed SQL Server Express and Visual Studio 2012 on my Windows 7 computer. when I opened Server Explorer in Visual Studio 2012 to create a new Database. When I Right Click DataConnections and select Create New SQL Server Database. I entered the server name and the New Database Name and then when I cliked on OK button, I got the below error:
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0.
If you are running 32 bit Windows 7 operating system. Then you need to install the below packages to get rid of the above error.
1. ENU\x86\SQLSysClrTypes.msi
2. ENU\x86\SharedManagementObjects.msi
Step 1: Visit the below url and then click on Download option.
http://www.microsoft.com/en-us/download/details.aspx?id=35580
Step 2: select the file name:ENU\x86\SQLSysClrTypes.msi and then click on Next. This will shown an option to run this msi file. Please run this msi file and finish the installation.
Step 3: Again visit the above link and click on Download option. this time you need to select the file name:ENU\x86\SharedManagementObjects.msi and then click on Next. This will shown an option to run this msi file. Please run this msi file and finish the installation.
Step 4:Once above 2 files are downloaded and installed. Close the Visual Studio and reopen it. Now you should be able to create the database through server explorer without any errors.
Excellent, Million thanks for the solution, Works fine. I was struggling to solve this problem in VS 2013.