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?
View Complete Post