When iam clicking cube creation button in my application it's making me error
that " design aggregation for partition failed.cannot generate sspi context"

I may be wrong but I think this is a SQL Server issue - thats where I have
seen this error before. I think it may be a permissions problem.

I have seen this error under the following circumstances:
1) I was sharing a Windows UserID with someone else. I was using this UserID
to connect to SQL Sever through (say) Query Analyser
2) The password on the account expired and the other person using the
account changed it
3) I tried to open a new connection or query window and I got the error that
you are getting "cannot generate SSPI context".

Fix was to log out and log back in again (with the new password obviously).

Hope this helps.

Regards
Jamie Thomson
http://www.conchango.com

P.S. Anyone know what SSPI stands for?


"Bineesh Namboodiri" wrote:

But iam getting this error when going to run cube creation process in my
application. it's true that iam using sql server as database. also i have
error part "design aggregation for partition failed " which i find as a part
of partitions of cubes . so i want to know whether it's failure of
aggregations & how i can activate it . or is it because of some other error"

"Jamie Thomson" wrote:

Security Support Provider Interface (SSPI) is a set of Windows APIs that
permits delegation and mutual authentication over any generic data
transport layer, such as TCP/IP sockets. Therefore, SSPI permits a
computer that is running a Windows operating system to securely delegate
a user security token from one computer to another over any transport
layer that can transmit raw bytes of data.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!