Using Database table as Sharepoint data source with windows authentication

Question

Using Sharepoint Designer 2013, I'd like to add a data source that connects to a SQL server database. Then, I plan to use a data view web part to edit data in the table.

The problem I have is Sharepoint designer requires that I enter a username and password when i create the data source. I want each user to authenticate against the database using their Windows credentials so i can audit changes. All our database permissions are granted via Windows groups.

Is there a way to connect Sharepoint to a database using the current user's Windows credentials?

Yevgeniy.Chernobrivets · Accepted Answer · 2013-11-18 18:31:11Z

2

If you need to update data in external source the best approach in my opinion is to use Business Connectivity Services. You can read more about it here.

answered Nov 18, 2013 at 18:31

Yevgeniy.Chernobrivets

3,1942 gold badges15 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Database table as Sharepoint data source with windows authentication

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related