Solved

Data Analysis within Project Web Access

Posted on 2009-04-07
2
1,032 Views
Last Modified: 2013-11-15
Hello,

I'm getting stuck with this one, so any assistance would be very helpfull. The problem description is below.

When trying to access the cube on the project server through PWA, the users in the local offices get the following error message:

-Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser Service is running on the 'SERVERNAME server'
-Errors in the OLE DB provider. An error occured while name instance information was being retrieved from the SQL Browser service on the 'SERVERNAME' server.

When I test the necessary ports (TCP/UDP) for the application, all ports on the server are reachable from the all the local sites. The name of the server can be resolved to an IP address.

In the datacenter on a Terminal Server or on a client through VPN the cube is working perfectly.
A test through VPN and a local office has been done with the same test machine with the same settings.

I'm starting to think this is a network issue, but has anyone seen this before?

Thanks for your help in advance.

Kind regards,
Richard
0
Comment
Question by:Defio
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Author Comment

by:Defio
ID: 24098225
I have progressed a bit with this issue today. When selecting Data Analysis a NetBios broadcast is send to locate the domain controller of the domain to authenticate after contacting the SQL Browser service.
Since there is no domain controller on the LAN, the request times out and the error message comes up.

I have tried to get this to work with a LMHOSTS file, but that didn't succeed. The broadcasts dissapear, but it does not authenticate properly.

Any suggestion is more than welcome
0
 

Accepted Solution

by:
Defio earned 0 total points
ID: 24113967
I have changed the behavior of the Analysis server to work over HTTP.
Now a authentication request is send to the internet explorer and pops up in a box.

Configuration is found on http://blog.hametbenoit.info/default.aspx.

This solved the issue for me
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Best software for IT issue documentation 4 263
Scrum Master, example of role 1 220
Project Management 5 128
Time Tracking Software for Projects 2 68
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question