Hi all,
Can any one help me? I have the below code within a user control, when I
debug the code within .NET it is able to connect to the Analysis server and
process the cube BUT when I deploy the code within a SmartPart it fails with
a connection error (ex.Message "Cannot connect to the Analysis server on
computer 'xxxx'.\r\nConnection to the server is lost" string) at code line:
dsoServer.Connect("xxxxx");. Please any help with this.
private void cmdProcessCube_Click(object sender, System.EventArgs e)
{
string name = "";
bool status = true;
string message = "Cube has been processed successfully.";
try
{
//System.Diagnostics.Debugger.Break();
DSO.Server dsoServer = new DSO.ServerClass();

dsoServer.Connect("xxxxx");
if(dsoServer.MDStores.Find("xxx"))
{
foreach(DSO.MDStore dsoDB in dsoServer.MDStores)
{
if(dsoDB.Name == "xxx")
{
foreach(DSO.MDStore dsoCube in dsoDB.MDStores)
{
name += dsoCube.Name + "\r\n";
if(dsoCube.Name == "Sales") // To Process all the cubes comment out this
line of code
dsoCube.Process(DSO.ProcessTypes.processDefault);
}}}}}
catch(Exception ex)
{
status = false;
message = "An error has occured while processing the cube.\nError:" +
ex.Message;
}
//this.GenerateScript(message);
if(status)
{
UpdateForecastCurrentEventFlag();
Response.Redirect("http://www.yahoo.com");
}}

Please any help with this issue, while it can’t connect to Analysis server
from within SmartPart But I am able to connect to a cube using the Microsoft
Office PivotTable Component for data analysis and reporting.

Hi,

Are you trying to connect to a 2005 AS Server or earlier?

What is SmallPart? Does it run under a network service account or local
system account and if so, does it have relevant permissions to connect to the
AS server?

If the code runs in .Net and connects ok, i would check security issues with
SmallPart.
--
Kyle Henly
DBA
U.K.


"knyada" wrote:

Hi Kyle,
I am trying to connect to 2000 AS server. SmartPart is a web part use with
SharePoint Portal server as a container to display *.ascx controls. SmartPart
is just a web part and does not have any service. I believe it thus run under
SharePoint services
Thank for the reply.

"Kyle Henly" wrote:

does your AS server is on a different server then the sharepoint server?
if yes, does your kerberos delegation is setup correctly?

"knyada" <knyada (AT) discussions (DOT) microsoft.com> wrote

Hi jeje,
Thanks for the reply. Both servers are on the same machine and I am able to
assess the cubes through office pivot Table web part.

"Jeje" wrote:

ok

does your ASCX control works outside sharepoint?
if you use it in a standard ASPX page, can you access the cube?
what is your connection string?


"knyada" <knyada (AT) discussions (DOT) microsoft.com> wrote

Hi Jeje,
All our applications are running ontop of Sharepoint. The only means i can
test it using an ASPX page is when i am testing with .NET. My Connection
string is within the code.
DSO.Server dsoServer = new DSO.ServerClass();

dsoServer.Connect("xxxxx");
where xxxx is the name of our server say Peopleworld.

"Jeje" wrote:

mmm
difficult to see what's appends
you have to test your code outside sharepoint first.

have you try the "localhost" server name?
does the identity is set to impersonate in the web.config file?

"knyada" <knyada (AT) discussions (DOT) microsoft.com> wrote

Hi jeje,
I have try it, also server name, server ip but none is working. Also the
identity is set to impersonate. I need think this is something the i will
have to talk with the network guys. Thanks for the help.

"Jeje" wrote: