I'm trying to develop a list backed by a SQL Server database running on AWS in Sharepoint 2010 (also running on AWS), but I'm running into issues regarding authentication to the database. The only way I've found out how to create a list backed by a database is to use External Content Types, but when connecting to a data source, I have to use one of the three authentication methods:
- Windows credentials
- Impersonated Windows credentials
- Pass through credentials
#1 is not supported on AWS for RDS, and #2 and #3 require access to the Central Admin tool in order to create a Secure Application Store ID, which I do not have because it's managed by the corporate IT team (assume right now that I won't be able to have them add a key, although I'm still investigating this possibility).
I can create a database connection by adding a new data source, but this doesn't show up when I browse for data sources when creating an External Content Type. This DB connection allows me to use standard SQL Server authentication by specifying the username + password. Is there any way I can use this DB connection to create a DB backed list?