Problem with SQL services

When I reset or restart windows, the services mssqlserver
and the agent dont start.
I have this services configured with a administrator
domain user in the log on properties and for some reason
this services dont authenticate the password user I
received a error with the login but If I will to the
properties services and write the same password, the
service start.
The question is why dont start this services
automatically?
I change the password of this user and I have the same
problem.
My s.o. is win2000 sp4 and sql 2000 with sp3 in english
and this machine is a member of a w2000 domain.
I wait taht us understand me.
Regards,
Roque.In the properties of SQL Server (can be accessed from Enterprise manager by
right clicking on server), make sure "Auto start SQL Server Agent" is
checked.
ashish
"Roque Catanese" <anonymous@.discussions.microsoft.com> wrote in message
news:900e01c3e9cb$ab25f410$a601280a@.phx.gbl...

quote:

---

> When I reset or restart windows, the services mssqlserver
> and the agent dont start.
> I have this services configured with a administrator
> domain user in the log on properties and for some reason
> this services dont authenticate the password user I
> received a error with the login but If I will to the
> properties services and write the same password, the
> service start.
> The question is why dont start this services
> automatically?
> I change the password of this user and I have the same
> problem.
> My s.o. is win2000 sp4 and sql 2000 with sp3 in english
> and this machine is a member of a w2000 domain.
> I wait taht us understand me.
> Regards,
> Roque.

---

Problem with SQL services

When I reset or restart windows, the services mssqlserver
and the agent dont start.
I have this services configured with a administrator
domain user in the log on properties and for some reason
this services dont authenticate the password user I
received a error with the login but If I will to the
properties services and write the same password, the
service start.
The question is why dont start this services
automatically?
I change the password of this user and I have the same
problem.
My s.o. is win2000 sp4 and sql 2000 with sp3 in english
and this machine is a member of a w2000 domain.
I wait taht us understand me.
Regards,
Roque.In the properties of SQL Server (can be accessed from Enterprise manager by
right clicking on server), make sure "Auto start SQL Server Agent" is
checked.
ashish
"Roque Catanese" <anonymous@.discussions.microsoft.com> wrote in message
news:900e01c3e9cb$ab25f410$a601280a@.phx.gbl...
> When I reset or restart windows, the services mssqlserver
> and the agent dont start.
> I have this services configured with a administrator
> domain user in the log on properties and for some reason
> this services dont authenticate the password user I
> received a error with the login but If I will to the
> properties services and write the same password, the
> service start.
> The question is why dont start this services
> automatically?
> I change the password of this user and I have the same
> problem.
> My s.o. is win2000 sp4 and sql 2000 with sp3 in english
> and this machine is a member of a w2000 domain.
> I wait taht us understand me.
> Regards,
> Roque.

Problem with sql query reformatting on its own

I'm having a problem with some of my reports in SQL reporting services.
After I enter my sql query, the software reformats removing parenthesis and
moving sections of the statement around. Is there a way I can force the
system to accept my query as is?Use the generic query designer (the button to switch to this is one of the
buttons to the right of the ...)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diane Chase via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:cc800d5f7276462981022ea63d09d5a6@.SQLMonster.com...
> I'm having a problem with some of my reports in SQL reporting services.
> After I enter my sql query, the software reformats removing parenthesis
> and
> moving sections of the statement around. Is there a way I can force the
> system to accept my query as is?|||Thanks Bruce that worked!
--
Message posted via http://www.sqlmonster.com

Problem with SQL 2005 Beta 2 Reporting Services

I've just installed SQL 2005 Beta 2 onto a Windows Server 2003 SP1 box.
I've installed all the components, including Reporting Services.
When I try to connect to the web site I get the message
The request failed with HTTP status 407: Proxy Authentication Required.
Anonymous access to the web site is allowed.
Any thoughts?
Thanks
Laurence
--
Laurence Sharp
Senior Systems Engineer
TNS UKOn Thu, 7 Apr 2005 07:09:05 -0700, "Laurence Sharp"
<LaurenceSharp@.discussions.microsoft.com> wrote:
>I've just installed SQL 2005 Beta 2 onto a Windows Server 2003 SP1 box.
>I've installed all the components, including Reporting Services.
>When I try to connect to the web site I get the message
>The request failed with HTTP status 407: Proxy Authentication Required.
>Anonymous access to the web site is allowed.
>Any thoughts?
>Thanks
>Laurence
Hi Laurence,
Questions about RS2005 should probably go to the
microsoft.private.sqlserver2005.reportingsvcs. Despite the name it's a
public newsgroup intended for the RS2005 beta and CTPs.
Are you really using Beta 2 from June/July last year? Beta 2 has
functionality similar to RS2000 with little new.
If you are, then you should probably update BUT be sure to read
carefully CTPNotes.mht about uninstall order before upgrading.
The February CTP has new functionality and has fewer configuration
problems than earlier builds.
Andrew Watt
MVP - InfoPath

Problem with SQL 2000 Reporting Services in Windows Server 2000 IIS 5.0

Hi,

I′m having a problem with the SQL 2000 Reporting Services.
I′ve installed it in a windows 2000 server with IIS 5.0 and after i′ve installed the Reporting Services (even with the SP2 os Reporting Services installed), when i try to log on to the reports webside in order to start creating the folders of the reports that i want to create i get an error (ACCESS DENIED) and i′m trying to access it locally.

How can i solve this?

Regards,

Ricardo

Are you trying to open the website on the installed server or via another computer ?

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||Hi,

I′m trying to open the website on the instaled server. Even if i try to open it from a diferent computer, the error is the same.|||

Try using the rskeymgmt utility to backup the encryption key, and rsactivate utility to activate the site.

Check to see if the Default Application Pool in IIS is using the Network account identity.

Filemon from www.sysinternals.com may also help identify where the issue is.

cheers,

Andrew

|||Do you get an rsAccessDenied or the IIS Access Denied ?

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Problem with sorting in exported Excel document

Hello. I am using Reporting Services 2000 and Microsoft Excel 2003 running on
Windows XP Professional. I have a report that contains sales information that
I am exporting to Excel. The first two lines of the report contain title
information. They span all columns of the report. For example, the first line
(let's call it Food Sales Information) spans 15 columns. After the first two
lines of title information, there is a line containing the names of the
columns. After that, I have a lot of lines containing the sales data. I
export this to Excel. When I click in one of the numeric columns and click
the "A->Z" (sort ascending) button, I get the following error:
"This operation requires the merged cells to be identically sized."
Clciking Show Help gives me the following detail:
"This error only appears if you attempted to sort a range of previously
merged cells, but not all cells in the sort range were merged or are not of
the same size.
To avoid this behavior, unmerge all the merged cells in the range, or merge
all the cells in the range to be the same as the largest merged cell
grouping."
I believe this error to be caused the the two header rows. When I delete the
two header rows from the exported Excel document, I do not get the error.
Is there any way around this problem? Can I get the data to sort in Excel
without removing the header? Thanks in advance for the help.For those of you with this problem in the future who find this post
through google, Teo pointed me to a blog with this very issue
addressed. The bottom line is exporting to Excel from RS2000 leaves a
lot to be desired. Here is the blog with a work-around for this
problem:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx

Problem with scheduling an Analysis Services task

Hi All,

I have a problem with scheduling an Analysis Services task.

When I execute the DTS package from EM, every thing works fine.

When I schedule the package from SQL Agent, I get the following error when the job executes:

Error = -2147024770 (8007007E)
Error string: The specified module could not be found.
Error source: Microsoft Data Transformation Services (DTS) Package

I am running SQL 2K SP3a with Analysis Services 2K SP3a on WIN Server 2003 Std Edition

Any ideas or suggestions?Looks like your client has modules installed that the SQL Server does not. When you run the package from SQL EM, it uses your local machine's configuration as the context. When you run from SQL Agent, it uses the SQL Server's context.

Try searching here (http://support.microsoft.com) using "The specified module could not be found" -2147024770 (8007007E)|||Hi MaxA,

Thanks for your response. When I execute the package from EM on the server itself it works fine.

Will check out the ms site now... I thought Google would pick up everything on it?

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Reporting Services 2005

I installed SQL SERVER 2005 with RS2005 - it worked great.
Cause of a problem we had to re-installed the IIS so the virtual directories
of RS where gone...
To continue with errors i deleted the DB of RS
So now i try to re-install the RS but i get this error:
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.
Build version check:
Your upgrade is blocked because the existing component is a later version
than the version you are trying to upgrade to. To modify an existing SQL
Server component, go to Add or Remove Programs in Control Panel, select the
component you would like to modify, and then click Change/Remove.
So what should i do?when i try to it from Add/Remove it also don't work...
My version is :
Microsoft SQL Server Management Studio 9.00.2047.00
But when it try to install the RS it say : 9.1.2047.00
So what's the problem?Can you just try recreating the virtual directories and the databases using
Reporting services configuration manager instead of a complete reinstall?
--
Ramu
This posting is provided "AS IS" with no warranties, and confers no rights.
"ש×?×?×?" wrote:
> I installed SQL SERVER 2005 with RS2005 - it worked great.
> Cause of a problem we had to re-installed the IIS so the virtual directories
> of RS where gone...
> To continue with errors i deleted the DB of RS
> So now i try to re-install the RS but i get this error:
> Reason: Your upgrade is blocked. For more information about upgrade support,
> see the "Version and Edition Upgrades" and "Hardware and Software
> Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> Online.
> Build version check:
> Your upgrade is blocked because the existing component is a later version
> than the version you are trying to upgrade to. To modify an existing SQL
> Server component, go to Add or Remove Programs in Control Panel, select the
> component you would like to modify, and then click Change/Remove.
>
> So what should i do?when i try to it from Add/Remove it also don't work...
> My version is :
> Microsoft SQL Server Management Studio 9.00.2047.00
> But when it try to install the RS it say : 9.1.2047.00
> So what's the problem?
>|||thanks,it helped
what amazing tool!!!
"Ramu_MSFT" wrote:
> Can you just try recreating the virtual directories and the databases using
> Reporting services configuration manager instead of a complete reinstall?
> --
> Ramu
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "ש×?×?×?" wrote:
> > I installed SQL SERVER 2005 with RS2005 - it worked great.
> > Cause of a problem we had to re-installed the IIS so the virtual directories
> > of RS where gone...
> > To continue with errors i deleted the DB of RS
> > So now i try to re-install the RS but i get this error:
> >
> > Reason: Your upgrade is blocked. For more information about upgrade support,
> > see the "Version and Edition Upgrades" and "Hardware and Software
> > Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> > Online.
> >
> > Build version check:
> > Your upgrade is blocked because the existing component is a later version
> > than the version you are trying to upgrade to. To modify an existing SQL
> > Server component, go to Add or Remove Programs in Control Panel, select the
> > component you would like to modify, and then click Change/Remove.
> >
> >
> > So what should i do?when i try to it from Add/Remove it also don't work...
> >
> > My version is :
> > Microsoft SQL Server Management Studio 9.00.2047.00
> > But when it try to install the RS it say : 9.1.2047.00
> >
> > So what's the problem?
> >

Problem with Report Services Integration in MOSS 2007

Specifics:
First machine: SharePoint single server Farm
Second machine: SQL 2005 with Report Services
Installed SP2 and RS Add-in, added SQL pc to farm, and followed steps to set
up integration, including changing SQL service accounts to domain accounts.
Everything went smoothly until we clicked on â'Set Server Defaultsâ' under
Reporting Services in SharePoint Central Admin and we got an error message:
An unexpected error occurred while connecting to the report server. Verify
that the report server is available and configured for SharePoint integrated
mode. --> Server was unable to process request. --> The request failed with
HTTP status 401: Unauthorized.
Nothing in the Event Log on the MOSS server but on the SQL server there is
an Event ID 529 â' unknown user name or bad password. This error message also
shows that the Logon Process and the Authentication Package are Kerberos.
We have beaten our heads against the wall trying to solve. Any help would be
appreciated.Did you check your Service Accounts in IIS and the Reporting Services setup
in SQL server. We had the same issue and it turned out to be we had missed
some of the accounts in Central Admin and IIS.
"AlisonZ" wrote:
> Specifics:
> First machine: SharePoint single server Farm
> Second machine: SQL 2005 with Report Services
> Installed SP2 and RS Add-in, added SQL pc to farm, and followed steps to set
> up integration, including changing SQL service accounts to domain accounts.
> Everything went smoothly until we clicked on â'Set Server Defaultsâ' under
> Reporting Services in SharePoint Central Admin and we got an error message:
> An unexpected error occurred while connecting to the report server. Verify
> that the report server is available and configured for SharePoint integrated
> mode. --> Server was unable to process request. --> The request failed with
> HTTP status 401: Unauthorized.
> Nothing in the Event Log on the MOSS server but on the SQL server there is
> an Event ID 529 â' unknown user name or bad password. This error message also
> shows that the Logon Process and the Authentication Package are Kerberos.
> We have beaten our heads against the wall trying to solve. Any help would be
> appreciated.
>

Problem with report manager find command

I am using sql server reporting services with service pack 2 applied. One of
my users has encountered a strange problem using the find command after a
report has been run.
If you try to use the find command in the report manager to locate a string
that is in the last group on a page, it will report "The search text was not
found". The find command works fine for test in all other groups on the
report. If you export the report to pdf, the acrobat search function will
find the text. I have tested several of my reports they all seem to have the
same problem.
Has anyone else had this problem with the find command in the report
manager? Any idea how to fix it?Hi,
Welcome to use MSDN Managed Newsgroup Support.
To state the problem clearly, would you tell me how you are searching the
string in report manager?
Do you use the Ctrl-F to find a string in a report via browser? If so,
which browser and what version do you use?
The Search for Feature in the Report Manager Page can only search published
reports, folders, shared data sources, and resources.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the input. I will try to be more clear.
Here is the procedure I am using. First I am run the report in Internet
Explorer 6. I type the search string into the text box which appears between
the zoom factor (100%) and the word find. When I hover my mouse over the
text box a tool tip pops up and displays "find text". Finally, I click on
the word "Find".
Normally the report will jump to wherever the search string is first found
in the report, regardless of which page it appears on. As I stated earlier
if the search string appears in the last group on a page, for some reason it
will not be found.
I noticed today that the problem only seems to occur if the last group on
the page spans onto the next page. If the last group on the page finishes on
the page you can successfully find items in that group.
"Wei Lu" wrote:
"Wei Lu" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup Support.
> To state the problem clearly, would you tell me how you are searching the
> string in report manager?
> Do you use the Ctrl-F to find a string in a report via browser? If so,
> which browser and what version do you use?
> The Search for Feature in the Report Manager Page can only search published
> reports, folders, shared data sources, and resources.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi Guess,
Thank you for update. I understood your concern is that you are trying to
search the string in a report with a html viewer and you can not find it if
the string in the last group. If I misunderstood your concern, please feel
free to point it out.
In the reporting service, this Search feature searches for content in the
report by typing a word or phrase that you want to find (the maximum value
length is 256 characters). The search is case-insensitive and begins at the
page or section that is currently selected. Only visible content is
included in a search operation. This search feature is based on javascript.
So I'd like to know if you use the Ctrl-F to search the string, will you
find it properly? Is this string visible or not?
Also you may want to insert a page break after the table to test.
Further, if you installed the Sample, you may check if the issue occurs on
¡"product catalog" sample report.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for you efforts.
To answer your question, the text is visible. If I use Ctrl-F, it does find
the text as long as I am currently on the page where the text appears. In my
experience, the find/next commands in the report manager will find a string
on the current page as well as all other pages (both before and after the
current page) except in the circumstances described in my earlier posts.
The problem I am having does occur in the Product Catalog sample report.
For example on page five, the last line of the report has product no. of
"BK-M38S-56". The find command will not find this product no.. If I use
Ctrl-F it will find the product no., as long as I am on page 5. In fact I
can not use the find/next commands to locate any product no. in the
"Mountain-400" section on page 5.
The sample reports are on my local machine. The earlier reports I tested
were on our application server. I am curious to know if you experience the
same problem on page 5 of the product catalog.
I tried adding a page break after the table in the Product Catalog sample
report. It did not make any difference.
"Wei Lu" wrote:
> Hi Guess,
> Thank you for update. I understood your concern is that you are trying to
> search the string in a report with a html viewer and you can not find it if
> the string in the last group. If I misunderstood your concern, please feel
> free to point it out.
> In the reporting service, this Search feature searches for content in the
> report by typing a word or phrase that you want to find (the maximum value
> length is 256 characters). The search is case-insensitive and begins at the
> page or section that is currently selected. Only visible content is
> included in a search operation. This search feature is based on javascript.
> So I'd like to know if you use the Ctrl-F to search the string, will you
> find it properly? Is this string visible or not?
> Also you may want to insert a page break after the table to test.
> Further, if you installed the Sample, you may check if the issue occurs on
> ¡"product catalog" sample report.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Guess,
I have searched in our internal knowledge base, it is a known issue in
Reporting Service and is fixed in SQL Server 2005 Reporting Services.
For now, if it has much business impact on you, I recommend that you open a
Support incident
with Microsoft Customer Service and Support (CSS) so that a dedicated
Support Professional can work with you in a more timely and efficient
manner. If you need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If there are further questions on the issue, please feel free to let us
know. Have a great day!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with 'Reply-To' in data driven subscription

I am running SQL Server 2000 sp4 and Reporting Services 2000 sp2. I set
up a data driven subscription with a static Reply-To address. However,
when the report runs, the reply is the default in the config file.
I've seen 1 other post on this but no solution. Help would be
appreciated.
NeilI captured this info using SQL Profiler:
exec CreateSubscription @.Report_Name =N'/WebInvoiceStatus_Reports/VendorActivity', @.id ='86750772-3D96-4059-8B1E-9F5F5D6C8000', @.OwnerSid =0x01050000000000051500000093E362480D7A5A33828BA628CA300100, @.OwnerName
= N'US\A0312698', @.OwnerAuthType = 1, @.Locale = N'en-US',
@.DeliveryExtension = N'Report Server Email', @.InactiveFlags = 0,
@.ExtensionSettings =N'<ParameterValues><ParameterValue><Name>TO</Name><Field>EmailAddress</Field></ParameterValue><ParameterValue><Name>ReplyTo</Name><Value>aphelp@.abcdef.com</Value>...
This shows that the value I wanted was being picked up. So I wonder if
the problem is with the smtp.
Neil|||My issue is not with the 'Reply-To' I just discovered.
It is the 'From' that I have been trying to change and that cannot be
done for each subscription.
The From did change when I changed it in the config file.
I love solving my own problems.
Neil

Problem with ProClarity analystics 6 for SQL Server 2005 reporting services

Hi, all here,

Thank you very much for your kind attention.

I'v got a problem with Microsoft ProClarity for SQL Server 2005 reporting services as below:

Created a 3-D effect reports (which are views in ProClarity professional ) and exported it into SQL Server 2005 reporting services, but the result in SQL Server 2005 reporting serivces is totally different, no 3-D result, and also the color of the report has totally changed, for better result in SQL Server 2005, I have to manually modify the reporting file in reporting services.

Another problem is: the views created in ProClarity always change colors (the colors I think are aweful) after exported into SQL Server 2005 reporting services.

Can any expert for that give me any adives for that? What can we try to solve this problem?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

I recommend http://www.proclarity.com/services/support.asp for these problems.

Regards

Thomas Ivarsson

|||

Thanks a lot.

With best regards,

Problem with ProClarity analystics 6 for SQL Server 2005 reporting services

Hi, all here,

Thank you very much for your kind attention.

I'v got a problem with Microsoft ProClarity for SQL Server 2005 reporting services as below:

Created a 3-D effect reports (which are views in ProClarity professional ) and exported it into SQL Server 2005 reporting services, but the result in SQL Server 2005 reporting serivces is totally different, no 3-D result, and also the color of the report has totally changed, for better result in SQL Server 2005, I have to manually modify the reporting file in reporting services.

Another problem is: the views created in ProClarity always change colors (the colors I think are aweful) after exported into SQL Server 2005 reporting services.

Can any expert for that give me any adives for that? What can we try to solve this problem?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

I recommend http://www.proclarity.com/services/support.asp for these problems.

Regards

Thomas Ivarsson

|||

Thanks a lot.

With best regards,

Problem with Parameters

I am writing a Data Processing Extension for Reporting Services and am
having a problem getting the values of parameters I pass in the query string
in ReportDesigner.
I have implemented the IDbCommandAnalysis GetParameters() method to parse
the query string in ReportDesigner. When I enter
"&CompanyId=1000&EmployeeId=2000" in the "Query string" field,
GetParameters() returns a local collection with my two parameters and their
values.
Upon command execution, the IDataParameterCollection IDbCommand.Parameters
property getter is called twice before calling ExecuteReader() and return my
member parameter collection. When ExecuteReader() is called, my member
parameter collection contains the two parameters of the correct name but
with values of null.
Because the parameters with correct names are added to the collection, it
seems that ReportDesigner saved the parameter collection I returned from
GetParameters() but what happened to the parameter values?
Since the values are null, ReportDesigner pops a window for the values to be
input. I don't want this to happen after the report is deployed but cannot
find a way to simulate the parameter name-value pairs being submitted on the
URL string.
What am I missing?
Thanks,
TomHi Tom,
Welcome to use MSDN Managd Newsgroup!
I am looking into this issue and will update you as soon as possible. I
have also noticed you have another two duplicated posts. To ensure the
integrity of newsgroup, I will answer your questions and follow up issue in
this thread.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Michael,
Thanks for your reply. I wanted to pass along some additional information
about the parameter problem I'm having.
I published my report and fount the parameters are passed to the report when
added to the URL. That's good, but it points out a big disparity between
parameter handling in ReportDesigner and in published reports.
I look forward to learning what you discover about the correct way to handle
parameters.
Thanks,
Tom
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:WJlr33TeFHA.4856@.TK2MSFTNGXA01.phx.gbl...
> Hi Tom,
> Welcome to use MSDN Managd Newsgroup!
> I am looking into this issue and will update you as soon as possible. I
> have also noticed you have another two duplicated posts. To ensure the
> integrity of newsgroup, I will answer your questions and follow up issue
> in
> this thread.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Tom,
Sorry for the delay, would you please provide me a sample project? I
understand the information may be sensitive to you, my direct email address
is v-mingqc@.online.microsoft.com (please REMOVE "online" before you click
SEND as it's ONLY for SPAM), you may send the file to me directly and I
will keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Michael,
I am having the same problem. Did you ever figure this out for Tom?
I am trying to run a report by passing in the parameter through the url.
The report comes up but prompts for the parameter instead of taking it
through url. If I enter it at the prompt, the report runs fine. My url looks
like:
http://server-1/Reports/Pages/Report.aspx?ItemPath=%2fMarkListingbyStudent%2fMarkListingbyStudent&rs:Command=Render&calendarID=155
It's internal though.
Thank you for your help!
Sharlyn
"Michael Cheng [MSFT]" wrote:
> Hi Tom,
> Sorry for the delay, would you please provide me a sample project? I
> understand the information may be sensitive to you, my direct email address
> is v-mingqc@.online.microsoft.com (please REMOVE "online" before you click
> SEND as it's ONLY for SPAM), you may send the file to me directly and I
> will keep secure.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

problem with panda antivirus and olap cubes

I have the next problem:
i have MS sql server 2005 installed in a server.
We have some olap cubes in the server deployed with analysis services 2005.
When we try to connect to the analysis server from a client pc using pivot tables we obtain this error:
"Errors in network layers. Error code=0XC10D0009, External code=0x00000000"
The client pc has panda antivirus (corporate) with true prevent
When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server.
Anybody had a similar problem?
Anybody knows a solution for it?
Thanks
Jose
coormx@.yahoo.com.mx

Jose,

In this situaion, the fast way is to contact the antivirus vendor to solve the issue.

However, if you can post your *connection string* and *exact error message*, somebody in this forum might help you to pinpoint your issue.

|||

Moving to the SQL Server Analysis Services Forum.

|||panda has fixed the problem. Tank you panda

problem with panda antivirus and olap cubes

I have the next problem:
i have MS sql server 2005 installed in a server.
We have some olap cubes in the server deployed with analysis services 2005.
When we try to connect to the analysis server from a client pc using pivot tables we obtain this error:
"Errors in network layers. Error code=0XC10D0009, External code=0x00000000"
The client pc has panda antivirus (corporate) with true prevent
When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server.
Anybody had a similar problem?
Anybody knows a solution for it?
Thanks
Jose
coormx@.yahoo.com.mx

Jose,

In this situaion, the fast way is to contact the antivirus vendor to solve the issue.

However, if you can post your *connection string* and *exact error message*, somebody in this forum might help you to pinpoint your issue.

|||

Moving to the SQL Server Analysis Services Forum.

|||panda has fixed the problem. Tank you panda