Last post Jun 25, 2017 10:07 PM by sking
May 27, 2017 09:11 PM|sking|LINK
I changed my sql server to 2014 from R2. All because of the fact my web host upgraded my databases without my knowledge and I had to get '14 to use on my local machine.
I have googled around for this and I have the error when I try to create a tableadapter and create the Query Builder button to populate the available tables, is :
Could not load file or assembly Microsoft.Sqlservermanagement.sdk.sfc Verson 10.0.0.0 , etc....
I have downloaded and installed the Shared managementobjects.msi from Microsoft for 2012 and 2014 and it did not help anything. I am still getting the same error.
I also downloaded DB2OLEDBV5_x64 installed it and it doesn't make any difference.
What do I do to make visual studio see the available tables in the db?
May 29, 2017 08:09 AM|EvenMa|LINK
Could you sure you are using SQL 2014?
As far as I know, the version of Microsoft.SqlServer.Management.Sdk.Sfc in SQL 2014 is 12.0,see the following list:
DataBaseVersion SFC Version
According to this ,might you are still using SQL2008R2.
Try to install SQLSysClrTypes.msi and SharedManagementObjects.msi for SQL 2008 R2 in the following link.
If you have any other questions, please feel free to contact me any time.
May 30, 2017 05:21 AM|sking|LINK
This does not help. I have already tried downloading and installing the 2014 feature pack files.
I selected the shared management objects. Right now I'm trying service pack 1 for sql 2014.
I just installed this and it did nothing to make Visual Studio see the tables. What am I going to do?
Does someone on this forum understand this issue? This is really interrupting my work.
May 30, 2017 07:14 AM|wmec|LINK
Just go to http://www.microsoft.com/en-us/download/details.aspx?id=42295 and download:
then install it, and restart visual studio.
PS: You may need install
May 30, 2017 08:59 PM|sking|LINK
I have done this twice now. have installed both of the above. I cannot even create a new connection string to this database. I get an invalid object error message. Should I uninstall Visual Studio?
May 31, 2017 02:01 AM|EvenMa|LINK
According to the error message that’s said the version of Microsoft.SqlServerManagement.SDK.SFC is 10.0,I feels you are still using SQL2008R2,could you check it? Could you change the connection string in configuration file after upgrade SQL Server?
You could use SELECT @@Version in SQL Management Studio to check the version of SQL Server(use the same connection string in your configuration file).
Also might you could install Visual C++ Redistributable Packages for Visual Studio ,I’m not sure the version of visual studio which you are using, if there is VS2015,you could download the install package from the following
vcredist_x64.exe for X64 OS
vcredist_x86.exe for X86 OS
Jun 24, 2017 11:29 PM|sking|LINK
I am running SQL Server management studio 2016 and I also have SQL server 2014. When I go into add remove programs, I attempt to uninstall 2016, it says that my computer is not suitable for SQL server 2016. It will not allow me to remove it from my machine.
Yet it is installed. When I go to the configuration manager of 2014, I can start the server when it is stopped. Also, I can go into 2016 and start the service under it. When I start either server, the other server starts automatically. This does not sound
good to me. How can I manually get this 2016 SQL server off my computer?
Also, I'm using the management studio 2016 to complicate things further. Once I remove the sql servr 2016 manually, won't that delete the management studio as well? I do not have a management studio under my 2014 sql server programs. Is there supposed
to be one?
Jun 25, 2017 10:07 PM|sking|LINK
I was able to get it fixed. The solutions? I removed both 2014 & 2016 sql server from my machine. I downloaded and reinstalled 2014. This did the trick and VS now recognizes the tables. What a bunch of hoops to go through.