Scribe problem installing CRM 5.5 adapter

A few hoops must be jumped through to get the new CRM adapters to install.

First of all if you try to download and run the CRM 5.5 adapter you might receive an error about Windows Identity Foundation.  The workaround here is not to run the MSP directly but copy it into your Scribe Adapter folder where the Scribe installation package is unzipped.  Then run the Scribe Setup installer and install from there.

The next problem you may encounter is an error during the installation of the adapter.  A window may pop up behind the installation progress window that shows the following:

"RnScript Database Error - Error Number: 126 - Description: error executing SQL command ending on line #19."

If you click Next you may see

"Error Number: 65408 - Description: [23000] Violation of PRIMARY KEY constraint 'PK__BRIDGES__409E411B164452B1'.  Cannot insert duplicate key in object 'SCRIBE.BRIDGES'.  The duplicate key value is (DEFAULT, Microsoft Dynamics CRM Publisher, *). The statement has been terminated."

I believe I was using an earlier adapter previous to 5.5 on Insight 7.62.  the problem was the value indicated in the "duplicate key value" parens is already in the Scribe.Bridges table.  In SQL delete that record and restart the install and it should complete just fine.

For the record to reinstall an adapter I remove the adapter from Control Panel > Programs and Features first then start the install again.  That is the cleanest way.