Friday, March 30, 2012

Reporting services SQL 2005 in windows 2003

installed sql2005 on win2003 machine. configured reporting services.

I see 2 virtual directories. But I get error msg when I go to http://localhost/reports

Error msg is "The report server is not responding. Verify that the report server is running and can be accessed from this computer." .

Please let me know how this can be fixed..

Thanks

I have Windows 2003 EE (CZ) and SQL 2005.

After restarting Win Server Reporting service fials to automaticaly starts-up.

Open Services and check if SQL Reporting Service is running.

Reporting Services SP2 public chat...

We'll be hosting a public chat on the contents of Service Pack 2 on February
8th at 2pm Pacific Time. It's listed at
http://www.microsoft.com/technet/community/chats/default.mspx.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.Stephen Dybing [MSFT] wrote:
> We'll be hosting a public chat on the contents of Service Pack 2 on February 8th at 2pm Pacific
> Time. It's listed at http://www.microsoft.com/technet/community/chats/default.mspx.
> --
> Sincerely,
> Stephen Dybing
When will it be available for download?|||The transcript is usually available within a week of the chat, but the time
does vary a bit.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"GeoSynch" <SpamSlayed@.Casablanca.com> wrote in message
news:OUY7wj2AFHA.3588@.TK2MSFTNGP11.phx.gbl...
> Stephen Dybing [MSFT] wrote:
>> We'll be hosting a public chat on the contents of Service Pack 2 on
>> February 8th at 2pm Pacific Time. It's listed at
>> http://www.microsoft.com/technet/community/chats/default.mspx.
>> --
>> Sincerely,
>> Stephen Dybing
> When will it be available for download?
>|||What about Service Pack 2?
When will that be available for download?
Thanks.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OKTVrM$AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> The transcript is usually available within a week of the chat, but the time does vary a bit.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "GeoSynch" <SpamSlayed@.Casablanca.com> wrote in message
> news:OUY7wj2AFHA.3588@.TK2MSFTNGP11.phx.gbl...
>> Stephen Dybing [MSFT] wrote:
>> We'll be hosting a public chat on the contents of Service Pack 2 on February 8th at 2pm Pacific
>> Time. It's listed at http://www.microsoft.com/technet/community/chats/default.mspx.
>> --
>> Sincerely,
>> Stephen Dybing
>> When will it be available for download?
>

Reporting Services SP2 for SQL 2005 server

Does anyone know where I can download this?
I can only find the download for SQL 2000 RS SP2
Any help appreciated
ThanksThere isn't Reporting Service2005 SP2. Unlike RS2000, which was released
seperately (and later than) from SQL Server2000, SQL Server 2005 comes with
RS built-in. So, SP for SQL Sever 2005 includes all possible fixes to its
RS. So, you need to apply SQL Server2005 SP2.
However, i am not sure what to do, if you use RS from 2005 on SQL
Server2000, i.e. there isn't SQL Server2005 instance.
"Duparoni" <Duparoni@.discussions.microsoft.com> wrote in message
news:74E5B0C1-82DB-475C-9D8E-B40507E21FAF@.microsoft.com...
> Does anyone know where I can download this?
> I can only find the download for SQL 2000 RS SP2
> Any help appreciated
> Thanks|||On Sep 5, 3:30 pm, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> There isn't Reporting Service2005 SP2. Unlike RS2000, which was released
> seperately (and later than) from SQL Server2000, SQL Server 2005 comes with
> RS built-in. So, SP for SQL Sever 2005 includes all possible fixes to its
> RS. So, you need to apply SQL Server2005 SP2.
> However, i am not sure what to do, if you use RS from 2005 on SQL
> Server2000, i.e. there isn't SQL Server2005 instance.
> "Duparoni" <Dupar...@.discussions.microsoft.com> wrote in message
> news:74E5B0C1-82DB-475C-9D8E-B40507E21FAF@.microsoft.com...
> > Does anyone know where I can download this?
> > I can only find the download for SQL 2000 RS SP2
> > Any help appreciated
> > Thanks
Norman is correct. Here is the link to SQL Server 2005 SP2.
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en
Regards,
Enrique Martinez
Sr. Software Consultant

Wednesday, March 28, 2012

Reporting Services sp2 Client Printing Problem

Hi, I've been using SQL Server 2K Reporting Services since its SP 1 release,
and because the client side printing capability was introduced with SP2 beta,
I jumped right into the beta program and tried it out. It did work well, and
the cabability got the load off my shoulder of having to create my own
printing application. I just had to wait for the SP2 release. Yesterday I got
a mail from the beta program team that SP2 is now ready, so I went ahead and
installed it so that I could now use it in the production enviornment,
thinking this new print button would dramattically increase the reporting
service usage. The client printing is there, but to my surprise, when I
pressed the print icon from the report tool bar from a client, I get the
following message "Error loading resource string. (0x00000000)." I tried it
on another client and on the server itself, I got the same result. I can
still print after hitting "OK" button many times to get to the print dialog
box, and at this stage things work fine, but it seems that printer
information is not passed correctly from the client machine to the print
dialog box, since most of its entries are missing. Since this SP is just
released, I could not find any KB or other articals to troubleshoot this
issue. To complicate the issue further, I am not sure whether this is
happening because I installed it on SP2 beta machine. Anybody please help
me!!You need to clean out any older versions of the controls from your
C:\WINDOWS\Downloaded Program Files directory. See if that solves your
problem.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"RabbitBike" <RabbitBike@.discussions.microsoft.com> wrote in message
news:D5468C0D-5D4B-4096-B76B-BE62F1ADE3F2@.microsoft.com...
> Hi, I've been using SQL Server 2K Reporting Services since its SP 1
> release,
> and because the client side printing capability was introduced with SP2
> beta,
> I jumped right into the beta program and tried it out. It did work well,
> and
> the cabability got the load off my shoulder of having to create my own
> printing application. I just had to wait for the SP2 release. Yesterday I
> got
> a mail from the beta program team that SP2 is now ready, so I went ahead
> and
> installed it so that I could now use it in the production enviornment,
> thinking this new print button would dramattically increase the reporting
> service usage. The client printing is there, but to my surprise, when I
> pressed the print icon from the report tool bar from a client, I get the
> following message "Error loading resource string. (0x00000000)." I tried
> it
> on another client and on the server itself, I got the same result. I can
> still print after hitting "OK" button many times to get to the print
> dialog
> box, and at this stage things work fine, but it seems that printer
> information is not passed correctly from the client machine to the print
> dialog box, since most of its entries are missing. Since this SP is just
> released, I could not find any KB or other articals to troubleshoot this
> issue. To complicate the issue further, I am not sure whether this is
> happening because I installed it on SP2 beta machine. Anybody please help
> me!!|||Thank you!! After I deleted the "RSClientPrint Class" activeX control, things
worked as expected. A new file with the same name was downloaded into the
directory, and I remember a client has been asked for the first time they
downloaded it just like any other ActiveX control (and you are asked whether
or not to download the file depending on your IE security setting, right?)
Thank you again, and I apologize for the initial post being that long. I got
too excited in writing about this SP2 release and its printing capability
which I think will make a lot of people happy. And I guess my post applies
only to the beta testers, but I hope your answer will help them when they see
the same problem.
"Brian Welcker" wrote:
> You need to clean out any older versions of the controls from your
> C:\WINDOWS\Downloaded Program Files directory. See if that solves your
> problem.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "RabbitBike" <RabbitBike@.discussions.microsoft.com> wrote in message
> news:D5468C0D-5D4B-4096-B76B-BE62F1ADE3F2@.microsoft.com...
> > Hi, I've been using SQL Server 2K Reporting Services since its SP 1
> > release,
> > and because the client side printing capability was introduced with SP2
> > beta,
> > I jumped right into the beta program and tried it out. It did work well,
> > and
> > the cabability got the load off my shoulder of having to create my own
> > printing application. I just had to wait for the SP2 release. Yesterday I
> > got
> > a mail from the beta program team that SP2 is now ready, so I went ahead
> > and
> > installed it so that I could now use it in the production enviornment,
> > thinking this new print button would dramattically increase the reporting
> > service usage. The client printing is there, but to my surprise, when I
> > pressed the print icon from the report tool bar from a client, I get the
> > following message "Error loading resource string. (0x00000000)." I tried
> > it
> > on another client and on the server itself, I got the same result. I can
> > still print after hitting "OK" button many times to get to the print
> > dialog
> > box, and at this stage things work fine, but it seems that printer
> > information is not passed correctly from the client machine to the print
> > dialog box, since most of its entries are missing. Since this SP is just
> > released, I could not find any KB or other articals to troubleshoot this
> > issue. To complicate the issue further, I am not sure whether this is
> > happening because I installed it on SP2 beta machine. Anybody please help
> > me!!
>
>

Reporting Services SP2 and SQL Server SP3a

My company is preparing to install RS SP2. My SQL Servers are currently running SP3a. Is SQL Server SP4 required to run RS SP2? Thanks.

No, you do not need to upgrade to SP4 for any version of RS. It's a good idea, though. Big Smile

Reporting Services SP2

What is the general opinion about SP2? Is it safe to install?
I would like to install it to utilize the print feature but I don't want
to destroy anything as well.The main issue I have seen is some issues with using the printing. So far in
many cases having a recent print driver solves the problem (plus you need to
re-deploy for printing to work well).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bon733" <Bon@.nospam.com> wrote in message
news:O4HBAUmVFHA.1796@.TK2MSFTNGP15.phx.gbl...
> What is the general opinion about SP2? Is it safe to install?
> I would like to install it to utilize the print feature but I don't want
> to destroy anything as well.

Reporting Services SP1 Designer Cache Problem

Reporting Service SP1 provides an option to cache the data during
design time for preview, which seems to be making the preview to take
lot longer time than pre SP1.
This is what Reporting Services SP1 is doing:
During preview it is making a call to SQL and in between it is writing
into report data file, which is taking longer time just because it is
reading and writing into data file before even rendering.
Why can't it cache the data after it gets the entire data instead of
holding the sql connection or after rendering?
One of my reports is used to take 10 secs prior to SP1 now it is
taking 6 mins.
After turning of the configuration to false we started getting the
report in 10 secs.
Is there any resolution for this?
Thanks
RI have a couple of questions. Does this type of performance difference
occur for all reports or just this one? What is the structure of the data:
number of rows returned, etc. I would expect caching to take longer but not
in the magnitude you are describing.
The report is cached and rendered as we get the data (it is not buffered).
On the surface it seems quite in efficient to render the report and then
potentially round trip to the server again. Buffering is an issue since we
do not know the size of result set in advance.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"am_i_dotnet" <am_i_dotnet@.hotmail.com> wrote in message
news:ac7b2754.0407151240.2374c78b@.posting.google.com...
> Reporting Service SP1 provides an option to cache the data during
> design time for preview, which seems to be making the preview to take
> lot longer time than pre SP1.
> This is what Reporting Services SP1 is doing:
> During preview it is making a call to SQL and in between it is writing
> into report data file, which is taking longer time just because it is
> reading and writing into data file before even rendering.
> Why can't it cache the data after it gets the entire data instead of
> holding the sql connection or after rendering?
> One of my reports is used to take 10 secs prior to SP1 now it is
> taking 6 mins.
> After turning of the configuration to false we started getting the
> report in 10 secs.
> Is there any resolution for this?
> Thanks
> R|||There are around 20000+ records in this report and the report is in
tabular format.
I may not agree with you on "The report is cached and rendered as we
get the data". Because I observed the data file keep growing when I
tried to preview the report and report showed up only after the entire
data file created.
I know it is inefficient to make second round trip to server just to
cache the data but do we have any thoughts on using the data in the
report. I mean first render the report and cache the data
asynchronously from report data.
Thanks
R
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message news:<#dyED4qaEHA.3684@.TK2MSFTNGP09.phx.gbl>...
> I have a couple of questions. Does this type of performance difference
> occur for all reports or just this one? What is the structure of the data:
> number of rows returned, etc. I would expect caching to take longer but not
> in the magnitude you are describing.
> The report is cached and rendered as we get the data (it is not buffered).
> On the surface it seems quite in efficient to render the report and then
> potentially round trip to the server again. Buffering is an issue since we
> do not know the size of result set in advance.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "am_i_dotnet" <am_i_dotnet@.hotmail.com> wrote in message
> news:ac7b2754.0407151240.2374c78b@.posting.google.com...
> > Reporting Service SP1 provides an option to cache the data during
> > design time for preview, which seems to be making the preview to take
> > lot longer time than pre SP1.
> >
> > This is what Reporting Services SP1 is doing:
> > During preview it is making a call to SQL and in between it is writing
> > into report data file, which is taking longer time just because it is
> > reading and writing into data file before even rendering.
> >
> > Why can't it cache the data after it gets the entire data instead of
> > holding the sql connection or after rendering?
> >
> > One of my reports is used to take 10 secs prior to SP1 now it is
> > taking 6 mins.
> >
> > After turning of the configuration to false we started getting the
> > report in 10 secs.
> >
> > Is there any resolution for this?
> >
> > Thanks
> > R