Business Scorecard 2005 Installed - Just cannot connect to Analysis Services database

Followed the readme for installation step by step.
Installed the Server and the Builder on the same machine - db is SQL Server 2005 April CTP.

- Will the Business Scorecard work with the April CTP?
- Launched the BS Builder and when trying to connect to a ADOMD.NET datasource, in server specified the <Servername>, the database dropdown always comes blank.....error "could not connect to data source"
(Analysis Services is running, The AS 2005 instance has 2 databases, one a result of my successfull cube deployment)

Checked the known issues with SQL 2005, could not find a soln...
A quick help would be great....

Regards

[661 byte] By [mat_net] at [2008-2-8]

«« Using Text
»» What are the minimum requirements for hosting the design surface?

# 1

Hello mat,

The problem must be with the cube permissions. In my case, and im using a test environment, my BSM application pool is with NETWORK SERVICE identity so I gave NETWORK SERVICE permissions to access the cube.

hope to have helped...

Fernando Mar?al.

FernandoMar?al at 2007-9-9 >

top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...

# 2

That was perfect Fernando.
It worked, thanks!

mat_net at 2007-9-9 >

# 3

Hello, I have the same problem but I don't know where to change permissions to "Network Service". Is there a specific checkbox to check in Role management of the cube ?
Thanks

Rmi at 2007-9-9 >

# 4

Hi Remi,

For the Analysis Service database, under Roles, add a new role and under Membership add - NT AUTHORITY\NETWORK SERVICE

Regards

mat_net at 2007-9-9 >

# 5

Hi mat,

I am having the same problem, BSM is not able to connect to SQL SERVER 2005 ODBC Data Source. i have tried with NT Authority\network Service, but SQL SErver denied me on adding the role.

Regards,
Gaurav.

GauravRehan at 2007-9-9 >

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech