none
Microsoft.SqlServer.Management.SqlParser.dll is not in SharedManagementObjects.msi for SQL Server 2008 R2

    Question

  • We are looking for Microsoft.SqlServer.Management.SqlParser.dll for redistribution with our application which uses it for T-SQL parsing. It appears that this DLL is not available in SharedManagementObjects.msi for SQL Server 2008 R2.

    Does anyone know where is the best place to get this DLL in a redistributable form? All the posts seem to say SMO but when installing SMO on a clean machine (or looking inside the MSI) that DLL doesn't exist.

    Monday, February 14, 2011 11:42 AM

All replies

  • Hello Vito,

    see thread "Microsoft.SqlServer.Management.SqlParser.dll wanted"


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Monday, February 14, 2011 12:05 PM
    Moderator
  • Thanks Olaf! I did read that post but I am looking for a re-distributable version of the DLL which I can ship externally with my software.
    Monday, February 14, 2011 12:11 PM
  • Hello Vito,

    As you can look up in "SQL Server Management Objects (SMO) Class Library" => ...SqlParser, the DLL is (should be) part of SMO.

    Have You checked folder "C:\WINDOWS\assembly\" if you can find the entry "Microsoft.SqlServer.Management.SqlParser" there (withour extension .DLL)?


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Monday, February 14, 2011 12:41 PM
    Moderator
  • Hi Vito,

    I downloaded ShareManagementObjects.msi, extracted and found out that there is no Microsoft.SqlServer.Management.SqlParser.dll in the setup file. As a workaround, you can get that DLL as below:

    1. Make sure you have SQL Server 2008 R2 Management Studio installed; If not, please install it first;
    2. Go to GAC_MSIL folder, to do that please;
      1. Click Start -> Run...
      2. In the Run dialog, input C:\windows\assembly\gac_msil
    3. In the C:\windows\assembly\gac_msil folder, you should be able to find Microsoft.SqlServer.Management.SqlParser folder;
    4. Open C:\windows\assembly\gac_msil\Microsoft.SqlServer.Management.SqlParser folder, open 10.0.0.0__89845dcd8080cc91 folder (maybe different from yours) and then you should be able to see Microsoft.SqlServer.Management.SqlParser.dll.
    5. Copy the DLL, please check version is at SQL Server 2008 R2 level (10.50.1600.1 for RTM)

    Hope this helps.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, February 15, 2011 11:12 AM
    Moderator
  • Thanks Chunsong,

     

    I need a version which is licensed to be redistributed. Do you know if that is the case?

    Thursday, March 03, 2011 12:43 AM
  • Hi Vito,

    Thanks for your update. I think you may confirm with Microsoft licensing specialist directly. You can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. You can also visit the following site for more information and support on licensing issues: http://www.microsoft.com/licensing/mplahome.mspx.

    Hope this helps.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, March 03, 2011 1:25 AM
    Moderator
  • I have the same problem after updating to R2. SqlParse.dll is in the (x86) but not (x64) program directory. In my solution I have this dll (public key token 89845DCD8080CC91) in my references and the application directory of the file system. Yet, VS2008 whines two warnings:

    Warning 1 Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='10.0.0.0') of assembly 'Microsoft.SqlServer.Smo.dll' C:\Users\Ralph\Documents\Visual Studio 2008\Projects\ChainPro III\ChainProSetup\ChainProSetup.vdproj ChainProSetup
            and

    Warning 2 Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='10.0.0.0') of assembly 'Microsoft.SqlServer.Management.SmoMetadataProvider.dll' C:\Users\Ralph\Documents\Visual Studio 2008\Projects\ChainPro III\ChainProSetup\ChainProSetup.vdproj ChainProSetup

    and, yes, Microsoft.SqlServer.Smo.dll is present as well.

    Saturday, May 28, 2011 8:42 PM