You’re offline. This is a read only version of the page.
10
Hi Everyone,
I was wondering if anyone on here may be able to assist me in solving a problem I have.
We already have a fully working CRM 4 system which is great. On our CRM system we have some custom data which holds information regarding license data and subscription details for one of our software solutions that we offer.
As it stands this information is also currently stored in the database that our software uses on a separate instance of SQL server 2005. In the interests of data integrity we would like there to only be one definitive source for this data. The source that we have chosen is CRM. Due to the way that our software works the subscription details have to be referenced during its use. As such we will have to link the two SQL servers together so our software can read directly from the CRM SQL server.
I have read that it is possible to access the CRM data by adding the CRM SQL server as a linked server to our software SQL server. However I have been unsuccessful in getting this to work. The reason being is that the CRM SQL server uses windows authentication whereas our software SQL server uses SQL authentication.
I have tried linking our SQL server login on the software server to a read only user on the CRM system but I can’t get it to work
Does anyone know how to get round this linking issue at all or know of another solution to the problem?
I have heard of a software package called “Scribe” but I am unsure if it will do what we require of it. Has anyone else go any experience with this software in a similar situation to mine?
Many thanks,
Andy
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
