rsExecutionNotFound !

I have been frequetly visiting your blogs with a solution for rsExecutionNotFound. I used johngaallard's script to extend the accesstimeout(to 6000 ) eventhough that was not the base of the problem.

My Reports run in less than 15 sec (max). I have enabled caching for about 12 hours ( there are nightly updates) using [Cache a temporary copy of the report. Expire copy of report after a number of minutes option])

The reports are rendered using a ReportViewerControl in an ASP.Net2.0 web application.(The report is rendered as PDF and then shown in another IFrame using Adobe plugin).The ASP application session timeout is 100mts.

The problem i am facing is that after sometime, the rsExecutionNotfound starts occuring for some report with a specific set of parameters. No amount of rerunning the report will stop. The same report with different parameters renders fine. The only way to stop this is to set the cache option 'Do not cache temporary copies of this report'.

If i set ''Do not cache temporary copies of this report'' there are no errors. I am doing caching mainly to bring down report rendering from 15 sec to 2-3 secs. I am using PDF format .

I am now thinking of working around by trying to catch the Exception that occurs and trying to re-render the report. If this is the only way, how can i do it.

I had fought fiercely to use SSRS and now I am in a fix
Any help is appreciated.
Thanks,
Saj

You probably want to post this in the reporting services forum. There are many more experts in that area there.

RS.EXE XServer Calls

I have a short and simple RSS script which renders a report and writes the
output to disk. When I run the script while logged on, as myself, to the RS
Server the script works as desired.
When I run the script from my development machine I receive the error:
>>The report server cannot open a connection to the report server database.
A connection to the database is required for
>>all requests and processing.
what am I missing here?
I am using
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
to establish who I am to the webservice and
using the same endpoint in both instances (i.e. http:\\Server1\reportserver)
Authentication on the web site is set to "integrated" only.
The rs database is on a seperate machine from the RS Web Server/Web Service.
thanks,
dlrHello Dennis,
To understand the issue better, I'd like to know the following information:
1. Is RS installed on only on one specifc server? It seems that you can run
the RSS script properly on the console of the RS server.
2. Which account did you log on to development machine? Did you use the
same domain account as that on RS server?
3. Is the development machine in the same doamin of the RS server?
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| Subject: RS.EXE XServer Calls
| Date: Thu, 21 Apr 2005 14:47:01 -0400
| Lines: 25
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| Message-ID: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41436
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a short and simple RSS script which renders a report and writes the
| output to disk. When I run the script while logged on, as myself, to the
RS
| Server the script works as desired.
| When I run the script from my development machine I receive the error:
| >>The report server cannot open a connection to the report server
database.
| A connection to the database is required for
| >>all requests and processing.
|
| what am I missing here?
|
| I am using
| rs.Credentials = System.Net.CredentialCache.DefaultCredentials
| to establish who I am to the webservice and
|
| using the same endpoint in both instances (i.e.
http:\\Server1\reportserver)
|
| Authentication on the web site is set to "integrated" only.
|
| The rs database is on a seperate machine from the RS Web Server/Web
Service.
|
|
| thanks,
| dlr
|
|
||||Thank you Peter
Answers:
1) RS is installed on both a development server (win2003) AND installed
seperately on a developer machine
2) Same account used to test on both machines
3) Same domain
Note: I wrote a small C# program to do the same "work" as the rss script and
this program runs correctly from both
the development server console AND from the developer machine.
we are stumped!
dlr
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl...
> Hello Dennis,
> To understand the issue better, I'd like to know the following
information:
> 1. Is RS installed on only on one specifc server? It seems that you can
run
> the RSS script properly on the console of the RS server.
> 2. Which account did you log on to development machine? Did you use the
> same domain account as that on RS server?
> 3. Is the development machine in the same doamin of the RS server?
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>
> --
> | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | Subject: RS.EXE XServer Calls
> | Date: Thu, 21 Apr 2005 14:47:01 -0400
> | Lines: 25
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | Message-ID: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:41436
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I have a short and simple RSS script which renders a report and writes
the
> | output to disk. When I run the script while logged on, as myself, to
the
> RS
> | Server the script works as desired.
> | When I run the script from my development machine I receive the error:
> | >>The report server cannot open a connection to the report server
> database.
> | A connection to the database is required for
> | >>all requests and processing.
> |
> | what am I missing here?
> |
> | I am using
> | rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> | to establish who I am to the webservice and
> |
> | using the same endpoint in both instances (i.e.
> http:\\Server1\reportserver)
> |
> | Authentication on the web site is set to "integrated" only.
> |
> | The rs database is on a seperate machine from the RS Web Server/Web
> Service.
> |
> |
> | thanks,
> | dlr
> |
> |
> |
>|||Hello Dennis,
It is a weird. Can you reproduce the issue consistently?
You may want to check the logs in the following folder to see if there is
any related errors
D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Also, is the reportserver databases has the default name "reportserver" and
"reportservertempdb"?
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| References: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
<sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: RS.EXE XServer Calls
| Date: Fri, 22 Apr 2005 09:32:05 -0400
| Lines: 101
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| Message-ID: <eG8KE9zRFHA.3356@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41520
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thank you Peter
| Answers:
| 1) RS is installed on both a development server (win2003) AND installed
| seperately on a developer machine
| 2) Same account used to test on both machines
| 3) Same domain
|
| Note: I wrote a small C# program to do the same "work" as the rss script
and
| this program runs correctly from both
| the development server console AND from the developer machine.
|
| we are stumped!
|
|
| dlr
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl...
| > Hello Dennis,
| >
| > To understand the issue better, I'd like to know the following
| information:
| >
| > 1. Is RS installed on only on one specifc server? It seems that you can
| run
| > the RSS script properly on the console of the RS server.
| >
| > 2. Which account did you log on to development machine? Did you use the
| > same domain account as that on RS server?
| >
| > 3. Is the development machine in the same doamin of the RS server?
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| >
| > --
| > | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| > | Subject: RS.EXE XServer Calls
| > | Date: Thu, 21 Apr 2005 14:47:01 -0400
| > | Lines: 25
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| > | Message-ID: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:41436
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I have a short and simple RSS script which renders a report and writes
| the
| > | output to disk. When I run the script while logged on, as myself, to
| the
| > RS
| > | Server the script works as desired.
| > | When I run the script from my development machine I receive the error:
| > | >>The report server cannot open a connection to the report server
| > database.
| > | A connection to the database is required for
| > | >>all requests and processing.
| > |
| > | what am I missing here?
| > |
| > | I am using
| > | rs.Credentials = System.Net.CredentialCache.DefaultCredentials
| > | to establish who I am to the webservice and
| > |
| > | using the same endpoint in both instances (i.e.
| > http:\\Server1\reportserver)
| > |
| > | Authentication on the web site is set to "integrated" only.
| > |
| > | The rs database is on a seperate machine from the RS Web Server/Web
| > Service.
| > |
| > |
| > | thanks,
| > | dlr
| > |
| > |
| > |
| >
|
|
||||Peter,
We see no errors in the logs and db names are standard. Can you tell me
if this is a supported method of RS.exe.:
Machine1: Developer Machine: Report service installed
Machine 2: Production Web Server: Report Service installed
Calling RS.exe from Machine1 calling into the report service on Machine 2.
We note again that our sample C# program works correctly across machines.
any insight will be appreciated
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:zST6p3WSFHA.18944@.TK2MSFTNGXA01.phx.gbl...
> Hello Dennis,
> It is a weird. Can you reproduce the issue consistently?
> You may want to check the logs in the following folder to see if there is
> any related errors
> D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
> Also, is the reportserver databases has the default name "reportserver"
and
> "reportservertempdb"?
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | References: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
> <sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl>
> | Subject: Re: RS.EXE XServer Calls
> | Date: Fri, 22 Apr 2005 09:32:05 -0400
> | Lines: 101
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | Message-ID: <eG8KE9zRFHA.3356@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:41520
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thank you Peter
> | Answers:
> | 1) RS is installed on both a development server (win2003) AND installed
> | seperately on a developer machine
> | 2) Same account used to test on both machines
> | 3) Same domain
> |
> | Note: I wrote a small C# program to do the same "work" as the rss script
> and
> | this program runs correctly from both
> | the development server console AND from the developer machine.
> |
> | we are stumped!
> |
> |
> | dlr
> |
> |
> | "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> | news:sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl...
> | > Hello Dennis,
> | >
> | > To understand the issue better, I'd like to know the following
> | information:
> | >
> | > 1. Is RS installed on only on one specifc server? It seems that you
can
> | run
> | > the RSS script properly on the console of the RS server.
> | >
> | > 2. Which account did you log on to development machine? Did you use
the
> | > same domain account as that on RS server?
> | >
> | > 3. Is the development machine in the same doamin of the RS server?
> | >
> | > Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > 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.
> | >
> | >
> | > --
> | > | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | > | Subject: RS.EXE XServer Calls
> | > | Date: Thu, 21 Apr 2005 14:47:01 -0400
> | > | Lines: 25
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | > | Message-ID: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> | microsoft.public.sqlserver.reportingsvcs:41436
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | I have a short and simple RSS script which renders a report and
writes
> | the
> | > | output to disk. When I run the script while logged on, as myself,
to
> | the
> | > RS
> | > | Server the script works as desired.
> | > | When I run the script from my development machine I receive the
error:
> | > | >>The report server cannot open a connection to the report server
> | > database.
> | > | A connection to the database is required for
> | > | >>all requests and processing.
> | > |
> | > | what am I missing here?
> | > |
> | > | I am using
> | > | rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> | > | to establish who I am to the webservice and
> | > |
> | > | using the same endpoint in both instances (i.e.
> | > http:\\Server1\reportserver)
> | > |
> | > | Authentication on the web site is set to "integrated" only.
> | > |
> | > | The rs database is on a seperate machine from the RS Web Server/Web
> | > Service.
> | > |
> | > |
> | > | thanks,
> | > | dlr
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>|||Ok, Peter,
After reducing code to its essencials, we still have an error.
Please concider these two simple RSS Scripts
RSS Script 1:
Public Sub Main()
Dim rs As New ReportingService
Dim result As Byte() = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)
End Sub
RSS Script 2
Public Sub Main()
Dim rs As New ReportingService
Dim result As Byte() = Nothing
Dim cache As new System.Net.CredentialCache
Dim nc As new System.Net.NetWorkCredential("user","password","domain")
cache.Add(new Uri(rs.Url), "Negotiate", nc)
rs.Credentials = cache
result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)
End Sub
RSS Script 1 AND RSS Script 2 - work correctly (render method is called
without error) when run in a CMD box on the RS Web Server.
When I run either script from my local development box (as the same
interactive user) I get back
a "The item '/DLRTest/MULTIPAGE' cannot be found." where
'/DLRTest/MULTIPAGE' is the value of strReporthPath
I have an equavalant set of short C# programs with do the same tasks as RSS
Scripts 1 & 2. Both of these run without error
on both developer and server machines.
arggggggggggggggggggggggggggh.|||Hello Dennis,
The script host will initialize a global rs variable for you based on the
url and credentials supplied on the command line. By declaring a new rs
variable in a local scope, you are losing all of that functionality. Your
sample scripts do not set rs.Url, so you are probably getting the default
value of http://localhost/reportserver. You should be able to utilize the
current logged in user by skipping any credential settings in the script.
You may want to try removing the rs declaration and the rs.Credentials
assignment
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| References: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
<sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: RS.EXE XServer Calls - Authentication Errors
| Date: Tue, 26 Apr 2005 11:06:22 -0400
| Lines: 43
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| Message-ID: <OgbsYEnSFHA.204@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41850
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Ok, Peter,
| After reducing code to its essencials, we still have an error.
|
| Please concider these two simple RSS Scripts
| RSS Script 1:
| Public Sub Main()
| Dim rs As New ReportingService
| Dim result As Byte() = Nothing
| rs.Credentials = System.Net.CredentialCache.DefaultCredentials
| result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
| Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)
| End Sub
|
| RSS Script 2
| Public Sub Main()
| Dim rs As New ReportingService
| Dim result As Byte() = Nothing
| Dim cache As new System.Net.CredentialCache
| Dim nc As new System.Net.NetWorkCredential("user","password","domain")
| cache.Add(new Uri(rs.Url), "Negotiate", nc)
| rs.Credentials = cache
| result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
| Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)
| End Sub
|
| RSS Script 1 AND RSS Script 2 - work correctly (render method is called
| without error) when run in a CMD box on the RS Web Server.
| When I run either script from my local development box (as the same
| interactive user) I get back
| a "The item '/DLRTest/MULTIPAGE' cannot be found." where
| '/DLRTest/MULTIPAGE' is the value of strReporthPath
|
| I have an equavalant set of short C# programs with do the same tasks as
RSS
| Scripts 1 & 2. Both of these run without error
| on both developer and server machines.
|
|
| arggggggggggggggggggggggggggh.
|
|
|
|
|
||||done. correct answer. A+
dlr
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:rlTu9mvSFHA.3864@.TK2MSFTNGXA02.phx.gbl...
> Hello Dennis,
> The script host will initialize a global rs variable for you based on the
> url and credentials supplied on the command line. By declaring a new rs
> variable in a local scope, you are losing all of that functionality. Your
> sample scripts do not set rs.Url, so you are probably getting the default
> value of http://localhost/reportserver. You should be able to utilize the
> current logged in user by skipping any credential settings in the script.
> You may want to try removing the rs declaration and the rs.Credentials
> assignment
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>
>
> --
> | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | References: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
> <sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl>
> | Subject: Re: RS.EXE XServer Calls - Authentication Errors
> | Date: Tue, 26 Apr 2005 11:06:22 -0400
> | Lines: 43
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | Message-ID: <OgbsYEnSFHA.204@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:41850
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Ok, Peter,
> | After reducing code to its essencials, we still have an error.
> |
> | Please concider these two simple RSS Scripts
> | RSS Script 1:
> | Public Sub Main()
> | Dim rs As New ReportingService
> | Dim result As Byte() = Nothing
> | rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> | result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
> | Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing)
> | End Sub
> |
> | RSS Script 2
> | Public Sub Main()
> | Dim rs As New ReportingService
> | Dim result As Byte() = Nothing
> | Dim cache As new System.Net.CredentialCache
> | Dim nc As new System.Net.NetWorkCredential("user","password","domain")
> | cache.Add(new Uri(rs.Url), "Negotiate", nc)
> | rs.Credentials = cache
> | result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
> | Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing)
> | End Sub
> |
> | RSS Script 1 AND RSS Script 2 - work correctly (render method is called
> | without error) when run in a CMD box on the RS Web Server.
> | When I run either script from my local development box (as the same
> | interactive user) I get back
> | a "The item '/DLRTest/MULTIPAGE' cannot be found." where
> | '/DLRTest/MULTIPAGE' is the value of strReporthPath
> |
> | I have an equavalant set of short C# programs with do the same tasks as
> RSS
> | Scripts 1 & 2. Both of these run without error
> | on both developer and server machines.
> |
> |
> | arggggggggggggggggggggggggggh.
> |
> |
> |
> |
> |
> |
>|||My Pleasure. :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| References: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
<sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl>
<OgbsYEnSFHA.204@.TK2MSFTNGP15.phx.gbl>
<rlTu9mvSFHA.3864@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: RS.EXE XServer Calls - Authentication Errors
| Date: Wed, 27 Apr 2005 08:20:04 -0400
| Lines: 104
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| Message-ID: <uWwwHMySFHA.2324@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
0.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:48858
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| done. correct answer. A+
|
| dlr
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:rlTu9mvSFHA.3864@.TK2MSFTNGXA02.phx.gbl...
| > Hello Dennis,
| >
| > The script host will initialize a global rs variable for you based on
the
| > url and credentials supplied on the command line. By declaring a new rs
| > variable in a local scope, you are losing all of that functionality.
Your
| > sample scripts do not set rs.Url, so you are probably getting the
default
| > value of http://localhost/reportserver. You should be able to utilize
the
| > current logged in user by skipping any credential settings in the
script.
| >
| > You may want to try removing the rs declaration and the rs.Credentials
| > assignment
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| >
| >
| >
| > --
| > | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| > | References: <#gu4YIqRFHA.3444@.tk2msftngp13.phx.gbl>
| > <sQceqkuRFHA.7544@.TK2MSFTNGXA01.phx.gbl>
| > | Subject: Re: RS.EXE XServer Calls - Authentication Errors
| > | Date: Tue, 26 Apr 2005 11:06:22 -0400
| > | Lines: 43
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| > | Message-ID: <OgbsYEnSFHA.204@.TK2MSFTNGP15.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:41850
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Ok, Peter,
| > | After reducing code to its essencials, we still have an error.
| > |
| > | Please concider these two simple RSS Scripts
| > | RSS Script 1:
| > | Public Sub Main()
| > | Dim rs As New ReportingService
| > | Dim result As Byte() = Nothing
| > | rs.Credentials = System.Net.CredentialCache.DefaultCredentials
| > | result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
| > | Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
| Nothing)
| > | End Sub
| > |
| > | RSS Script 2
| > | Public Sub Main()
| > | Dim rs As New ReportingService
| > | Dim result As Byte() = Nothing
| > | Dim cache As new System.Net.CredentialCache
| > | Dim nc As new
System.Net.NetWorkCredential("user","password","domain")
| > | cache.Add(new Uri(rs.Url), "Negotiate", nc)
| > | rs.Credentials = cache
| > | result = rs.Render(strReportPath, strRenderFormat, Nothing, Nothing,
| > | Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
| Nothing)
| > | End Sub
| > |
| > | RSS Script 1 AND RSS Script 2 - work correctly (render method is
called
| > | without error) when run in a CMD box on the RS Web Server.
| > | When I run either script from my local development box (as the same
| > | interactive user) I get back
| > | a "The item '/DLRTest/MULTIPAGE' cannot be found." where
| > | '/DLRTest/MULTIPAGE' is the value of strReporthPath
| > |
| > | I have an equavalant set of short C# programs with do the same tasks
as
| > RSS
| > | Scripts 1 & 2. Both of these run without error
| > | on both developer and server machines.
| > |
| > |
| > | arggggggggggggggggggggggggggh.
| > |
| > |
| > |
| > |
| > |
| > |
| >
|
|
|

RS.exe Scripter DataSource error

Is it possible within an .rss script to set the data source of a report?
In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script.

Learnthis is the sample i used to attach the datasource but it still does not work:

Dim fullpath As String = SubFolderPath + "/Report.rdl"
Dim dataSources(0) As DataSource
Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Mydir/Test/mydatasourcename"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="mydatasourcename"
dataSources(0) = ds0
rs.SetItemDataSources(fullpath, dataSources)i

The error I keep getting when i click the report I just published is:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

And the error I get from the cmd is :

"Unhandled exception:
The data source 'cdo_suite_5_qa' cannot be found."


Any advice would be very helpful.
Steve

The fullpath does not need the .rdl extension but only the path and name of the report.

You could also try rs.SetReportDataSources rather then rs.SetItemDataSources.

RS.exe Scripter DataSource error

Is it possible within an .rss script to set the data source of a report?
In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script.

Learnthis is the sample i used to attach the datasource but it still does not work:

Dim fullpath As String = SubFolderPath + "/Report.rdl"
Dim dataSources(0) As DataSource
Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Mydir/Test/mydatasourcename"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="mydatasourcename"
dataSources(0) = ds0
rs.SetItemDataSources(fullpath, dataSources)i

The error I keep getting when i click the report I just published is:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

And the error I get from the cmd is :

"Unhandled exception:
The data source 'cdo_suite_5_qa' cannot be found."


Any advice would be very helpful.
Steve

The fullpath does not need the .rdl extension but only the path and name of the report.

You could also try rs.SetReportDataSources rather then rs.SetItemDataSources.

RS.exe Script utility and Forms Authentication

We have successfully implemented Forms Authentication using Custom Security
Extension. It works fine except the RS Script Utility unable to deploy
reports either locally on the report server itself or remotely from
workstation.
I could not connect to the report server. The command I used:
rs -s http://reportservername/reportserver -i PublishReports.rss -u username
-p password
The error message: Could not connect to server:
http://reportservername/ReportServer/ReportService2005.asmx
I'm not sure how the authentication ticket works with the rs utility.
Thanks,
Dawit T.You need to retrieve and cache the cookie and pass it manually with each
request just like you would do with WinForm applications. With web-based
access, the browser does it for you. With other clients, you are on your
own.
You may find this sample useful (assuming that you use RS 2000).
http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> We have successfully implemented Forms Authentication using Custom
> Security
> Extension. It works fine except the RS Script Utility unable to deploy
> reports either locally on the report server itself or remotely from
> workstation.
> I could not connect to the report server. The command I used:
> rs -s http://reportservername/reportserver -i PublishReports.rss -u
> username
> -p password
> The error message: Could not connect to server:
> http://reportservername/ReportServer/ReportService2005.asmx
> I'm not sure how the authentication ticket works with the rs utility.
> Thanks,
> Dawit T.|||Thanks. Actually, I'm using RS 2005. What change do I need to make the sample
work in RS 2005?
"Teo Lachev [MVP]" wrote:
> You need to retrieve and cache the cookie and pass it manually with each
> request just like you would do with WinForm applications. With web-based
> access, the browser does it for you. With other clients, you are on your
> own.
> You may find this sample useful (assuming that you use RS 2000).
> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> > We have successfully implemented Forms Authentication using Custom
> > Security
> > Extension. It works fine except the RS Script Utility unable to deploy
> > reports either locally on the report server itself or remotely from
> > workstation.
> >
> > I could not connect to the report server. The command I used:
> >
> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> > username
> > -p password
> >
> > The error message: Could not connect to server:
> > http://reportservername/ReportServer/ReportService2005.asmx
> >
> > I'm not sure how the authentication ticket works with the rs utility.
> >
> > Thanks,
> > Dawit T.
>
>|||Forms Authentication hasn't changed in RS 2005. However, the web service
APIs have been split into two web services -Management and Execution. I am
not sure if my sample will compile at all with RS 2005 once you dereference
the web service. Give it a try.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> Thanks. Actually, I'm using RS 2005. What change do I need to make the
> sample
> work in RS 2005?
> "Teo Lachev [MVP]" wrote:
>> You need to retrieve and cache the cookie and pass it manually with each
>> request just like you would do with WinForm applications. With web-based
>> access, the browser does it for you. With other clients, you are on your
>> own.
>> You may find this sample useful (assuming that you use RS 2000).
>> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
>> > We have successfully implemented Forms Authentication using Custom
>> > Security
>> > Extension. It works fine except the RS Script Utility unable to deploy
>> > reports either locally on the report server itself or remotely from
>> > workstation.
>> >
>> > I could not connect to the report server. The command I used:
>> >
>> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
>> > username
>> > -p password
>> >
>> > The error message: Could not connect to server:
>> > http://reportservername/ReportServer/ReportService2005.asmx
>> >
>> > I'm not sure how the authentication ticket works with the rs utility.
>> >
>> > Thanks,
>> > Dawit T.
>>|||"Teo Lachev [MVP]" wrote:
> Forms Authentication hasn't changed in RS 2005. However, the web service
> APIs have been split into two web services -Management and Execution. I am
> not sure if my sample will compile at all with RS 2005 once you dereference
> the web service. Give it a try.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
> > sample
> > work in RS 2005?
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You need to retrieve and cache the cookie and pass it manually with each
> >> request just like you would do with WinForm applications. With web-based
> >> access, the browser does it for you. With other clients, you are on your
> >> own.
> >>
> >> You may find this sample useful (assuming that you use RS 2000).
> >>
> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> > We have successfully implemented Forms Authentication using Custom
> >> > Security
> >> > Extension. It works fine except the RS Script Utility unable to deploy
> >> > reports either locally on the report server itself or remotely from
> >> > workstation.
> >> >
> >> > I could not connect to the report server. The command I used:
> >> >
> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> >> > username
> >> > -p password
> >> >
> >> > The error message: Could not connect to server:
> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >
> >> > I'm not sure how the authentication ticket works with the rs utility.
> >> >
> >> > Thanks,
> >> > Dawit T.
> >>
> >>
> >>
>
>|||Thanks for your immediate response.
I could be able to run the sample in RS 2005 and converted it into VB.Net.
Now, I'm to run it as RS script. However, I've face some basic issues:
1. I think rs instance (ReportServiceProxy) is created by the RS Utility
and the script uses it by referencing what the environment provided (rs). How
can I intercept the rs call to another instance that implemented/overriden
the default GetWebRequest & GetWebResponse for the cookie management?
2. RS Utility runs code between Public Sub Main()...End Sub. Can I import
or reference the custom ReportServiceProxy? Can there be two
ReportServiceProxy instances, one created by RS Utility another by the
script? How do I make RS utility be aware of the custome proxy?
Thanks,
Dawit.
"Teo Lachev [MVP]" wrote:
> Forms Authentication hasn't changed in RS 2005. However, the web service
> APIs have been split into two web services -Management and Execution. I am
> not sure if my sample will compile at all with RS 2005 once you dereference
> the web service. Give it a try.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
> > sample
> > work in RS 2005?
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You need to retrieve and cache the cookie and pass it manually with each
> >> request just like you would do with WinForm applications. With web-based
> >> access, the browser does it for you. With other clients, you are on your
> >> own.
> >>
> >> You may find this sample useful (assuming that you use RS 2000).
> >>
> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> > We have successfully implemented Forms Authentication using Custom
> >> > Security
> >> > Extension. It works fine except the RS Script Utility unable to deploy
> >> > reports either locally on the report server itself or remotely from
> >> > workstation.
> >> >
> >> > I could not connect to the report server. The command I used:
> >> >
> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> >> > username
> >> > -p password
> >> >
> >> > The error message: Could not connect to server:
> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >
> >> > I'm not sure how the authentication ticket works with the rs utility.
> >> >
> >> > Thanks,
> >> > Dawit T.
> >>
> >>
> >>
>
>|||Yeah, this is too helpful, isn't it? You can't also create custom classes in
the rss script. Here is something you can try.
The rs variable should inherit from SoapHttpClientProtocol because it is a
web service proxy. As such, it exposes a CookieContainer property which
allows you to set or get cookies. In other words, instead of inheriting from
the proxy, see if you could manage the auth cookie directly. I haven't tried
it so it may not work.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
> Thanks for your immediate response.
> I could be able to run the sample in RS 2005 and converted it into VB.Net.
> Now, I'm to run it as RS script. However, I've face some basic issues:
> 1. I think rs instance (ReportServiceProxy) is created by the RS Utility
> and the script uses it by referencing what the environment provided (rs).
> How
> can I intercept the rs call to another instance that implemented/overriden
> the default GetWebRequest & GetWebResponse for the cookie management?
> 2. RS Utility runs code between Public Sub Main()...End Sub. Can I import
> or reference the custom ReportServiceProxy? Can there be two
> ReportServiceProxy instances, one created by RS Utility another by the
> script? How do I make RS utility be aware of the custome proxy?
> Thanks,
> Dawit.
> "Teo Lachev [MVP]" wrote:
>> Forms Authentication hasn't changed in RS 2005. However, the web service
>> APIs have been split into two web services -Management and Execution. I
>> am
>> not sure if my sample will compile at all with RS 2005 once you
>> dereference
>> the web service. Give it a try.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
>> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
>> > sample
>> > work in RS 2005?
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> You need to retrieve and cache the cookie and pass it manually with
>> >> each
>> >> request just like you would do with WinForm applications. With
>> >> web-based
>> >> access, the browser does it for you. With other clients, you are on
>> >> your
>> >> own.
>> >>
>> >> You may find this sample useful (assuming that you use RS 2000).
>> >>
>> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
>> >> > We have successfully implemented Forms Authentication using Custom
>> >> > Security
>> >> > Extension. It works fine except the RS Script Utility unable to
>> >> > deploy
>> >> > reports either locally on the report server itself or remotely from
>> >> > workstation.
>> >> >
>> >> > I could not connect to the report server. The command I used:
>> >> >
>> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
>> >> > username
>> >> > -p password
>> >> >
>> >> > The error message: Could not connect to server:
>> >> > http://reportservername/ReportServer/ReportService2005.asmx
>> >> >
>> >> > I'm not sure how the authentication ticket works with the rs
>> >> > utility.
>> >> >
>> >> > Thanks,
>> >> > Dawit T.
>> >>
>> >>
>> >>
>>|||Yes, it is a very helpful sample! Thanks again.
RS variable exposes CookieContainer property. The problem is to catch the
auth cookie first time when rs utility gets authenticated by the web service
proxy.
Command line rs authentication occurs using:
rs -s http://reportservername/reportserver -i PublishReports.rss -u username
-p password
How do I also send the stored cookie with the request, eg during
rs.CreateFolder(parentFolder, "/", Nothing) operation?
Thanks,
Dawit.
"Teo Lachev [MVP]" wrote:
> Yeah, this is too helpful, isn't it? You can't also create custom classes in
> the rss script. Here is something you can try.
> The rs variable should inherit from SoapHttpClientProtocol because it is a
> web service proxy. As such, it exposes a CookieContainer property which
> allows you to set or get cookies. In other words, instead of inheriting from
> the proxy, see if you could manage the auth cookie directly. I haven't tried
> it so it may not work.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
> > Thanks for your immediate response.
> >
> > I could be able to run the sample in RS 2005 and converted it into VB.Net.
> > Now, I'm to run it as RS script. However, I've face some basic issues:
> >
> > 1. I think rs instance (ReportServiceProxy) is created by the RS Utility
> > and the script uses it by referencing what the environment provided (rs).
> > How
> > can I intercept the rs call to another instance that implemented/overriden
> > the default GetWebRequest & GetWebResponse for the cookie management?
> >
> > 2. RS Utility runs code between Public Sub Main()...End Sub. Can I import
> > or reference the custom ReportServiceProxy? Can there be two
> > ReportServiceProxy instances, one created by RS Utility another by the
> > script? How do I make RS utility be aware of the custome proxy?
> >
> > Thanks,
> > Dawit.
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Forms Authentication hasn't changed in RS 2005. However, the web service
> >> APIs have been split into two web services -Management and Execution. I
> >> am
> >> not sure if my sample will compile at all with RS 2005 once you
> >> dereference
> >> the web service. Give it a try.
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> >> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
> >> > sample
> >> > work in RS 2005?
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> You need to retrieve and cache the cookie and pass it manually with
> >> >> each
> >> >> request just like you would do with WinForm applications. With
> >> >> web-based
> >> >> access, the browser does it for you. With other clients, you are on
> >> >> your
> >> >> own.
> >> >>
> >> >> You may find this sample useful (assuming that you use RS 2000).
> >> >>
> >> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >> >>
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> >> > We have successfully implemented Forms Authentication using Custom
> >> >> > Security
> >> >> > Extension. It works fine except the RS Script Utility unable to
> >> >> > deploy
> >> >> > reports either locally on the report server itself or remotely from
> >> >> > workstation.
> >> >> >
> >> >> > I could not connect to the report server. The command I used:
> >> >> >
> >> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> >> >> > username
> >> >> > -p password
> >> >> >
> >> >> > The error message: Could not connect to server:
> >> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >> >
> >> >> > I'm not sure how the authentication ticket works with the rs
> >> >> > utility.
> >> >> >
> >> >> > Thanks,
> >> >> > Dawit T.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||But you have to call LogonUser API first. I would expect that after this
call the management proxy to return the cookie. Well, worst come to worse,
you can whip out your own console app (rsex.exe :-0).
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:46897D4A-0094-4154-8301-EA3158D5508E@.microsoft.com...
> Yes, it is a very helpful sample! Thanks again.
> RS variable exposes CookieContainer property. The problem is to catch the
> auth cookie first time when rs utility gets authenticated by the web
> service
> proxy.
> Command line rs authentication occurs using:
> rs -s http://reportservername/reportserver -i PublishReports.rss -u
> username
> -p password
> How do I also send the stored cookie with the request, eg during
> rs.CreateFolder(parentFolder, "/", Nothing) operation?
> Thanks,
> Dawit.
> "Teo Lachev [MVP]" wrote:
>> Yeah, this is too helpful, isn't it? You can't also create custom classes
>> in
>> the rss script. Here is something you can try.
>> The rs variable should inherit from SoapHttpClientProtocol because it is
>> a
>> web service proxy. As such, it exposes a CookieContainer property which
>> allows you to set or get cookies. In other words, instead of inheriting
>> from
>> the proxy, see if you could manage the auth cookie directly. I haven't
>> tried
>> it so it may not work.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
>> > Thanks for your immediate response.
>> >
>> > I could be able to run the sample in RS 2005 and converted it into
>> > VB.Net.
>> > Now, I'm to run it as RS script. However, I've face some basic issues:
>> >
>> > 1. I think rs instance (ReportServiceProxy) is created by the RS
>> > Utility
>> > and the script uses it by referencing what the environment provided
>> > (rs).
>> > How
>> > can I intercept the rs call to another instance that
>> > implemented/overriden
>> > the default GetWebRequest & GetWebResponse for the cookie management?
>> >
>> > 2. RS Utility runs code between Public Sub Main()...End Sub. Can I
>> > import
>> > or reference the custom ReportServiceProxy? Can there be two
>> > ReportServiceProxy instances, one created by RS Utility another by the
>> > script? How do I make RS utility be aware of the custome proxy?
>> >
>> > Thanks,
>> > Dawit.
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> Forms Authentication hasn't changed in RS 2005. However, the web
>> >> service
>> >> APIs have been split into two web services -Management and Execution.
>> >> I
>> >> am
>> >> not sure if my sample will compile at all with RS 2005 once you
>> >> dereference
>> >> the web service. Give it a try.
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> >> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
>> >> > Thanks. Actually, I'm using RS 2005. What change do I need to make
>> >> > the
>> >> > sample
>> >> > work in RS 2005?
>> >> >
>> >> > "Teo Lachev [MVP]" wrote:
>> >> >
>> >> >> You need to retrieve and cache the cookie and pass it manually with
>> >> >> each
>> >> >> request just like you would do with WinForm applications. With
>> >> >> web-based
>> >> >> access, the browser does it for you. With other clients, you are
>> >> >> on
>> >> >> your
>> >> >> own.
>> >> >>
>> >> >> You may find this sample useful (assuming that you use RS 2000).
>> >> >>
>> >> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
>> >> >>
>> >> >> --
>> >> >> HTH,
>> >> >> ---
>> >> >> Teo Lachev, MVP, MCSD, MCT
>> >> >> "Microsoft Reporting Services in Action"
>> >> >> "Applied Microsoft Analysis Services 2005"
>> >> >> Home page and blog: http://www.prologika.com/
>> >> >> ---
>> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> >> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
>> >> >> > We have successfully implemented Forms Authentication using
>> >> >> > Custom
>> >> >> > Security
>> >> >> > Extension. It works fine except the RS Script Utility unable to
>> >> >> > deploy
>> >> >> > reports either locally on the report server itself or remotely
>> >> >> > from
>> >> >> > workstation.
>> >> >> >
>> >> >> > I could not connect to the report server. The command I used:
>> >> >> >
>> >> >> > rs -s http://reportservername/reportserver -i
>> >> >> > PublishReports.rss -u
>> >> >> > username
>> >> >> > -p password
>> >> >> >
>> >> >> > The error message: Could not connect to server:
>> >> >> > http://reportservername/ReportServer/ReportService2005.asmx
>> >> >> >
>> >> >> > I'm not sure how the authentication ticket works with the rs
>> >> >> > utility.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Dawit T.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||I apprecaite if Reporting Service team fix RS Scripting utility to make it
Forms Authentication aware. It looks like RS utility does not have that
feature or it is a bug.
Expecting to hear from RS team.
Thanks for all your help,
Dawit.
"Teo Lachev [MVP]" wrote:
> But you have to call LogonUser API first. I would expect that after this
> call the management proxy to return the cookie. Well, worst come to worse,
> you can whip out your own console app (rsex.exe :-0).
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:46897D4A-0094-4154-8301-EA3158D5508E@.microsoft.com...
> > Yes, it is a very helpful sample! Thanks again.
> >
> > RS variable exposes CookieContainer property. The problem is to catch the
> > auth cookie first time when rs utility gets authenticated by the web
> > service
> > proxy.
> >
> > Command line rs authentication occurs using:
> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> > username
> > -p password
> >
> > How do I also send the stored cookie with the request, eg during
> > rs.CreateFolder(parentFolder, "/", Nothing) operation?
> >
> > Thanks,
> > Dawit.
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Yeah, this is too helpful, isn't it? You can't also create custom classes
> >> in
> >> the rss script. Here is something you can try.
> >>
> >> The rs variable should inherit from SoapHttpClientProtocol because it is
> >> a
> >> web service proxy. As such, it exposes a CookieContainer property which
> >> allows you to set or get cookies. In other words, instead of inheriting
> >> from
> >> the proxy, see if you could manage the auth cookie directly. I haven't
> >> tried
> >> it so it may not work.
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
> >> > Thanks for your immediate response.
> >> >
> >> > I could be able to run the sample in RS 2005 and converted it into
> >> > VB.Net.
> >> > Now, I'm to run it as RS script. However, I've face some basic issues:
> >> >
> >> > 1. I think rs instance (ReportServiceProxy) is created by the RS
> >> > Utility
> >> > and the script uses it by referencing what the environment provided
> >> > (rs).
> >> > How
> >> > can I intercept the rs call to another instance that
> >> > implemented/overriden
> >> > the default GetWebRequest & GetWebResponse for the cookie management?
> >> >
> >> > 2. RS Utility runs code between Public Sub Main()...End Sub. Can I
> >> > import
> >> > or reference the custom ReportServiceProxy? Can there be two
> >> > ReportServiceProxy instances, one created by RS Utility another by the
> >> > script? How do I make RS utility be aware of the custome proxy?
> >> >
> >> > Thanks,
> >> > Dawit.
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> Forms Authentication hasn't changed in RS 2005. However, the web
> >> >> service
> >> >> APIs have been split into two web services -Management and Execution.
> >> >> I
> >> >> am
> >> >> not sure if my sample will compile at all with RS 2005 once you
> >> >> dereference
> >> >> the web service. Give it a try.
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> >> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> >> >> > Thanks. Actually, I'm using RS 2005. What change do I need to make
> >> >> > the
> >> >> > sample
> >> >> > work in RS 2005?
> >> >> >
> >> >> > "Teo Lachev [MVP]" wrote:
> >> >> >
> >> >> >> You need to retrieve and cache the cookie and pass it manually with
> >> >> >> each
> >> >> >> request just like you would do with WinForm applications. With
> >> >> >> web-based
> >> >> >> access, the browser does it for you. With other clients, you are
> >> >> >> on
> >> >> >> your
> >> >> >> own.
> >> >> >>
> >> >> >> You may find this sample useful (assuming that you use RS 2000).
> >> >> >>
> >> >> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >> >> >>
> >> >> >> --
> >> >> >> HTH,
> >> >> >> ---
> >> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> >> "Microsoft Reporting Services in Action"
> >> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> >> Home page and blog: http://www.prologika.com/
> >> >> >> ---
> >> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> >> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> >> >> > We have successfully implemented Forms Authentication using
> >> >> >> > Custom
> >> >> >> > Security
> >> >> >> > Extension. It works fine except the RS Script Utility unable to
> >> >> >> > deploy
> >> >> >> > reports either locally on the report server itself or remotely
> >> >> >> > from
> >> >> >> > workstation.
> >> >> >> >
> >> >> >> > I could not connect to the report server. The command I used:
> >> >> >> >
> >> >> >> > rs -s http://reportservername/reportserver -i
> >> >> >> > PublishReports.rss -u
> >> >> >> > username
> >> >> >> > -p password
> >> >> >> >
> >> >> >> > The error message: Could not connect to server:
> >> >> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >> >> >
> >> >> >> > I'm not sure how the authentication ticket works with the rs
> >> >> >> > utility.
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Dawit T.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

RS.EXE SCRIPT TU AUTOMATE REPORT EXECUTION

Hi,
I am searchig RSS script for RS.EXE to automate excution/run of reports.
I would like to be able to generate reports both in PDF and Excel and store
them in a predefined Server Folder.
There is 2 RSS samples even in SP1 and none of them is doing such job.
I think it could be useful to a lot of people.
Many ThanksJean-Marc,
If you want to automate report deliviery, you don't have to use rs.exe. In
report manager, check out data-driven subscriptions.
Jon Jahren
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am searchig RSS script for RS.EXE to automate excution/run of reports.
> I would like to be able to generate reports both in PDF and Excel and
store
> them in a predefined Server Folder.
> There is 2 RSS samples even in SP1 and none of them is doing such job.
> I think it could be useful to a lot of people.
> Many Thanks
>|||Jon,
I know this Reporting Services features.
BUT, I have to do it in automatically in our company Product independently
of any Reporting Services User Interface.
Best Regards.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:%23CzFczJyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Jean-Marc,
> If you want to automate report deliviery, you don't have to use rs.exe. In
> report manager, check out data-driven subscriptions.
> Jon Jahren
> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
> news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I am searchig RSS script for RS.EXE to automate excution/run of reports.
> >
> > I would like to be able to generate reports both in PDF and Excel and
> store
> > them in a predefined Server Folder.
> >
> > There is 2 RSS samples even in SP1 and none of them is doing such job.
> >
> > I think it could be useful to a lot of people.
> >
> > Many Thanks
> >
> >
>|||Have you checked out web services. It would surprise me if that didn't have
the capability to do what you are talking about. Use web services to setup
the data driven subscriptions. I think you still want to do that, why
reinvent the wheel.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:uGtWbTLyEHA.1396@.tk2msftngp13.phx.gbl...
> Jon,
> I know this Reporting Services features.
> BUT, I have to do it in automatically in our company Product
> independently
> of any Reporting Services User Interface.
> Best Regards.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:%23CzFczJyEHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Jean-Marc,
>> If you want to automate report deliviery, you don't have to use rs.exe.
>> In
>> report manager, check out data-driven subscriptions.
>> Jon Jahren
>> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
>> news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
>> > Hi,
>> >
>> > I am searchig RSS script for RS.EXE to automate excution/run of
>> > reports.
>> >
>> > I would like to be able to generate reports both in PDF and Excel and
>> store
>> > them in a predefined Server Folder.
>> >
>> > There is 2 RSS samples even in SP1 and none of them is doing such job.
>> >
>> > I think it could be useful to a lot of people.
>> >
>> > Many Thanks
>> >
>> >
>>
>

rs.exe Questions on using rss file

Multiple Questions on deploying a bulk insertion script file for inserting
reports into reporting services. The script provided by MSDN PublishReports
is really straight forward with some exceptions or at least for me.
How can I ensure that the Data connection that is added in the script gets
added to each report that gets published in the script?
I am recieving an error that states the data set 'Default' refers to a
shared data source 'Default', which is not published on the report server
when I run my script. However the dataconnection that I specified in the
script gets created by the script and works perfectly.
How can I specify a Published Name that is different than the Report.rdl
Name in the scrtipt at the time of insertion? Basically just as if you were
to do the publishing of a report one at a time through the manager and after
uploading the file you can change the name of the Report. How can I do that
in the script?
Thank you for the assitance!
Bradd
please email me @. the following address if you need further clarification to
help my stupid mind. bradd.schick@.fnf.com Thank youSorry the Data Connection taht I am creating in the script is not called
default it is named something different. Just incase anyone neede to know
that.
So Why am I getting an error on Default?
Thanks again
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Alright I got my head out of you know where and I have solved the first
question of the data connection's. The person writing the report (rdl) file
screwed up. I still need help on the second question of the report name.
Thanks
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Try this snippet in your script:
' Create an array representing the files in the specified directory.
Dim di As New DirectoryInfo(strPathName)
Dim fi As FileInfo() = di.GetFiles()
' Optional to echo to console
Console.WriteLine("The following files exist in the current
directory:")
' Iterate through the names of the files in the current directory.
Dim fiTemp As FileInfo
For Each fiTemp In fi
strReportName = Path.GetFileNameWithoutExtension(fiTemp.Name)
PublishReport(strReportName)
Next fiTemp
Just a bit of those new VB .NET methods.
--
Brian J. Matuschak
brian@.electronic-atlas.com
"Bradd Schick" wrote:
> Alright I got my head out of you know where and I have solved the first
> question of the data connection's. The person writing the report (rdl) file
> screwed up. I still need help on the second question of the report name.
> Thanks
> "Bradd Schick" wrote:
> > Multiple Questions on deploying a bulk insertion script file for inserting
> > reports into reporting services. The script provided by MSDN PublishReports
> > is really straight forward with some exceptions or at least for me.
> >
> > How can I ensure that the Data connection that is added in the script gets
> > added to each report that gets published in the script?
> > I am recieving an error that states the data set 'Default' refers to a
> > shared data source 'Default', which is not published on the report server
> > when I run my script. However the dataconnection that I specified in the
> > script gets created by the script and works perfectly.
> >
> > How can I specify a Published Name that is different than the Report.rdl
> > Name in the scrtipt at the time of insertion? Basically just as if you were
> > to do the publishing of a report one at a time through the manager and after
> > uploading the file you can change the name of the Report. How can I do that
> > in the script?
> >
> > Thank you for the assitance!
> >
> > Bradd
> > please email me @. the following address if you need further clarification to
> > help my stupid mind. bradd.schick@.fnf.com Thank you

rs.exe compile error

I am using the rsscripter tool to migrate my reports from the dev machine to
the acceptance machine. I am getting a compile error:
Running script "GlobalReportsLibrary\GLOBAL\rpt_100_PutAway.rdl.rss"
The specified script failed to compile with the following errors:
C:\tempreports> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\vbc.exe" /t:exe
/main:MainModule /utf8output /R:"System.dll" /R:"System.Xml.dll"
/R:"System.Web.Services.dll" /R:"C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\rs.exe" /out:"C:\Documents and Settings\ephisha\Local
Settings\Temp\mchxuwd6.exe" /debug- "C:\Documents and Settings\ephisha\Local
Settings\Temp\mchxuwd6.0.vb" "C:\Documents and Settings\ephisha\Local
Settings\Temp\mchxuwd6.1.vb"
Microsoft (R) Visual Basic Compiler version 8.0.50727.42
for Microsoft (R) .NET Framework version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.
C:\Documents and Settings\ephisha\Local Settings\Temp\mchxuwd6.1.vb(78) :
error BC30456: 'SetReportDataSources' is not a member of
'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
RS.SetReportDataSources(fullpath, dataSources)
~~~~~~~~~~~~~~~~~~~~~~~
Does anyone have any ideas? Thanks.Phill,
Does the fullpath have the .rdl extension, as it only needs the path and
name of the report.
One other method is to create a project in Visual Studio and try to debug it
there. Here are the steps:
In Visual Studio or download Visual Studio Express (Free)
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add:
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Reeves
"Phill" wrote:
> I am using the rsscripter tool to migrate my reports from the dev machine to
> the acceptance machine. I am getting a compile error:
> Running script "GlobalReportsLibrary\GLOBAL\rpt_100_PutAway.rdl.rss"
> The specified script failed to compile with the following errors:
> C:\tempreports> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\vbc.exe" /t:exe
> /main:MainModule /utf8output /R:"System.dll" /R:"System.Xml.dll"
> /R:"System.Web.Services.dll" /R:"C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn\rs.exe" /out:"C:\Documents and Settings\ephisha\Local
> Settings\Temp\mchxuwd6.exe" /debug- "C:\Documents and Settings\ephisha\Local
> Settings\Temp\mchxuwd6.0.vb" "C:\Documents and Settings\ephisha\Local
> Settings\Temp\mchxuwd6.1.vb"
>
> Microsoft (R) Visual Basic Compiler version 8.0.50727.42
> for Microsoft (R) .NET Framework version 2.0.50727.42
> Copyright (c) Microsoft Corporation. All rights reserved.
> C:\Documents and Settings\ephisha\Local Settings\Temp\mchxuwd6.1.vb(78) :
> error BC30456: 'SetReportDataSources' is not a member of
> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
> RS.SetReportDataSources(fullpath, dataSources)
> ~~~~~~~~~~~~~~~~~~~~~~~
rs.SetReportDataSources("/
> Does anyone have any ideas? Thanks.

rs.exe and SMTP

Hi

I'm trying to send email from my rss script. It seems that the script cannot create an SmtpClient instance because of SmtpPermission problems, but I just can't find where I need to enable the SmtpPermission. I've tried many things, including web.config and rssrvpolicy.config.

Here's a code sample:

Public Sub Main

Dim smtpClient As New System.Net.Mail.SmtpClient

End Sub

and here's the output when I execute the above script under rs.exe against my local report server

Unhandled exception:
Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089' failed.

Any ideas?

Many thanks

Tony

i have the same problem but with a console application....

rs utility compiled script ?

Hi,
the rs utility is good, but the script is compiled at every usage.
does it possible to compile a script 1 time and keep the compiled version?
for the moment I bypass this problem by creating my own program.
any idea?
thanks.
Jerome.Hello Jerome,
The rs utility does instantiate a few objects for you and calls methods on
the RS SOAP interface. But yes each time you run it, it gets compiled first
into .NET IL before being executed.
If you write your own .NET program that calls methods on the RS SOAP
interface then you'd have to instatiate some of the objects yourself - like
the Report Service. Its not difficult to convert RS Script to a VB.NET
program that you can compile into a .NET assembly.
Chapter 9¾ of our book : "Hitchhiker's Guide to SQL Server 2000 Reporting
Services" covers this content.
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:u58MWZmyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> the rs utility is good, but the script is compiled at every usage.
> does it possible to compile a script 1 time and keep the compiled version?
> for the moment I bypass this problem by creating my own program.
> any idea?
> thanks.
> Jerome.
>|||On Sun, 14 Nov 2004 21:49:50 -0000, "Peter Blackburn
\(www.sqlreportingservices.net\)"
<http://www.sqlreportingservices.net> wrote:
>Chapter 9¾ of our book : "Hitchhiker's Guide to SQL Server 2000 Reporting
>Services" covers this content.
Hi Peter,
I just love the idea of chapter 9¾. :)
Andrew Watt
MVP - InfoPath|||Hello Andrew - you'll probably love our Voldemort Basic.NET quips in that
chapter too!
Peter
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:1e0hp05asje86dml2ppb5q6mrfkgq596pd@.4ax.com...
> On Sun, 14 Nov 2004 21:49:50 -0000, "Peter Blackburn
> \(www.sqlreportingservices.net\)"
> <http://www.sqlreportingservices.net> wrote:
>>Chapter 9¾ of our book : "Hitchhiker's Guide to SQL Server 2000 Reporting
>>Services" covers this content.
> Hi Peter,
> I just love the idea of chapter 9¾. :)
> Andrew Watt
> MVP - InfoPath

RS Scripting utility does not work with Forms Authentication

We have successfully implemented Forms Authentication using Custom Security
Extension. It works fine except the RS Script Utility unable to deploy
reports either locally on the report server itself or remotely from
workstation.
I could not connect to the report server. The command I used:
rs -s http://reportservername/reportserver -i PublishReports.rss -u username
-p password
The error message: Could not connect to server:
http://reportservername/ReportServer/ReportService2005.asmx
This occurs under SSRS 2005 & VS 2005.
Tried Solution: Is to cache and retrieve the cookie and pass it manually
with each
request just like WinForm applications. However, once the RS utility logs
in, it will be too late for any script to catch the authentication cookie,
even by calling rs.LogonUser API.
Question: It looks like RS utility does not support Forms Authentication or
it is a bug.
Would there be a fix by Reporting Service team to make RS Scripting utility
work with Forms Authentication?
Thanks for your help,
Dawit T.Unfortunately, it's a limitation of the RS utility, which has been the case
since SQL 2000.
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:76EDBB9F-4B08-4BFF-A471-12C9CCA3A817@.microsoft.com...
> We have successfully implemented Forms Authentication using Custom
> Security
> Extension. It works fine except the RS Script Utility unable to deploy
> reports either locally on the report server itself or remotely from
> workstation.
> I could not connect to the report server. The command I used:
> rs -s http://reportservername/reportserver -i PublishReports.rss -u
> username
> -p password
> The error message: Could not connect to server:
> http://reportservername/ReportServer/ReportService2005.asmx
> This occurs under SSRS 2005 & VS 2005.
> Tried Solution: Is to cache and retrieve the cookie and pass it manually
> with each
> request just like WinForm applications. However, once the RS utility logs
> in, it will be too late for any script to catch the authentication cookie,
> even by calling rs.LogonUser API.
> Question: It looks like RS utility does not support Forms Authentication
> or
> it is a bug.
> Would there be a fix by Reporting Service team to make RS Scripting
> utility
> work with Forms Authentication?
>
> Thanks for your help,
> Dawit T.

rs script utility and vbScript

Hi,
I've modified PublishSampleReports.rss and it is working fine to deploy
reports, set data sources and update parameters. However, there is one
thing I can't seem to get working...
I'm trying to read the list of report names to be deployed from a text
file. To do so I was using the following bit of vbScript...
Dim objFSO
Set objFSO =3D CreateObject("Scripting.FileSystemObject")
and trying to use this to connect to the text file to read the report
names. But it tells me that it doesn't recognise CreateObject()
Is this because the .rss file doesn't use vbScript? Or am I just doing
something worng?
Any help would be greatly appreciated...
Thanks
Gear=F3idoops, I think I may have discovered my mistake - the rss script is
written in vb.net, not vbScript. Take 2...