Microsoft.SqlServer.Management.SqlParser install in clickonce c#

Question

I want to make a click once via ftp, after deploying the project and excute I have Microsoft.SqlServer.Management.SqlParser V 10.0 needed .

I have installed 1033\x64\SharedManagementObjects.msi Version 10.50.2500.0  but I can't found this file in the sdk directory ! and the other thing that I don't use this dll in my sollution !

how to resolve this

thx

Answer 1

Hello,

The SqlParser.DLL isn't part of SMO and not part of any other redistributable or SDK.

You will find the DLL in folder
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.SqlParser.dll
because it belongs to SSMS.

If you want to deploy it take care about licencing and copyright!

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hello,

The SqlParser.DLL isn't part of SMO and not part of any other redistributable or SDK.

You will find the DLL in folder
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.SqlParser.dll
because it belongs to SSMS.

in directory C:\Program Files (x86)\Microsoft SQL Server\100\ I don't have the tools

Answer 3

Then have a look at the same program folder for 64 bit without x86):

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.SqlParser.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
Blog Xing

Answer 4

Then have a look at the same program folder for 64 bit without x86):

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.SqlParser.dll

No I haven't this directory

Answer 5

Then I guess you don't have installed SSMS 2008 R2 at all?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 6

Then I guess you don't have installed SSMS 2008 R2 at all?

yes I don't have to install SSMS in all pc; it just installed in server

Answer 7

Hi Insane,

As Olaf mentioned, you need install SSMS 2008 R2, or you will have no SqlParser.DLL to continue.

If you are using Express edition, you can download the express edition SSMS from http://www.microsoft.com/en-us/download/details.aspx?id=22985

If you have other SQL Server edition installed, please run your setup file and add the management tools.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.