Data Analysis Connection failing

T

Trisha

When I click on 'Data Analysis' in PWA I receive the folloiwng message:

The query could not be processed:
The following system error occurred: No connection could be made because
the target machine actively refused it.

Does anyone know what may be causing this? Others are able to connect
without any issues.

Thanks!
 
G

Gary L. Chefetz

Trisha:

It sounds like your system may be passing the wrong credentials. Did you
update your password recently? If so, the incorrect password may be cached.
Can you logon to another system using your credentials and access the cube
successfully? If so, this would indicate that the problem is
machine-specific.

--
----------
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
 
T

Trisha

It does appear to be machine specific but I have not changed my password in
quit some time.

I did clear the IE cache and in Control Panel --> User Accounts --->
Advanced there were no stored passwords.

Do you have an idea of where else I may need to clear a cached password that
PWA might be looking @?

Thanks!
 
R

Reza

hmm....almost same like me...
i can open my data analysis in server, but if i open my data analysis in
local computer, there were error " The query could not be processed: The
following system error occured: No such host in known:"

i think my problem is i can't connect to Analysis Services server from
local, cause when i want to create analysis view in manage view, Analysis
Service Setting section -- Analysis Services Database to be created and then
i click to refresh database list there were message box "failed to connect to
the analysis services server. Verify the server name and try again".
i already install SQLServer2005_ASOLEDB9 and enable accors domain from
custom level IE.
when i created from server was successfully and can view data analysis.
but problem if i open in local computer, " The query could not be processed:
The following system error occured: No such host in known".

is something wrong with my setting or my machine maybe....

thanks
 
G

Gary L. Chefetz

Trisha:

Under Control Panel > Manage Users, check the Advanced tab and select the
Manage Passwords feature as check for stored passwords there. If you find
one for your projectserver URL, delete it. Otherwise, you can try to
recreate your profile on the machine by renaming the current profile adding
..bak extension and then logon to the machine with your normal credentials to
recreate it. If this works, you can migrate your profile items to the new
profile and go happily forward from there. Sometimes corruption occurs in
profiles, and causes this behavior.

--
----------
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
 
T

Trisha

Gary -

I did check the 'stored passwords' and it is empty. I have contacted
Microsoft and at this point it looks to be a permissions issue with my domain
user account.
 
G

Gary L. Chefetz

Trisha:

Has this ever worked for you? Are you an administrator in the system? In
order to use OLAP as a client, your account must be added to the Project
Server View OLAP Data Role, through SQL Management Studio in Analysis
Services. I assumed that this was a sudden problem for you, but I realize
from reading your posts that I never asked whether it ever worked for you.
I'm also assuming that you're using 2007 with these instructions.

--
----------
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
 
T

Trisha

It has never worked for me. We just got off the phone with MS suport and
we reviewed the users in SQL Manager and I'm pretty sure I was a member of
this group. I will have the DBA double-check.

At this point we are comparing group membership for a user that is working
to mine to see if we can narrow down where his permissions are being granted.


I will keep you posted.
 
R

Reza

Yes...i already do that...
btw in this article http://technet.microsoft.com/en-us/library/cc197552.aspx
i choose Create the repository by using a SQL Server 2000 Microsoft Jet
database.
when i try in server, its successfully work....and problem when i tried in
local computer, its failed to work...
should i try with Create the repository in a SQL Server 2005 database

thanks
 

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

Similar Threads

PWA Data Analysis Errors 1
Problem accessing Data Analysis views in Project Server 1
can't connect to Analysis Services (PS2007) 3
Data Analysis Not connecting 6
Data Analysis Problem 10
Error in Data Analysis Report 1
Accessing Data Analysis in PWA 3
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top