Setup Xtraction Unable to create/update database tables

Document ID : KB000111411
Last Modified Date : 16/08/2018
Show Technical Document Details
Introduction:
Install of Xtraction failed

 
Question:
Install of Xtraction

On the "Xtraction setup" window, you will see this popup message

<<
unable to create update database table
format of the initialization string does not conform to specification starting at index 147
>>
 
Answer:
This error message from Xtraction is about the write permission.

-> In sql studio management, open the properties of the Xtraction database owner.

Right click on property of the Xtraction owner, "user mapping", in list of "database role membership for master:" check on
db_datareader and dbdatawriter

 
Additional Information:
Recommendation for Xtration user

db_datareader to the mdb
and 
db_datareader + db_datawriter to the Xtraction database