SQL Remove Old Backups: unable

Showing posts with label unable. Show all posts

Thursday, March 8, 2012

20536: Unable to logon server

I have VB 6.0 Application calling Crystal Report 7.0 based on SQL Server 2000 datbase.

I use the LogonServer method with parameter p2ssql.dll to make the database connection.

I have used the above method for my Crystal Report for last 6 years and worked fine until now but now I get the "20536: Unable to logon server " in few XP OS machines.

This again works in the test XP machine I have used, I have almost tried all things I can try to fix the problem.

Does anyone have similar problems and if so how they dealt with it.

Any help in this regard is highly appreciated.

ThanksHigher security levels in XP, at a guess.
Do you have subreports??
If so, you may find that before your OS was allowing subreports to use login info from parent report, but now is breaking because OS demands you supply login info for each subreport.
In which case. iterate thru subreports collection and supply same login info to each subreport.

dave

Tuesday, March 6, 2012

2005 URL ris:format=PDF not working

Using the new reporting services I am unable to get the report to go straight
to a pdf...I can select export and it goes fine...below is my url:
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
what am ai doing wrong?Is everything on one machine? Or are you using IE from one machine and RS is
on another?
I was just doing this myself (with CSV instead of PDF) and I found that the
global variable Globals!ReportServerUrl is putting in localhost instead of
the server name (I see below that you have localhost which is why I was
wondering if you are seeing the same issue). If I go to the server and use a
browser from there then my jump to URL works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> Using the new reporting services I am unable to get the report to go
> straight
> to a pdf...I can select export and it goes fine...below is my url:
> http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> what am ai doing wrong?|||yes I am on my development machine with the server and it does not work.
"Bruce L-C [MVP]" wrote:
> Is everything on one machine? Or are you using IE from one machine and RS is
> on another?
> I was just doing this myself (with CSV instead of PDF) and I found that the
> global variable Globals!ReportServerUrl is putting in localhost instead of
> the server name (I see below that you have localhost which is why I was
> wondering if you are seeing the same issue). If I go to the server and use a
> browser from there then my jump to URL works.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> > Using the new reporting services I am unable to get the report to go
> > straight
> > to a pdf...I can select export and it goes fine...below is my url:
> >
> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >
> > what am ai doing wrong?
>
>|||Here is a working URL. The folder is called Demo. The report is called Sales
Order 2 Two parameters StartDate and EndDate
Note that parameters are case sensitive. The %20 is the encoding for space.
Rendering is the default so you can leave it off the line.
Try to match my pattern here and hopefully it will work for you. The user
will still have to click open, it will not automatically open
http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> yes I am on my development machine with the server and it does not work.
>
> "Bruce L-C [MVP]" wrote:
>> Is everything on one machine? Or are you using IE from one machine and RS
>> is
>> on another?
>> I was just doing this myself (with CSV instead of PDF) and I found that
>> the
>> global variable Globals!ReportServerUrl is putting in localhost instead
>> of
>> the server name (I see below that you have localhost which is why I was
>> wondering if you are seeing the same issue). If I go to the server and
>> use a
>> browser from there then my jump to URL works.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> > Using the new reporting services I am unable to get the report to go
>> > straight
>> > to a pdf...I can select export and it goes fine...below is my url:
>> >
>> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >
>> > what am ai doing wrong?
>>|||Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
What I am looking for is to simulate the report server actions of selecting
the PDF format and clicking the export link,
opens another window and its converted to the PDF format but already open to
the PDF viewer.
Then if the user wants to save it from there they can, butthe ofrmatting
seems more stable this way.
Is this not possible with the url?
"Bruce L-C [MVP]" wrote:
> Here is a working URL. The folder is called Demo. The report is called Sales
> Order 2 Two parameters StartDate and EndDate
> Note that parameters are case sensitive. The %20 is the encoding for space.
> Rendering is the default so you can leave it off the line.
> Try to match my pattern here and hopefully it will work for you. The user
> will still have to click open, it will not automatically open
> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> > yes I am on my development machine with the server and it does not work.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Is everything on one machine? Or are you using IE from one machine and RS
> >> is
> >> on another?
> >>
> >> I was just doing this myself (with CSV instead of PDF) and I found that
> >> the
> >> global variable Globals!ReportServerUrl is putting in localhost instead
> >> of
> >> the server name (I see below that you have localhost which is why I was
> >> wondering if you are seeing the same issue). If I go to the server and
> >> use a
> >> browser from there then my jump to URL works.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> > Using the new reporting services I am unable to get the report to go
> >> > straight
> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >
> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >
> >> > what am ai doing wrong?
> >>
> >>
> >>
>
>|||Export is working differently in RS 2005. Previously it gave you the
open/save dialog. Now it is opening it up in the browser. It seems like if
the export functionality can open it up in the browser then we should be
able to do it with the URL. I tried several things and cannot get it to
happen. I will use my MS contacts to see if there is a way to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> What I am looking for is to simulate the report server actions of
> selecting
> the PDF format and clicking the export link,
> opens another window and its converted to the PDF format but already open
> to
> the PDF viewer.
> Then if the user wants to save it from there they can, butthe ofrmatting
> seems more stable this way.
> Is this not possible with the url?
> "Bruce L-C [MVP]" wrote:
>> Here is a working URL. The folder is called Demo. The report is called
>> Sales
>> Order 2 Two parameters StartDate and EndDate
>> Note that parameters are case sensitive. The %20 is the encoding for
>> space.
>> Rendering is the default so you can leave it off the line.
>> Try to match my pattern here and hopefully it will work for you. The user
>> will still have to click open, it will not automatically open
>> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> > yes I am on my development machine with the server and it does not
>> > work.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Is everything on one machine? Or are you using IE from one machine and
>> >> RS
>> >> is
>> >> on another?
>> >>
>> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> that
>> >> the
>> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> instead
>> >> of
>> >> the server name (I see below that you have localhost which is why I
>> >> was
>> >> wondering if you are seeing the same issue). If I go to the server and
>> >> use a
>> >> browser from there then my jump to URL works.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> > Using the new reporting services I am unable to get the report to go
>> >> > straight
>> >> > to a pdf...I can select export and it goes fine...below is my url:
>> >> >
>> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >
>> >> > what am ai doing wrong?
>> >>
>> >>
>> >>
>>|||That would be Great!
THANKS!
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||any luck on this...?
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I've sent an email. No response yet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> any luck on this...?
> "Bruce L-C [MVP]" wrote:
>> Export is working differently in RS 2005. Previously it gave you the
>> open/save dialog. Now it is opening it up in the browser. It seems like
>> if
>> the export functionality can open it up in the browser then we should be
>> able to do it with the URL. I tried several things and cannot get it to
>> happen. I will use my MS contacts to see if there is a way to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
>> > Thanks, that works to get me a SAVEAS dialog with the pdf file
>> > perfectly!
>> >
>> > What I am looking for is to simulate the report server actions of
>> > selecting
>> > the PDF format and clicking the export link,
>> > opens another window and its converted to the PDF format but already
>> > open
>> > to
>> > the PDF viewer.
>> >
>> > Then if the user wants to save it from there they can, butthe
>> > ofrmatting
>> > seems more stable this way.
>> >
>> > Is this not possible with the url?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Here is a working URL. The folder is called Demo. The report is called
>> >> Sales
>> >> Order 2 Two parameters StartDate and EndDate
>> >>
>> >> Note that parameters are case sensitive. The %20 is the encoding for
>> >> space.
>> >> Rendering is the default so you can leave it off the line.
>> >>
>> >> Try to match my pattern here and hopefully it will work for you. The
>> >> user
>> >> will still have to click open, it will not automatically open
>> >>
>> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> >> > yes I am on my development machine with the server and it does not
>> >> > work.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Is everything on one machine? Or are you using IE from one machine
>> >> >> and
>> >> >> RS
>> >> >> is
>> >> >> on another?
>> >> >>
>> >> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> >> that
>> >> >> the
>> >> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> >> instead
>> >> >> of
>> >> >> the server name (I see below that you have localhost which is why I
>> >> >> was
>> >> >> wondering if you are seeing the same issue). If I go to the server
>> >> >> and
>> >> >> use a
>> >> >> browser from there then my jump to URL works.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> >> > Using the new reporting services I am unable to get the report to
>> >> >> > go
>> >> >> > straight
>> >> >> > to a pdf...I can select export and it goes fine...below is my
>> >> >> > url:
>> >> >> >
>> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >> >
>> >> >> > what am ai doing wrong?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks!
"Bruce L-C [MVP]" wrote:
> I've sent an email. No response yet.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> > any luck on this...?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Export is working differently in RS 2005. Previously it gave you the
> >> open/save dialog. Now it is opening it up in the browser. It seems like
> >> if
> >> the export functionality can open it up in the browser then we should be
> >> able to do it with the URL. I tried several things and cannot get it to
> >> happen. I will use my MS contacts to see if there is a way to do this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> >> > Thanks, that works to get me a SAVEAS dialog with the pdf file
> >> > perfectly!
> >> >
> >> > What I am looking for is to simulate the report server actions of
> >> > selecting
> >> > the PDF format and clicking the export link,
> >> > opens another window and its converted to the PDF format but already
> >> > open
> >> > to
> >> > the PDF viewer.
> >> >
> >> > Then if the user wants to save it from there they can, butthe
> >> > ofrmatting
> >> > seems more stable this way.
> >> >
> >> > Is this not possible with the url?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Here is a working URL. The folder is called Demo. The report is called
> >> >> Sales
> >> >> Order 2 Two parameters StartDate and EndDate
> >> >>
> >> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> >> space.
> >> >> Rendering is the default so you can leave it off the line.
> >> >>
> >> >> Try to match my pattern here and hopefully it will work for you. The
> >> >> user
> >> >> will still have to click open, it will not automatically open
> >> >>
> >> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> >> > yes I am on my development machine with the server and it does not
> >> >> > work.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Is everything on one machine? Or are you using IE from one machine
> >> >> >> and
> >> >> >> RS
> >> >> >> is
> >> >> >> on another?
> >> >> >>
> >> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> >> that
> >> >> >> the
> >> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> >> instead
> >> >> >> of
> >> >> >> the server name (I see below that you have localhost which is why I
> >> >> >> was
> >> >> >> wondering if you are seeing the same issue). If I go to the server
> >> >> >> and
> >> >> >> use a
> >> >> >> browser from there then my jump to URL works.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> >> > Using the new reporting services I am unable to get the report to
> >> >> >> > go
> >> >> >> > straight
> >> >> >> > to a pdf...I can select export and it goes fine...below is my
> >> >> >> > url:
> >> >> >> >
> >> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >> >
> >> >> >> > what am ai doing wrong?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Friday, February 24, 2012

2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file

This is posted for others who have
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Installer
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/support/kb/articles/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Installer to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community 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.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
>> This is posted for others who have
>> If this error occurs here is what worked for me. I hope it may work for
>> you but am not sure.
>> In my case I had SQL Express 2005 Installer on my system as well as I
run
>> both (one for development, one for production).
>> Shut down all SQL related services manually.
>> I set registry permissions on
>> Software\Policies\Microsoft\Windows\Installer to include the account
that
>> is doing the install with Full Control. Click Advanced and make sure
>> everything is selected.
>> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
>> Setup Files Installer and the SQL Express Installer. I then reinstalled
>> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
>> don't do this you won't be able to use the SP.
>> Q290301 OFFXP: Windows Installer CleanUp Utility
>> http://support.microsoft.com/support/kb/articles/q290/3/01.asp
>> I then reinstalled the SP and it worked.
>> Hope this helps somebody.
>> Special thanks to Peter Yang of Microsoft for his invaluable assistance
on
>> this issue.
>> --
>> Get a powerful web, database, application, and email hosting with KJM
>> Solutions
>> http://www.kjmsolutions.com
>>
>>
>
>

2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file

This is posted for others who have
If this error occurs here is what worked for me. I hope it may work for you
but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run
both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Inst
aller
to include the account that is doing the install with Full Control. Click
Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and removed the SQL 2005 Setup
Files Installer and the SQL Express Installer. I then reinstalled the SQL
Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't don't do
this you won't be able to use the SP.
Q290301 OFFXP: Windows Installer CleanUp Utility
http://support.microsoft.com/suppor...s/q290/3/01.asp
I then reinstalled the SP and it worked.
Hope this helps somebody.
Special thanks to Peter Yang of Microsoft for his invaluable assistance on
this issue.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.comForgot to mention this is on a Windows Server 2003 SP1 platform.
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
"vbnetdev" <vbnetdev@.community.nospam> wrote in message
news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> This is posted for others who have
> If this error occurs here is what worked for me. I hope it may work for
> you but am not sure.
> In my case I had SQL Express 2005 Installer on my system as well as I run
> both (one for development, one for production).
> Shut down all SQL related services manually.
> I set registry permissions on
> Software\Policies\Microsoft\Windows\Inst
aller to include the account that
> is doing the install with Full Control. Click Advanced and make sure
> everything is selected.
> I downloaded and ran the SQL Install Cleanup and removed the SQL 2005
> Setup Files Installer and the SQL Express Installer. I then reinstalled
> the SQL Setup Files (ONLY!!!!!) from my SQL Server 2005 CD. If you don't
> don't do this you won't be able to use the SP.
> Q290301 OFFXP: Windows Installer CleanUp Utility
> http://support.microsoft.com/suppor...s/q290/3/01.asp
> I then reinstalled the SP and it worked.
> Hope this helps somebody.
> Special thanks to Peter Yang of Microsoft for his invaluable assistance on
> this issue.
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>|||Hi,
Thanks for your feedback. This information has been added to Microsoft's
database. Your solution will benefit many other users, and we really value
having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community 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.
--
>From: "vbnetdev" <vbnetdev@.community.nospam>
>References: <OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl>
>Subject: Re: 2005 SP 1 Install Failure Solution - Unable to install
Windows Installer MSP file
>Date: Thu, 27 Apr 2006 10:15:48 -0500
>Lines: 50
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uQdG71gaGHA.3740@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 63-252-11-73.ip.mcleodusa.net 63.252.11.73
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429460
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Forgot to mention this is on a Windows Server 2003 SP1 platform.
>--
>Get a powerful web, database, application, and email hosting with KJM
>Solutions
>http://www.kjmsolutions.com
>
>"vbnetdev" <vbnetdev@.community.nospam> wrote in message
>news:OdGUsVgaGHA.3304@.TK2MSFTNGP04.phx.gbl...
run[vbcol=seagreen]
that[vbcol=seagreen]
on[vbcol=seagreen]
>
>

2005 Reporting Services Configuration Issues

Hi All -

I am trying to configure reporting services on virtual machine but unable to succeed. I never touched this topic before SQL Server 2005. The left hand side options in Reporting Services Configuration Manager such as Server Status, Virtual Directories, Web Identity works fine but it fails in Database Setup section

Here are the details:

AppServer: SQL Server 2005 Reporting Services & Client components build# 2153 (with SP1 & SP1 hotfix)

going to apply SP2 and Add-on component after the configuration

DBServer: SQL Server 2005 Database Services & Client components build# 2153 (with SP1 & SP1 hotfix)

OS: Windows 2003 Server with SP1

IIS version on AppServer: 6

I have SQL 2005 Reporting services and 2005 Database Engine on 2 different machines.

Here is the error message I am receiving when I try to apply the script in "Database Setup" section of Reporting Services Configuration Manager

It did not log any errors in SQL Server however it shows a warning message in Event Log

Event Log message - "The RSReportServer.config file has been modified."

Configuration Manager error message - It shows me "Create a Grants Rights Script" task failed

"System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)"

I have captured the screenshot, let me know if I can send this.

One of my friends suggested the following and I have tried the first option but could not work - Option I)

Our account that is used for database connection should have

1) public and RSExecRole roles for the ReportServerDatabase.

2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases.

Else - Option II)

we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission.

Did anyone face this problem? how should I resolve this?

Anyone have steps to follow as I feel of missing something in the configuration steps?

Any information/ suggestions/ pointer on this are higly appreciated.

Thanks in advance !!

-Satya

We were getting this error and found that the dbo.role was not the owner of the dbo.schema. When we made that change we were able to update the database. When we originally installed and had problems with the remote database we had to make sure that database had windows authentication only.|||

TWe also escalated this issue to Microsoft Product Support Service and they suggested the following:

The account that is used for database connection should have

1) public and RSExecRole roles for the ReportServerDatabase.

2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases.

Else we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission.

but before we had a work around however you will still find the script showing error in Reporting Services configuration manager.

We have generated the login script and executed thru' Management Studio. Verified the account permission as mentioned above.

Just ignore the error message that you see in Configuration Manager -

Configuration Manager error message - "System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))