Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider'

Question

Hi,

I have developed a windows forms application to take a database backup programmatically.....In this application user provides server name and database name to take the backup...Here SERVER is REMOTE MACHINE....

I have added references of following dll's

Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SmoExtended.dll
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll

This application works fine on my machine but when i run it on another machine which do not have SQL Server installed on it i get following exception

---------------------------
Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
---------------------------

2nd Query

If i include dlls with my application will there be any licensing issue or if it is freely distributable?? 

---

Naren

Answer 1

I think this may solve your needs

http://www.microsoft.com/en-us/download/details.aspx?id=30440

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 2

thanks,

will there be any licensing issue or if it is freely distributable?? 

---

Naren

Answer 3

As far as I know, they're freely redistributable.

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu