Setup Xtraction Unable to create/update database tables
Article ID: 111411
Updated On:
Products
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
KNOWLEDGE TOOLS
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
Issue/Introduction
Install of Xtraction failed
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
>>
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
>>
Environment
Release:
Component: XTR4SM
Component: XTR4SM
Resolution
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
-> 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
db_datareader to the mdb
and
db_datareader + db_datawriter to the Xtraction database
Feedback
Yes
No
Powered by
