I had it failed with similar error :

Msg 245, level 16, Sate 1, Line 127

Conversion failed when converting the nvarchar value '<Primary_Server>\<Instancename>' data type bit.

The issue was with inserting a...