External Content Types - Reload - Setting up for SQL Server database using SQL Server authentication - SharePoint 2010 Server
In the previous post I wrote how to properly set up an External Content Type for SQL Server in SharePoint 2010 Foundation.
Reality is that even in Server edition we have Secure Store Service which was an issue in Foundation edition - we need to do some tricks before we can use created ECT in SharePoint 2010 Server.
Alright girls and boys, let's move on.
1. After you have created an ECT in SharePoint Designer check the name of Secure Store Application:
2. Go to Secure Store Service settings in Central Administration:
3. Select New command from the ribbon to create new Secure Store Target Application:
4. Type the name - in my case it is SecureStoreWyldeCRM - and other related parameters and click Next:
5. Add two credential fields - User name and Password. One of type User Name and another of type Password and hit Next:
6. Set administrators for the application and click Next:
7. Now when you see newly created Target Application hit Set command on the ribbon to set credentials for this application so it could connect to the database:
8. Specify database user name and password and hit OK:
9. Enjoy working with the ECT that can connect to your SQL Server database through SharePoint!
If you have any questions in regard to External Content Types, you need assistance or if you think you don't know how you could benefit from using External Content Types for your business - contact us now for a consultation.
Stay tuned for more articles from Wylde Solutions.
Reality is that even in Server edition we have Secure Store Service which was an issue in Foundation edition - we need to do some tricks before we can use created ECT in SharePoint 2010 Server.
Alright girls and boys, let's move on.
1. After you have created an ECT in SharePoint Designer check the name of Secure Store Application:
2. Go to Secure Store Service settings in Central Administration:
3. Select New command from the ribbon to create new Secure Store Target Application:
4. Type the name - in my case it is SecureStoreWyldeCRM - and other related parameters and click Next:
5. Add two credential fields - User name and Password. One of type User Name and another of type Password and hit Next:
6. Set administrators for the application and click Next:
7. Now when you see newly created Target Application hit Set command on the ribbon to set credentials for this application so it could connect to the database:
8. Specify database user name and password and hit OK:
9. Enjoy working with the ECT that can connect to your SQL Server database through SharePoint!
If you have any questions in regard to External Content Types, you need assistance or if you think you don't know how you could benefit from using External Content Types for your business - contact us now for a consultation.
Stay tuned for more articles from Wylde Solutions.
Thank you for putting an effort to published this article. You've done a great job! Good bless!
ReplyDeleteCaren
www.gofastek.com
If you are not willing to learn, No one can help you. If you are determined to learn, No one can stop you.
ReplyDeleteimarksweb.net