Hello,
I'm making a report solution using a report model.
So, I have to create a connection, a data source view and the report model itself.
Now, when I'm creating the DSV, I first have to select a connection that I created in the first step.
The weird thing is that when I select a connection and press 'next', the wizard tells me that no foreign keys could be found.
That is very strange because the database is full of primary and foreign keys!
If you then continue on there are indeed no relations added to the view.
I already fixed that problem by creating a second connection and setting it to use windows authentication.
When I use that connection there is no problem at all.
So for now I fixed it, but someday in the future I might not be able to use windows authentication.
Does anybody know the source for this problem?
Does a SQL Server account need certain rights to locate foreign keys or something?
Thanks for any help
Stefan