MS SQL Server ODBC - Connecting scorecards to databases local, extenal, olap or not

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Connecting scorecards to databases local, extenal, olap or not

GerardD

2006-10-31, 12:16 am

Hello,

I went through the web to find some help to have a rigorous way to
connect Scorecards builder with different sql datasources on my network
in a domain.
I can connect with odbc to local relational databases, i can connect to
an external olap sql 2000 database.

I cannot connect to AdeventureWorksUW locally: I can see the olap bases
but not the cubes. In fact the ADOMD.Net connection does not succeed.

I cannot connect on an external relational database externally.

I use the default network service xhich needs the rights to access the
datas. But I fail to give exactly the necessary rights certainly.

Who can provide me with the details to give in sql2005 or sql200 the
way to connect my scorecard builer?

thanks

Gerard

Sponsored Links