Data Analysis - error creating view - PWA 2007

[tsamo]

hello everyone....

It was brought to my attention that the Data Analysis page on my server is
not working properly.
When accessing from my workstation, I receive the message:
"The query could not be processed: Cannot connect to the server 'myserver'.
The server is either not started or too busy."

When accessing from my Project Server box, everything works perfectly.

*My workstation and PS box are in the same domain.

Any clues?

Thanks,
Theo

 

[Paul Conroy]

Have you installed the following on your workstation

MSXML6.0
ASOLEDB9.0
SQL Native Client

 

[tsamo]

There's a good chance that I did not.
I looked in add/remove programs, but didn't see anything. i have msxml
6parser and msxml 4.0 sp2.

Where can I find those?

Were they listed in the deployment guides?

 

[Paul Conroy]

http://www.microsoft.com/downloads/...94-8453-4998-8226-FA42EC403D17&displaylang=en

 

[tsamo]

ok. so, these need to be on my sql server box. let me confirm.

 

[tsamo]

Where should these files be installed?
MSXML6.0
ASOLEDB9.0
SQL Native Client

 

[Paul Conroy]

They need to be installed on each client machine.

 

[tsamo]

thank you. I'll give it a try and post back afterwards.