Install this to enable NServiceBus to facilitate messaging over SQL Server
Before doing anything else, make sure you have SQL Server up and running in your environment. Also make sure it is accessible from all the machines in your setup.
-
Add NServiceBus.SqlServer to your project(s). The easiest way to do that is by installing the NServiceBus.SqlServer nuget package.
-
In your app.config make sure to provides the necessary connection information needed to communicate to SQL server. A typical setup would be:
<connectionStrings>
<add name="NServiceBus/Transport" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=nservicebus;Integrated Security=True"/>
</connectionStrings>
See https://github.com/Particular/NServiceBus.SqlServer.Samples