Building a Parent Teacher Interview System using ECT – PART 4 – SECURE STORE

The following blog shows you how to set up the secure store for your Parent Teacher Information System.

Before I get started, Fabian Williams again has the best blog on this topic, so if you need to fill in the gaps with this blog, see Fabian’s blog.

Steps to do.

  1. Create the secure store to overcome the double hop authentication issue.

The secure store essentially sets up access to the SQL database. We need to assign the Service Account as the users. We set up this Service account on the SQL server. Refer to previous blog. We also need to assign permissions on who can administer the Secure Store.

  • Go to sharepoint central admin
  • Application Management -> Manage Service Applications -> Secure Store Services ->Click New ->Generate new key if prompted.

NB>>When you set permission and credentials for the Secure Store ensure that you use the domainname\username. I have become unstuck with this problem previously.

 You are now ready to set up the External Content Types for the Parent Teacher Interview System.

About whellmuth

Working with the education software industry to build software with standard arhitectures that allows schools to have extensible and well integrated technologies. Member of Software QLD. Member of Microsoft advisory board on cloud computing. My doctorate specialises in Software Architecture in the Education environment. My Master Research specialised in IT change management.
This entry was posted in Microsoft SharePoint. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s