View Complete Post
I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer. Later I changed some column names in the table.
I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the
Business Data Connectivity Metadata Store and it refers to a different data source. Cannot complete operation generation. Add a connection to this data source with a different name and try again."
I re-created the Secure Store using a different name in SharePoint 2010 Central Administration. I didn't find the option to choose the connection name in SharePoint 2010
Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.
Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.
I have seen numerous articles for the above, but they all just gloss over the step I am having a problem with, assuming nobody will have an issue with it.
I'm trying to create an External Content Type so I can use it to display external data (from SQL Server) in an External List. When I get to the step to add the connection and the SQL Server connection dialog box appears, I enter the server and database
names and click OK with the Connect with User's Identity radio button still selected and I get the error message:
login failed for user ''. The user is not associated with a trusted SQL Server connection. I've tried to read up on the different purposes of the radio buttons on offer on this dialog box but don't know which I should really be using and don't think
I can create a target application ID anyway in Foundation (for the other two radio button options) as that has to be done in the secure store services. Can anybody help with this?