OWC Connection error

[alex]

Hi,

I got error when using OWC on the client machine. The error is "No
connection can be made because target server actively refused it". In the
server, it's ok. For testing, i logon to the client machine as domain admin,
but the problem still occur. However, when i create connection directly from
MS Excel to the server (Analysis Services), then i can browse the cube. What
may be the problem?

Alex

 

[Alvin Bruney [MVP]]

most likely a permissions error on the server. make sure it can accepts
requests from the asp or aspnet account or what ever account owc is run
under.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[alex]

Hi Alvin

Thanks for reply. For testing, i use domain admin to logon to the client
machine and open the page with OWC. This is the problem that occur. So i
guess it's not permission issue

Alex

most likely a permissions error on the server. make sure it can accepts
requests from the asp or aspnet account or what ever account owc is run
under.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi,

I got error when using OWC on the client machine. The error is "No
connection can be made because target server actively refused it". In the
server, it's ok. For testing, i logon to the client machine as domain
admin, but the problem still occur. However, when i create connection
directly from MS Excel to the server (Analysis Services), then i can
browse the cube. What may be the problem?

Alex

 

[Alvin Bruney [MVP]]

From the database, determine the account that the query is being run under.
Then, find out if this account has the relevant permissions to query the db.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi Alvin

Thanks for reply. For testing, i use domain admin to logon to the client
machine and open the page with OWC. This is the problem that occur. So i
guess it's not permission issue

Alex

most likely a permissions error on the server. make sure it can accepts
requests from the asp or aspnet account or what ever account owc is run
under.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi,

I got error when using OWC on the client machine. The error is "No
connection can be made because target server actively refused it". In
the server, it's ok. For testing, i logon to the client machine as
domain admin, but the problem still occur. However, when i create
connection directly from MS Excel to the server (Analysis Services),
then i can browse the cube. What may be the problem?

Alex