cancel
Showing results for 
Search instead for 
Did you mean: 

BI4 - Problem creating multi-source data foundation

Former Member
0 Kudos

Hi experts,

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,

Thank you

.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Simone

Did you find any solution for this