1
General Board / Moving .eap to SQL Server running on Azure
« on: March 19, 2014, 03:33:28 am »
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.
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.