• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Technology
    • Development
    • Hardware
    • Intune
    • Microsoft
    • Office
    • Office 365
    • Security
    • SharePoint
    • Software
    • SQL server
  • Personal development
    • Blog
    • Career
    • Freelancer
    • Knowledge
    • NEWS
    • Private
    • Thoughts
  • Consulting services
  • Contact me

Not only IT

About life, IT and other things...

Home » Technology » SharePoint » How to use SharePoint 2010 BCS with secure store

How to use SharePoint 2010 BCS with secure store

March 17, 2011 By Tomasz Szulczewski 2 Comments

When I was looking for complete step by step manual for usage of BCS and Secure Store I’ve discovered a lack of such thing. From my point of view BCS, which a great step forward according to MOSS 2007 BDC, is excellent solution together with Secure Store, which is replacement of SSO. Another advantage is that BCS exits in free version of SharePoint, which is huge step forward from Microsoft, as to use BDC we needed SharePoint Enterprise. Let me show you how to use BCS and Secure Store to grant possibility of database edition to users. So how to this?

First we need SQL server login and password. I’ve mapped this login only to one database and grant only read and write role

imageimage

Now we have to configure our Secure Store Application to use this information. Let’s go SharePoint Secure Store and start creation of new application

imageAs you can as target Application I use “Group”, as I would like to map specific windows group to this application

image

I the next step I create two field: one for sql user and one for user password. Almost there…

imageIn last step we have decide who will be mapped to SQL credentials. As you can see I used All authenticated user as, but usual this should more restricted. Now I just need to enter real security information for my application. Select “Set credentials” from drop down application menu

image

You will get screen like below. Enter your SQL server user and password.

imageYou configured your secure application. Congratulation! How to use it with Business Connectivity Services? I will show you in next my blog post. See you soon.

Related

Filed Under: SharePoint Tagged With: SharePoint

About Tomasz Szulczewski

I've got more than 20 years of IT experience. IT is my passion and I am still increasing my skills. I work as a SharePoint, Office 365 and Azure architect.

Reader Interactions

Trackbacks

  1. How to use SharePoint 2010 BCS « About life, IT, and other things… says:
    March 28, 2011 at 12:29 pm

    […] previous post I’ve presented how to configure SharePoint secure store. Now it’s time to use it with BCS, […]

    Reply
  2. How to use SharePoint 2010 BCS says:
    June 24, 2014 at 9:13 am

    […] previous post I’ve presented how to configure SharePoint secure store. Now it’s time to use it with BCS, […]

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the Newsletter

Social media

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Search this site

Sign up for Wise accounts

Signup and earn $25

payoneer
payoneer

My latest achievement

Microsoft 365 Certified: Enterprise Administrator Expert
Microsoft 365 Certified: Enterprise Administrator Expert

Tags

Azure Azure Active Directory BizSpark Blog career Certification cloud conference edge freelance Freelancer Hardware home office InfoPath Intune Knowledge licensing Microsoft Microsoft 365 News Office Office 365 Personal development Power virtual agent Private security SharePoint SharePoint designer SharePoint online Software SQL server upwork Windows Windows 365 yammer

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2022 Tomasz Szulczewski