I am looking to connect analysis services to an oracle database, and when I hit
Process in AS, it gives me a generic
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Oracle: ORA-12154: TNS:could not resolve the connect identifier specified.
Things I've tried:
- When I create the tables in VS2017, the connection works
- When I do a tnsping from the command line, that works
- I replaced all of the default tnsnames.ora files in ./app with the one that I know works (its what the TNS_ADMIN env variable is set to
I don't see where the location of the actual utilities used by the service are detailed, so I can't test it using those.
How can I make SSAS use the tnsnames.ora file that I need?