SOLVED

Trying to connect via ODBC. Can't find assembly 'Microsoft.SqlServer.ConnectionInfo'

%3CLINGO-SUB%20id%3D%22lingo-sub-2612089%22%20slang%3D%22en-US%22%3ETrying%20to%20connect%20via%20ODBC.%20Can't%20find%20assembly%20'Microsoft.SqlServer.ConnectionInfo'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2612089%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20use%20a%20third-party%20app%20to%20create%20a%20new%20database%20in%20one%20of%20my%20SQL%20Server%20instances%20and%20receive%20an%20error%20stating%20that%20it%20can't%26nbsp%3Bfind%20assembly%20'Microsoft.SqlServer.ConnectionInfo'.%26nbsp%3B%20I%20can%20find%20directories%20named%26nbsp%3B'Microsoft.SqlServer.ConnectionInfo'%20in%20numerous%20places%20but%20the%20app%20can't%20seem%20to%20find%20it.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2%20SQL%20Server%20instances%20installed%20(one%20already%20there%20that%20came%20with%20the%20machine%20and%20Windows%2010%2C%20and%20the%20other%20installed%20with%20the%20community%20addition%20of%20SQL%20Server%202019).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESQL%20Server%20browser%20agent%2C%20SQL%20Server%20Agent%20and%20SQL%20Server%20processes%20all%20running.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHide%20instance%20property%20of%20instance%20is%20set%20to%20NO.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstalled%20components%20of%20SQL%20Server%20community%202019%3A%3CBR%20%2F%3E*%20Database%20Engine%20Services%3CBR%20%2F%3E*%20Client%20Tools%20Connectivity%3CBR%20%2F%3E*%20Client%20Tools%20Backwards%20Compatibility%3CBR%20%2F%3E*%20Client%20Tools%20SDK%3CBR%20%2F%3E*%20SQL%20Client%20Connectivitiy%20SDK%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstalled%20components%20of%20Visual%20Studio%20Community%202019%3A%3CBR%20%2F%3E*%20ASP.NET%20and%20web%20development%3CBR%20%2F%3E*%20.NET%20desktop%20development%3CBR%20%2F%3E*%20Desktop%20development%20with%20C%2B%2B%3CBR%20%2F%3E*%20Universal%20Windows%20Platform%20development%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanx!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2613670%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20connect%20via%20ODBC.%20Can't%20find%20assembly%20'Microsoft.SqlServer.ConnectionInfo'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2613670%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3Eit%20can't%26nbsp%3Bfind%20assembly%20'Microsoft.SqlServer.ConnectionInfo'.%26nbsp%3B%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120643%22%20target%3D%22_blank%22%3E%40John_Carter56%3C%2FA%3E%26nbsp%3B%2C%20that's%20a%20.NET%20assembly%20and%20has%20nothing%20to%20do%20with%20ODBC.%3C%2FP%3E%3CP%3EIt%20comes%20with%20SMO%20%3D%20Shared%20Management%20Objects%20and%20should%20be%20best%20installed%20in%20GAC.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELatest%20download%20I%20know%20is%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D56833%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%C2%AE%20SQL%20Server%C2%AE%202016%20Service%20Pack%202%20Feature%20Pack%3C%2FA%3E%20%3D%26gt%3B%26nbsp%3BENU%5Cx64%5CSharedManagementObjects.msi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2616727%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20connect%20via%20ODBC.%20Can't%20find%20assembly%20'Microsoft.SqlServer.ConnectionInfo'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616727%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F792867%22%20target%3D%22_blank%22%3E%40olafhelper%3C%2FA%3E%26nbsp%3BThanx%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20correct%20that%26nbsp%3B%3CSPAN%3EMicrosoft.SqlServer.ConnectionInfo%20has%20nothing%20to%20do%20with%20ODBC.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI'm%20pretty%20sure%20I've%20got%20the%20SMO%20installed%20as%20I%20find%26nbsp%3BMicrosoft.SqlServer.ConnectionInfo.dll%20in%20a%20number%20of%20directories%20including%20the%20following%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20*%20c%3A%5Cwindows%5Cassembly%5CGAC_MSIL%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20*%20c%3A%5Cwindows%20Microsoft.NET%5Cassembly%5CGAC_MSIL%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20*%20c%3A%5CProgram%20Files%20(x86)%5CMicrosoft%20SQL%20Server%5C110%5CSDK%5CAssemblies%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20guess%20the%20app%20I'm%20using%20can't%20find%20the%20assembly%20so%20what%20can%20I%20do%20to%20set%20the%20environment%20so%20that%20it%20can%20find%20that%20assembly%3F%26nbsp%3B%20Since%20it%20is%20a%20DLL%2C%20is%20it%20a%20PATH%20thing%20or%20something%20else%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm trying to use a third-party app to create a new database in one of my SQL Server instances and receive an error stating that it can't find assembly 'Microsoft.SqlServer.ConnectionInfo'.  I can find directories named 'Microsoft.SqlServer.ConnectionInfo' in numerous places but the app can't seem to find it.  Any ideas?

 

2 SQL Server instances installed (one already there that came with the machine and Windows 10, and the other installed with the community addition of SQL Server 2019).

 

SQL Server browser agent, SQL Server Agent and SQL Server processes all running.

 

Hide instance property of instance is set to NO.

 

Installed components of SQL Server community 2019:
* Database Engine Services
* Client Tools Connectivity
* Client Tools Backwards Compatibility
* Client Tools SDK
* SQL Client Connectivitiy SDK

 

Installed components of Visual Studio Community 2019:
* ASP.NET and web development
* .NET desktop development
* Desktop development with C++
* Universal Windows Platform development

 

Thanx!

4 Replies

it can't find assembly 'Microsoft.SqlServer.ConnectionInfo'. 

@John_Carter56 , that's a .NET assembly and has nothing to do with ODBC.

It comes with SMO = Shared Management Objects and should be best installed in GAC.

 

Latest download I know is Microsoft® SQL Server® 2016 Service Pack 2 Feature Pack => ENU\x64\SharedManagementObjects.msi

@olafhelper Thanx for your reply.

 

You are correct that Microsoft.SqlServer.ConnectionInfo has nothing to do with ODBC.

 

I'm pretty sure I've got the SMO installed as I find Microsoft.SqlServer.ConnectionInfo.dll in a number of directories including the following:

    * c:\windows\assembly\GAC_MSIL

    * c:\windows Microsoft.NET\assembly\GAC_MSIL

    * c:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies

 

I guess the app I'm using can't find the assembly so what can I do to set the environment so that it can find that assembly?  Since it is a DLL, is it a PATH thing or something else?

Best bet is to ask the support of the third-party app vendor, they should know how to fix.
best response confirmed by John_Carter56 (Occasional Contributor)
Solution

@olafhelper Thanx.  In my case, I had to download the correct version (in this case, SQL Server 2014 Feature Pack) of the Shared Management Objects (SharedManagementObjects.msi) and SQL system CLR types (SQLSysClrTypes.msi).