Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 427
  • Last Modified:

Web Interface fails to connect to Analysis Services

I'm trying this on a workstation running XP Pro SP2.  IIS 5.1 is on it and working.  Analysis Services patched to SP3a is on it and working.  I am attempting to create a cube through a web interface.  We use a DSO interface to talk to Analysis Services on the web service.  Whenever I do this I get an error message:

Error creating database 'foo' on server 'DRUBIN01': System.Runtime.InteropServices.COMException (0x80040075): Cannot connect to the Analysis server on computer 'DRUBIN01'. Connection to the server is lost at CubeMgt.SchemaDatabase.checkConnectivity(COMException ce)

This process works fine on another workstation running Windows 2000 SP4 in the office and I've seen it work fine on another XP Sp2 workstation.
0
RaptIT
Asked:
RaptIT
  • 2
1 Solution
 
adwisemanCommented:
Is the Web User used to connect to the olap database in the Olap Administrator Role on the XP Machine?
0
 
RaptITAuthor Commented:
The user account was a local administrator.  I reset it to be an olap admin and the problem still occurs.
0
 
RaptITAuthor Commented:
thanks for all help, apparently the asp user account needs to be a member of the OLAP admin group and have full control of the Analysis Services folder under program files...

problem solved, and adwiseman's thoughts pointed us in the right direction.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now