I am trying to bring external content into our SharePoint environment. We are launching SP 2010. The data I want to use exists in Sql Server. What I'm trying to do is map the registered SharePoint user to the basic sql user.
In SharePoint, I created a new target application in the Secure Store Serivce :
Target Application ID : TestApp
Target Application Type : Group
I have specified two fields:
Name :: Type
Username :: Username
Password :: Password
is not a Windows username and Windows password, but only the main types
Target Application Administrators and Members are both installed as me (AD user).
In SharePoint Designer, I created a new type of external content . I added a connection ( Type -> Sql Server). I set the database server name to the server name not in the same field as SharePoint , and I set the database name. I selected the Connect with personalized personalized authentication option and set the Secure Store app ID to TestApp. When I click OK, I get a credential request, so I enter the Sql Server user credentials and the connection is successful. I am expanding the tables, right click on the table I want and click Create All Operations. I go through the master and enter one limit filter.
MyTable , . TestApp.
, SharePoint, TOC. , - . , , , , , :
'0 #.w | domain\myuser, ' domain\myuser '. Instance " " ACL,
:
-: Microsoft.SharePoint.SPException: -. --- > '0 #.w | domain\myuser', 'domain\myuser'. Instance " " .
, pass through creds, , , kerbos sql-.
!!!!