October 3, 2013 | Posted in: SQL Server

Run command prompt with the following:

cd C:\Program Files\Microsoft SQL Server\100\Tools\Binn

The syntax to then check two services on different servers is:

ssbdiagnose CONFIGURATION FROM SERVICE /text/initiator
-S InitiatorComputer -U InitiatorLogin -p !wEx23Dvb
-d InitiatorDatabase TO SERVICE /test/target -S TargetComputer
-U TargetLogin -p ER!49jiy -d TargetDatabase ON CONTRACT TestContract

Be the first to comment.

Leave a Reply

*


five × three =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>