Data analysis problem

J

jams

creating and viewing data analysis are working fine on servers in hyperv.
but, it is not working remotely when tried to access from client machine.

I have two seperated WFE and one SQL server with multiple named instances.
SQL server is installed by one service account, not local service.
I have installed all required components and configured right on SQLserver
for analysis service and browser setting is set also.

why is not working only on client machine within the same network using one
DC?
Even I can't create a view from client machine.

I see error message on Data Analysis page(owcview.aspx):
the query cound not be processed:
Errors in the OLE DB provider. Could not connect to the redirector. Ensure
that the SQLBrowser service is running on the 'SRVHCN212' server.
Errors in the OLE DB provider. An error occured while named instance
information was being retrieved from the SQLBrowser service on the
'SRVHCN212' server.
 
G

Gary L. Chefetz

Jams:

The following may or may not apply to your case, but see if it moves things
forward for you:

http://www.projectserverexperts.com...processed displays on Data Analysis page.aspx

Let us know how you progress and we'll come up with some other suggestions.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
 
J

james

I already did that browser setting.
what is the real problem here?
why is not working remotely?
I haven't experienced this since I deployed project server many times.
Please help me out.
 
G

Gary L. Chefetz

James:

Can you confirm that you're saying that this happens only on one client
machine, that the client machine is a member of the same domain as other
working machines, and that this happens for every logon you try on the
machine? If so, it points to something specific to that machine, and the
possible causes are numerous. Are MDAC components up to date? Does the
machine have browser addins or other software that could be causing
inerference? Are there unique scanning tools installed on this machine? Are
the Office Web Components installed correctly? Have you installed updates to
your system?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
 
C

Cnegroni

Hi, I have almost the same problem. One of our clients has Project Server
(application and pwa) on one machine and a DB server with SQL2005 and AS. I
can access cube views from the DB Server but if i try to do that from another
machine (PWA server or client machine) I got the error "An error occurred
while named instance information was being retrieved from the SQLBrowser
service on the 'abclscl093' server". What can I do?

Regards

Carlos Negroni
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top