This is a fresh installation of Sage 100 ERP 2014 and Sage CRM 7.2 patch D. 

After entering the CRM Server Options parameters in SAGE 100, we receive this error:

I then stop the integration engine, and continue to rebuild the mirror tables, when completed it tells me to restart the integration engine which i do. When i select to load CRM data i receive this same message again that the mirror tables have to be rebuilt. I have gone through this process about 5 times with the same result each time. 

One note is our integration port ID is not the default but rather 8889 would that matter?

Our SQL database is not running off of SQL Express but rather MS SQL server 2008 R2, do i have to enter anything more in the SQL database name field other than CRM (our sql db name)?I bring this up because i know for SQL Express databases you do have to enter more than just the database name. 

There is no sample data in CRM however the company users are setup total 6. There is data within Sage 100. 

Also is there a guide or documentation that provides detailed instructions to complete the Sage 100 CRM integration options? 

Any help is greatly appreciated thank you very much.