question

ShielaE2021-7673 avatar image
0 Votes"
ShielaE2021-7673 asked TianyuSun-MSFT commented

Microsoft.SqlServer.ConnectionInfo, Version=16.200.0.0

How/where do you download Microsoft.SqlServer.ConnectionInfo, Version=16.200.0.0?

Error Assembly 'Microsoft.SqlServer.SmoExtended' with identity 'Microsoft.SqlServer.SmoExtended, Version=16.200.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses 'Microsoft.SqlServer.ConnectionInfo, Version=16.200.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' which has a higher version than referenced assembly 'Microsoft.SqlServer.ConnectionInfo' with identity 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ST_0ae5dcb557594f78972b273533c1730e

sql-server-integration-servicesdotnet-package-management
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ShielaE2021-7673,

Please clarify how you are getting the error.

0 Votes 0 ·
ShielaE2021-7673 avatar image ShielaE2021-7673 YitzhakKhabinsky-0887 ·

Server myServer = new Server(ServerName);
Backup bkpDBFullWithCompression = new Backup();

0 Votes 0 ·

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered TianyuSun-MSFT commented
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I installed SMO and ConnectionInfo from Nuget. It looks like the versions aren't in synch.
191944-smo-nuget.jpg191933-connectioninfo-nuget.jpg


Error Assembly 'Microsoft.SqlServer.SmoExtended' with identity 'Microsoft.SqlServer.SmoExtended, Version=16.200.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses 'Microsoft.SqlServer.ConnectionInfo, Version=16.200.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' which has a higher version than referenced assembly 'Microsoft.SqlServer.ConnectionInfo' with identity 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ST_0ae5dcb557594f78972b273533c1730e

0 Votes 0 ·
smo-nuget.jpg (33.2 KiB)

Hi @ShielaE2021-7673 , I tried to install Microsoft.SqlServer.SqlManagementObjects NuGet package (version 161.47008.0) and after I built the project, I can see that the version of Microsoft.SqlServer.SmoExtended is 16.200.47008.0 and the version of Microsoft.SqlServer.ConnectionInfo is 16.200.47008.0. The version of them are both higher than 16.200.0.0. Please try to reinstall/restore this NuGet package and test again. Besides, does your project include/reference a lower version(10.0.0.0) of Microsoft.SqlServer.ConnectionInfo dll file?
192605-image.png

0 Votes 0 ·
image.png (42.1 KiB)