Moving .eap to SQL Server running on Azure

[Marc]

I'm trying to move an .eap to a SQLServer database running on Azure, but get a Invalid Datasource, Check Configuration Message, followed by a "You must supply a connection name" message.

Here's what I did:
- Created an ODBC Datasource to SQLServer running on Azure
- Used the SQLServer_EASchema.sql to create the EA repo in the database. Script completed without errors.
- Started EA and Connect to server.
- Used the Connection String option to select my DSN
- Provided user credential and initial catalog
- Tested connection. Everything went OK.

Then clicked finish and ran into the error message box mentioned above.

Anything I'm missing here? I'm puzzled by the "You must supply a connection name" message as I seem to have filled out all the required information.

Marc

BTW. I used the same DSN to connect to that server with Excel and could access all the EA repo tables, so the connection itself seems to be working OK.