I try to add a new connection in Visual Studio from a remote server. The server is on a virtual machine. When I create the connection, Visual Studio can find the remote server, it can also see all existing tables and the connection test is successful. So normally all goes well! Except that when I click OK, the following error message will be displayed:
Unable to add data connection.Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91 gold one icts of dependencies. The specified file was not found.
I checked on the virtual machine file exists 'Microsoft.SqlServer.Management.Sdk.Sfc', and I allowed remote login in my SQL (allow remote connection). I also disabled the firewall and I checked that TCP / IP is enabled.
How can I fix this?