I'm working on BI4 sp4, directly on the server using remote desktop connection.
I have to connect to a MS SQL Server 2008 64bit via ODBC.
I've followed these steps:
1. defined ODBCs (both 32 and 64 bit, with the same name and specifications)
2. defined connection on the repository and tested it successfully
3. defined shortcut to that connection in local project and tested it successfully
4. tried to use this connection in a multi source enabled data foundation
At this point I get following error: "Could not register connection The deployment cannot be executed because some mandatory properties of the configuration are not set.". The connection then appears in the Connections panel with the label "Unregistered Connection".
However if I try to use the same connection in a single source data foundation everything works fine.
Another strange thing is that if I open original connection, Edit button is grayed out and I cannot modify it anymore.
I've tried also OLE DB connection with the same result.
Every help would be greatly appreciated,