Problems with Data Analysis

[Antonio]

Hi all,

I'm having a problem with Data Analysis in Project Server 2007.

I have a Project Server 2007 configured with SQL Server 2005 and Data
Analysis Services. All products are installed in the same server.

When I try to create a Data Analysis View in PWA from any station, no
Analysis Services Database appears in the combo box. If I try to search, the
following message appears: "Failed do connect to the Analysis Services
server. Verify the server name and try again". If I try to access a view
already created (in Data Analysis page), I get the message "An error was
encountered in the transport layer".

However, if I do the same in a browser in the server (also with my
domain\user) it works fine. In the server I can create and access the data
analysis views without any problem.

I started a trace in Analysis Services database to see what happens. When I
use the server browser, in NTUserName (AuditLogin event) appears my user.
When I try to do the same in my machine's browser, the NTUserName contains
"ANONYMOUS LOGON".

It seems to be a permission problem, but I don't know where.

Could anyone help me?


Best regards,

Antonio Augusto.

 

[Dave]

Hello Antonio,

I am assuming you are using SQL 2005. If that is the case take a look at the
following technet article

http://technet.microsoft.com/en-us/library/cc197552.aspx

Make sure you use Option 2 for configuring the repository.

Make sure you follow the last part, the part about Installing the Microsoft
SQL Server 2005 Analysis Services 9.0 OLE DB Provider, this has to be
installed on all the client machines that need to access Data Analysis. Also
make sure that the PWA site is added to the list of trusted sites on the
client and the Access data across domains setting is eabled

Let us know if it works.

Dave

 

[Antonio]

Hello Dave,

Unfortunatelly, it didn't work.

First of all, I'm using SQL 2005.

I looked at the article, and changed some confgurations, according with is
writen there. Also I changed the repository configuration, because my
Analysis Service was using the option 1 for repository.

However, the problem persists. I can configure views and view them only when
I'm logged on the server. If I try to view the Data Analysis views in my
station, I get the error:
"The query could not be processed:
- An error was encountered in the transport layer.
- The peer prematurely closed the connection."

The problem seems to be caused by the way IIS passes the credentials away
with remote connections. When I'm logged on the server, my user appears in
the trace as the NTUserName in the Audit Login. When I'm accessing from my
workstation, in the same field appears "ANONYMOUS LOGON".

The PWA site is in Trusted Sites list, and the option for access data across
domains is also checked.


Do you have any other idea about what could be the problem?

Regards,

Antonio.

 

[M_Arizaga]

Hello,

I'm having the same issue Antonio described.
I've already installed the MSXML 6, the ADODB Data provider for AS 9.0, the
SQL Native Client, and checked and rechecked the configurations acording to
the articles on TechNet but nothing seems to work.

As Antonio did, I've traced the SQL Server and found the same "ANONYMOUS
LOGON" issue....

I will appreciate any help

Thanks

 

[Kalpana Rajan]

Was anyone successful? I am having the same issue. Any help is greatly appreciated...

Thanks
kalpana

 

[Christophe Fiessinger [MSFT]]

I'm not sure what is the issue but here is a good start:
http://technet.microsoft.com/en-us/library/cc303402.aspx

--
Christophe Fiessinger
Microsoft
http://blogs.msdn.com/chrisfie

in message
news:[email protected]...