Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIA
Try to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:
> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIAsql

Analysis Services

I am trying to work through the tutorial when you load SQL 2005. I am running the 64 bit version. I have deployed my cube and am trying to display data in the browser. I move over the sales amount into the data area I get the below message. What should I do to fix this issue?

The query could not be processed:

Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed.

Sounds similar to the problem discussed in this thread:

http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/d2ca4c8981db915a
>>

" noWrap width="1%" bgColor=#b71c0c>Mosha Pasumansky [MS] Oct 17, 2:24 pm show options

Newsgroups: microsoft.public.sqlserver.olap From: "Mosha Pasumansky [MS]" <mos...@.online.microsoft.com> - Find messages by this author Date: Mon, 17 Oct 2005 11:24:25 -0700 Local: Mon, Oct 17 2005 2:24 pm Subject: Re: AS 2005: ....a string was found that was larger than the page size Reply | Reply to Author | Forward | Print | View Thread | Show original | Report Abuse

Please read this thread - there is plenty of feedback from the product team.
It is a bug in CTP16 that is fixed in RTM. If you are TAP customer - you can
get CTP16 hotfix for it.

--
==============================­====================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL­og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================­====================
>>

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh