Linked Server - Unable to begin a distributed transaction

spider1269

I've been trying to set up a linked table in NAV2015 and I'm receiving an error when I try to modify the data. We are currently using NAV 5.0 with linked servers and it's working perfectly. When I try to modify a field in the linked table in NAV2015 I'm getting the following error:

The following SQL error was unexpected. The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SERVTST" was unable to begin a distributed transaction.

I found a mibuso entry where someone had a similar issue and the possible answer was to include a Collation Constraint on the VIEW. I've tried that but I'm still getting the same error. The NAV database and the linked server database are different collations. Should I continue looking at the collation issue or has someone found this is another issue entirely. I'm assuming other people have run into this that have upgraded.

Thanks.

ppavuk

Did you ever resolved this? Having similar issue now...

spider1269

We ended up not using linked servers/tables. We went to SSIS packages populating a staging table and updating that versus trying to update an external SQL table.