dbTalk Databases Forums  

Error when connect to Analysis Service

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error when connect to Analysis Service in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
aa
 
Posts: n/a

Default Error when connect to Analysis Service - 06-16-2004 , 03:58 AM






Dear all,

I got an error message when I try to connect the analysis service from
ASP.NET. The connection string is "Provider=MSOLAP.2;Data
Source=server;Initial Catalog=OLAP;SSPI=ANONYMOUS;". And the error message
is "The operation requested failed due to security problems - This SSPI
package is not installed on this system ANONYMOUS".
My setting is showed as follow:
Server - Windows 2003 Standard Server
Client - Windows 2000 Professional
Analysis Service and SQL server 2000, both with SP3.

Can anyone help me?

Best regards,
Francis



Reply With Quote
  #2  
Old   
peejay
 
Posts: n/a

Default Re: Error when connect to Analysis Service - 06-16-2004 , 10:04 PM






Francis, Try changing the SSPI parameter to lower case "anonymous"

"aa" <aaa (AT) badman (DOT) com> wrote

Quote:
Dear all,

I got an error message when I try to connect the analysis service from
ASP.NET. The connection string is "Provider=MSOLAP.2;Data
Source=server;Initial Catalog=OLAP;SSPI=ANONYMOUS;". And the error message
is "The operation requested failed due to security problems - This SSPI
package is not installed on this system ANONYMOUS".
My setting is showed as follow:
Server - Windows 2003 Standard Server
Client - Windows 2000 Professional
Analysis Service and SQL server 2000, both with SP3.

Can anyone help me?

Best regards,
Francis

Reply With Quote
  #3  
Old   
aa
 
Posts: n/a

Default Re: Error when connect to Analysis Service - 06-17-2004 , 11:02 PM



It work now. thanks

"peejay" <pj4u_73 (AT) hotmail (DOT) com> wrote

Quote:
Francis, Try changing the SSPI parameter to lower case "anonymous"

"aa" <aaa (AT) badman (DOT) com> wrote

Dear all,

I got an error message when I try to connect the analysis service from
ASP.NET. The connection string is "Provider=MSOLAP.2;Data
Source=server;Initial Catalog=OLAP;SSPI=ANONYMOUS;". And the error
message
is "The operation requested failed due to security problems - This SSPI
package is not installed on this system ANONYMOUS".
My setting is showed as follow:
Server - Windows 2003 Standard Server
Client - Windows 2000 Professional
Analysis Service and SQL server 2000, both with SP3.

Can anyone help me?

Best regards,
Francis



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.