Our organization is going to be using Office 365 - D (BPOS-D) as our SharePoint environment. I'm told we can't use secure store in this environment. So how do we use SharePoint to connect to an external SQL database without that?
- Using SharePoint Designer I can create an external content type and view all the tables in the database. I select the table I want to use in an external list.
- Then I create an external list with the external content type
- When I attempt to view the site though, I get a "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
I believe all the correct accounts are created, but for the connection settings I believe I have tried all the authentication methods presented in the dropdown. I would like it to connect user the current user logged into the site viewing the data, but I don't see how that is possible without secure store.