Showing posts with label sp2. Show all posts

Friday, March 30, 2012

Reporting services unavailable after windows 2003 SP2 installed

I have installed windows server 2003 on one of our test boxes (prior to live) and found that reporting services is now unavailable.

When I browse to the report server I get

Service Unavailable

The event log reports several times

"A process serving application pool 'reportserver' terminated unexpectedly. The process id was '3500'. The process exit code was '0xffffffff'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

before the worker process is disabled:

"Application pool 'reportserver' is being automatically disabled due to a series of failures in the process(es) serving that application pool.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."

Has anyone seen similar behavior?

Stuart

"
A second reboot seems to have fixed this and (mysteriously enough) fixed terminal services too!

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.

Monday, March 26, 2012

Reporting Services Roles not seeing presenting AD dialog box

Hi,
We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS have
all patches applied. When we try and set the permissions on a report that
has been uploaded or created we are not able to specify domain users. This
causes the report not to be viewable by the end user we are testing with.
What does happen when you right mouse click on:
Report Server
Home
ReportName
Is you get the window for "Resouce Properties - Home/Reportname. If we then
click on the Add Group or User... button we are prompted with a dialog box
that has a free form text field with the prompt of "type the name of a
security group or user to which you want to give permissions". In all the
examples that we see on line as well as the Microsoft Events (webinars) it
show the AD dialog box prompt so that you can choose someone or something
from AD. In this case we can't. This then leaves us stuck.
We would prefer to run this in Integrated Security mode with Kerberos. We
have the SPN set although we don't need it because IIS and SQL are running on
the same box. We do have the SPN set because future reports will not use the
local database but rather another SQL database as their source for data.
Again the real problem is because we can't set domain or local users
correctly. It is as if somewhere it thinks we have sql authorization set.
Any pointers would be appreciated.You know something, I have never gotten AD to work "quite right" when using
a Windows XP machine - something to do with the behavior of IIS 5.0...
Have you tried this on a Windows Server 2003 machine? (I know that works for
sure). :)
=-Chris
"Fred Lobmeyer" <Lobmeyer@.myalias.postalias> wrote in message
news:FB36D3F8-979B-4864-A064-CE301DB875B2@.microsoft.com...
> Hi,
> We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS
> have
> all patches applied. When we try and set the permissions on a report that
> has been uploaded or created we are not able to specify domain users.
> This
> causes the report not to be viewable by the end user we are testing with.
> What does happen when you right mouse click on:
> Report Server
> Home
> ReportName
> Is you get the window for "Resouce Properties - Home/Reportname. If we
> then
> click on the Add Group or User... button we are prompted with a dialog box
> that has a free form text field with the prompt of "type the name of a
> security group or user to which you want to give permissions". In all the
> examples that we see on line as well as the Microsoft Events (webinars) it
> show the AD dialog box prompt so that you can choose someone or something
> from AD. In this case we can't. This then leaves us stuck.
> We would prefer to run this in Integrated Security mode with Kerberos. We
> have the SPN set although we don't need it because IIS and SQL are running
> on
> the same box. We do have the SPN set because future reports will not use
> the
> local database but rather another SQL database as their source for data.
> Again the real problem is because we can't set domain or local users
> correctly. It is as if somewhere it thinks we have sql authorization set.
> Any pointers would be appreciated.
>

Reporting Services Product Path

I have a few questions:
1.) Is there going to be a RS SP2?
2.) If yes, will it be released prior to 2005 and what can we expect?
We have spent alot of time and money on RS but so far its not giving us what
we want... Will we have to wait for VS 2005?Writes SAcanuck...
> 1.) Is there going to be a RS SP2?
I suspect so.
> 2.) If yes, will it be released prior to 2005
I suspect so.
> and what can we expect?
Not much has said about specifics yet, did you have some specific things are interested in? I can always ask and see what the powers that be what they want to say.
> We have spent alot of time and money on RS but so far its not giving us what
> we want... Will we have to wait for VS 2005?
I'd love to hear the specifics of what you're looking for...
Thanks,
Kent Tegels
MVP - SQL Server
The SSX FAQ & Blog:
http://tinyurl.com/6r4gb
Looking for XM, the GUI for SSX? See both:
http://tinyurl.com/4dfee and http://tinyurl.com/53hts
My Blog:
http://www.tegels.org/|||Hey Kent,
The one thing that has jumped out at me that would really take the Reporting
Services product up a notch against the other big ones is the implementation
of Aggregate of Aggregates.
Cheers
Gavin
ps. Did you mean released prior to SQL Server 2005, or the year 2005?
"Kent Tegels (MVP)" <kent@.tegels.org> wrote in message
news:OXiuNm7uEHA.2288@.TK2MSFTNGP09.phx.gbl...
> Writes SAcanuck...
>> 1.) Is there going to be a RS SP2?
> I suspect so.
>> 2.) If yes, will it be released prior to 2005
> I suspect so.
>> and what can we expect?
> Not much has said about specifics yet, did you have some specific things
> are interested in? I can always ask and see what the powers that be what
> they want to say.
>> We have spent alot of time and money on RS but so far its not giving us
>> what
>> we want... Will we have to wait for VS 2005?
> I'd love to hear the specifics of what you're looking for...
> Thanks,
> Kent Tegels
> MVP - SQL Server
> The SSX FAQ & Blog:
> http://tinyurl.com/6r4gb
> Looking for XM, the GUI for SSX? See both:
> http://tinyurl.com/4dfee and http://tinyurl.com/53hts
> My Blog:
> http://www.tegels.org/|||A "Data" tab in the report designer that does not reformat my SQL!! :)
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 26 Oct 2004 19:11:47 -0500, "Kent Tegels (MVP)"
<kent@.tegels.org> wrote:
>Writes SAcanuck...
>> 1.) Is there going to be a RS SP2?
>I suspect so.
>> 2.) If yes, will it be released prior to 2005
>I suspect so.
>> and what can we expect?
>Not much has said about specifics yet, did you have some specific things are interested in? I can always ask and see what the powers that be what they want to say.
>> We have spent alot of time and money on RS but so far its not giving us what
>> we want... Will we have to wait for VS 2005?
>I'd love to hear the specifics of what you're looking for...
>Thanks,
>Kent Tegels
>MVP - SQL Server
>The SSX FAQ & Blog:
>http://tinyurl.com/6r4gb
>Looking for XM, the GUI for SSX? See both:
>http://tinyurl.com/4dfee and http://tinyurl.com/53hts
>My Blog:
>http://www.tegels.org/|||Thanks for the reponse Kent. I agree with most of the suggestions on the
forum (search for SP2).
At the very least we would like to a print feature, a date select parameter,
and multi select parameters.
"Kent Tegels (MVP)" wrote:
> Writes SAcanuck...
> > 1.) Is there going to be a RS SP2?
> I suspect so.
> > 2.) If yes, will it be released prior to 2005
> I suspect so.
> > and what can we expect?
> Not much has said about specifics yet, did you have some specific things are interested in? I can always ask and see what the powers that be what they want to say.
> > We have spent alot of time and money on RS but so far its not giving us what
> > we want... Will we have to wait for VS 2005?
> I'd love to hear the specifics of what you're looking for...
> Thanks,
> Kent Tegels
> MVP - SQL Server
> The SSX FAQ & Blog:
> http://tinyurl.com/6r4gb
> Looking for XM, the GUI for SSX? See both:
> http://tinyurl.com/4dfee and http://tinyurl.com/53hts
> My Blog:
> http://www.tegels.org/
>|||In response to a question about client side printing I got the following
response from MS: "We currently plan to address this in SP2 of SQL Server
2000 Reporting Services. Analogous functionality will be available in SQL
Server 2005. "
I don't know anything about the others for SP2 but the printing will be a
welcome addition.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:6C74C697-C6F4-4C93-8BFB-7866FA9D9CF0@.microsoft.com...
> Thanks for the reponse Kent. I agree with most of the suggestions on the
> forum (search for SP2).
> At the very least we would like to a print feature, a date select
parameter,
> and multi select parameters.
> "Kent Tegels (MVP)" wrote:
> > Writes SAcanuck...
> > > 1.) Is there going to be a RS SP2?
> > I suspect so.
> > > 2.) If yes, will it be released prior to 2005
> > I suspect so.
> > > and what can we expect?
> > Not much has said about specifics yet, did you have some specific things
are interested in? I can always ask and see what the powers that be what
they want to say.
> >
> > > We have spent alot of time and money on RS but so far its not giving
us what
> > > we want... Will we have to wait for VS 2005?
> > I'd love to hear the specifics of what you're looking for...
> >
> > Thanks,
> > Kent Tegels
> > MVP - SQL Server
> >
> > The SSX FAQ & Blog:
> > http://tinyurl.com/6r4gb
> > Looking for XM, the GUI for SSX? See both:
> > http://tinyurl.com/4dfee and http://tinyurl.com/53hts
> > My Blog:
> > http://www.tegels.org/
> >

Reporting Services process Analysis Services cube with 100% load

Hi all,

I use SQL Server 2005 Developer Edition version 9.00.2153 on Windows XP SP2.

I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds.

When I build Reporting Services project with same cubes as data sources

(on same computer), CPU was increased to 100% for more than 30 minutes

(process msmdsrv.exe) ... and I interpurt it.

Transfer projects to Windows 2003 SP1, but same result.
Do you have any idea what happens and how can I fix it ?

Best regards,

Siol En

OK, what happens.

I decreased attributes number (join some of them and my cubes become a little bit ugly), processing (for OLAP) a little bit increased (from 5-10 to 8-15 seconds).

Reporting Services proceed new cube for less than 2 minutes (bigger one) - waiting for congratulations

Now a big fight will be with a fact that Reporting Services didn't support "(All)" hierarchy member

Any help will be welcome, because my aggregation functions used exactly that property ... - "Percentage of Parent"; "Average", "Standart deviation"

Best regards,

Siol En

Reporting Services process Analysis Services cube with 100% load

Hi all,

I use SQL Server 2005 Developer Edition version 9.00.2153 on Windows XP SP2.

I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds.

When I build Reporting Services project with same cubes as data sources

(on same computer), CPU was increased to 100% for more than 30 minutes

(process msmdsrv.exe) ... and I interpurt it.

Transfer projects to Windows 2003 SP1, but same result.
Do you have any idea what happens and how can I fix it ?

Best regards,

Siol En

OK, what happens.

I decreased attributes number (join some of them and my cubes become a little bit ugly), processing (for OLAP) a little bit increased (from 5-10 to 8-15 seconds).

Reporting Services proceed new cube for less than 2 minutes (bigger one) - waiting for congratulations

Now a big fight will be with a fact that Reporting Services didn't support "(All)" hierarchy member

Any help will be welcome, because my aggregation functions used exactly that property ... - "Percentage of Parent"; "Average", "Standart deviation"

Best regards,

Siol En

Friday, March 23, 2012

Reporting Services Print Error

We installed Reporting Services and SP2 on our customer portal for
reporting of their test results. This determines how our customers are
paid and is of extreme importance to them. We developed Reporting Services
reports and deployed them just this past week.
The reports look great and have been well received. However, there are
two glaring problems. First, whenever they attempt to print the report using
the print icon, the first page of the report prints and the following error
pops up
in a message box "An error occurred during printing. (0x80004005)". Second,
when we attempt to export the reports to PDF format and print them, every
other
page is a blank page.
Having read numerous posts about these problems, its clear that these are
issues that effect many installations of Reporting Services. Please, this
is clearly
not an isolated incident -- and the first post was in May over 6 months ago.
We would very much appreciate a resolution to this issue! It has a tremendous
impact on customer satisfaction with our production reports.
Thank you in advance for your prompt attention in this manner!
--
Grande ApplicationsAs far as using the print icon, when a user first access a page an install
of a dll is attempt. Depending on the users permissions and serurity
setting, the install will succeed or fail. If it fails the first time there
is ni attempt made to install it any susequent time. The dll needs to be
installed manually.
I do not know about the export to PDF.
Good Luck.
"GrandeApps" <grande@.newsgroup.nospam> wrote in message
news:F047D52D-C13F-4A62-8924-2D98A45E7ED9@.microsoft.com...
> We installed Reporting Services and SP2 on our customer portal for
> reporting of their test results. This determines how our customers are
> paid and is of extreme importance to them. We developed Reporting
> Services
> reports and deployed them just this past week.
> The reports look great and have been well received. However, there are
> two glaring problems. First, whenever they attempt to print the report
> using
> the print icon, the first page of the report prints and the following
> error
> pops up
> in a message box "An error occurred during printing. (0x80004005)".
> Second,
> when we attempt to export the reports to PDF format and print them, every
> other
> page is a blank page.
> Having read numerous posts about these problems, its clear that these are
> issues that effect many installations of Reporting Services. Please, this
> is clearly
> not an isolated incident -- and the first post was in May over 6 months
> ago.
> We would very much appreciate a resolution to this issue! It has a
> tremendous
> impact on customer satisfaction with our production reports.
> Thank you in advance for your prompt attention in this manner!
> --
> Grande Applications|||We have been able to get the dll to install, but are still getting the error
messages. We are even getting the error when attempting to print through the
report manager.
--
Grande Applications
"SSVette" wrote:
> As far as using the print icon, when a user first access a page an install
> of a dll is attempt. Depending on the users permissions and serurity
> setting, the install will succeed or fail. If it fails the first time there
> is ni attempt made to install it any susequent time. The dll needs to be
> installed manually.
> I do not know about the export to PDF.
> Good Luck.
> "GrandeApps" <grande@.newsgroup.nospam> wrote in message
> news:F047D52D-C13F-4A62-8924-2D98A45E7ED9@.microsoft.com...
> > We installed Reporting Services and SP2 on our customer portal for
> > reporting of their test results. This determines how our customers are
> > paid and is of extreme importance to them. We developed Reporting
> > Services
> > reports and deployed them just this past week.
> >
> > The reports look great and have been well received. However, there are
> > two glaring problems. First, whenever they attempt to print the report
> > using
> > the print icon, the first page of the report prints and the following
> > error
> > pops up
> > in a message box "An error occurred during printing. (0x80004005)".
> > Second,
> > when we attempt to export the reports to PDF format and print them, every
> > other
> > page is a blank page.
> >
> > Having read numerous posts about these problems, its clear that these are
> > issues that effect many installations of Reporting Services. Please, this
> > is clearly
> > not an isolated incident -- and the first post was in May over 6 months
> > ago.
> >
> > We would very much appreciate a resolution to this issue! It has a
> > tremendous
> > impact on customer satisfaction with our production reports.
> >
> > Thank you in advance for your prompt attention in this manner!
> > --
> > Grande Applications
>
>|||Hi Grande,
Thanks for your post.
From your descriptions, I understood you and your customer's conern as below
1. When your customer is print the Report from Report toolbar, it won't
work and report the error message "An error occurred during printing.
(0x80004005)".
2. If you are rendering reports to PDF format and then print, it will print
a blank page between every pages.
If I have misunderstood your concern, please feel free to point it out.
Based on my knowledge, please perform the steps below and let me know the
results
1. When it report the error message "An error occurred during printing.
(0x80004005)", would you please check the Reporting Services logs for more
detailed information? Reporting Services logs are located at
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
2. Is it possible for you to reproduce the customer's behavior on your
side?
3. What's the print and its driver your customers are using? Might it be
the issue for customer's hardware? Does the customer could print other
documents smoothly?
4. For your rendered PDF format, does it looks fine if you open it with
Acrobat Reader? Will you also see the blank pages between every page in PDF?
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.

Wednesday, March 21, 2012

Reporting Services on MOSS

After intalling SP2 and RS add-in when I try Grant Database Acces from
Configure Reporting Services Integration I get "A new member could not be
added to a local group because the member has the wrong account type".
I am on a domain controller.
Any ideas ?Who are you logged in as when you run the configuration?
daw
"Sorin Sandu" wrote:
> After intalling SP2 and RS add-in when I try Grant Database Acces from
> Configure Reporting Services Integration I get "A new member could not be
> added to a local group because the member has the wrong account type".
> I am on a domain controller.
> Any ideas ?
>sql

Reporting Services not showing in central admin

I downloaded and installed SQL Server 2005 SP2 update on my reporting services server. I think downloaded and installed the share point reporting services admin to my share point dev server. I open up the central administration and there is no reporting services menu option under the Application menu. The sharepoint server is a farm with backend database on one server and all the web apps on the other (where the add-in was installed). The reporting server is a separate server running its own instance of SQL 2005.

Am I missing something with this setup?

Make sure the feature is activated by checking whether "Report Server Integration Feature" is activated by going to Site Actions->Site Settings-> Site Collection features.

Note: You may need to be site owner of the Central Admin web site in order to view the "Site Collection features" link.

HTH,
Prash

Tuesday, March 20, 2012

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Friday, March 30, 2012

Service Unavailable

Wednesday, March 28, 2012

Monday, March 26, 2012

Friday, March 23, 2012

Wednesday, March 21, 2012

Tuesday, March 20, 2012

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Blog Archive

About Me