sql server reporting services: 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:
[quoted text, click to view]

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,

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


[quoted text, click to view]

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
|
|
[quoted text, click to view]
| > 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

[quoted text, click to view]

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
[quoted text, click to view]

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
[quoted text, click to view]
| > 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.
| > |
| > |
| > |
| > |
| > |
| > |
| >
|
|
|