Data Analysis and Views

[darrellctaylor]

I have successfully built my cubes, but I do not have any views. I went into Manage Views and attempted to define a Data Analysis view and I am getting a returned message "Failed to connect to the Analysis Services server." I am using the dafault server where I built the cubes. Any ideas?

Thanks!

[agriffin]

Does that error refer to Analysis Services on SQL Server?

[darrellctaylor]

Originally Posted by agriffin

Does that error refer to Analysis Services on SQL Server?

Yes, it does refer to Analysis Services on SQL Server. I have completed the steps based on KB927159, but it does not resolve the issue.

[ssanderlin]

Originally Posted by darrellctaylor

Yes, it does refer to Analysis Services on SQL Server. I have completed the steps based on KB927159, but it does not resolve the issue.

How do you have AS configured (e.g. MDB, MDF, are you using an HTTP pump)?

As for the client... you installed ASOLEDB9 and enabled Access data sources across domains... only other thing I can think of off the top of my head is did you add the server to the Trusted Sites zone?

[darrellctaylor]

Originally Posted by ssanderlin

How do you have AS configured (e.g. MDB, MDF, are you using an HTTP pump)?

As for the client... you installed ASOLEDB9 and enabled Access data sources across domains... only other thing I can think of off the top of my head is did you add the server to the Trusted Sites zone?

The site is in the Trusted Sites and the security is set to allow data access across domains. We are using an HTTP pump.

I am ocntinuing to troubleshoot, but it seems to be an issue working through a VPN.

[ssanderlin]

Originally Posted by darrellctaylor

The site is in the Trusted Sites and the security is set to allow data access across domains. We are using an HTTP pump.

I am ocntinuing to troubleshoot, but it seems to be an issue working through a VPN.

It could be an issue with the VPN...

Let me ask you: how do you have the security for the HTTP pump set up? Anonymous? Basic? IWA? Digest? What is your AD (client and server) topology like? Are you using Kerberos?

The reason I ask is that you could be hitting a double-hop issue.... I had a client that did not have their desktops joined to a domain, but the EPM deployment was. In order to get the HTTP Pump to work around the double-hop issue (kerberos was out of the question), I had to set up the pump to allow Anonymous Access running in the context of a specific service account that had access to the cube.

[darrellctaylor]

Originally Posted by ssanderlin

It could be an issue with the VPN...

Let me ask you: how do you have the security for the HTTP pump set up? Anonymous? Basic? IWA? Digest? What is your AD (client and server) topology like? Are you using Kerberos?

The reason I ask is that you could be hitting a double-hop issue.... I had a client that did not have their desktops joined to a domain, but the EPM deployment was. In order to get the HTTP Pump to work around the double-hop issue (kerberos was out of the question), I had to set up the pump to allow Anonymous Access running in the context of a specific service account that had access to the cube.

I was able to resolve the issue today and it was a domain issue. The client was on a domain and since I was not authenticating on their domain, I had to remote into their machine. I could not access the data through PWA even though I was on their VPN. Once I got into their server via remote, I was able to access the Data Analysis Server.

[ssanderlin]

Originally Posted by darrellctaylor

I was able to resolve the issue today and it was a domain issue. The client was on a domain and since I was not authenticating on their domain, I had to remote into their machine. I could not access the data through PWA even though I was on their VPN. Once I got into their server via remote, I was able to access the Data Analysis Server.

Excellent. I have the same issue at every client I'm at... The only place I didn't was where they had an HTTP Pump set up to run as a service account.