Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Our system needs to synchronize data with external systems by web services. We want additional database to keep needed data and then be able to access it. I wonder how to resolve issue with database owner and security.

Should I create another AD account for new db and make it owner and use it to access data? Maybe there is possibility to use some of the sharepoint service accounts? If it's possible, is it safe to do?

share|improve this question
    
It looks like you need to use bcs –  IAfanasov Jan 20 '12 at 14:19
    
I don't need this data to be exposed as lists. –  jjczopek Jan 20 '12 at 14:23
1  
How is the data being synchronized? What are you doing with the data, do you want to see it in SharePoint? –  David Lozzi Jan 20 '12 at 14:28
    
External system (integration bus) calls webservice on my side and I process the data. This data will be mostly used for some relations (parent-children) and site creation from time to time. –  jjczopek Jan 20 '12 at 14:35

1 Answer 1

up vote 1 down vote accepted

Usually it is suggested to use dedicated accounts for each application.

There are pros amd cons in that of course, having dedicated accounts provides more security but adds a bit of maintenance.

You should take a look at Secure Store, it might be exactly what you want - if you don't want to create new AD account.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.