RSExplorer Example

I try to modify the RSExplorer example by using form authentication. I have
create a window logon form. Could anyone can help me how to integrate form
authentication and the sample together ? Actually I don't know how the
report server can regonize the logon user.
Thanksadd this report parameter: =User!UserID
Geert
"May Liu" wrote:
> I try to modify the RSExplorer example by using form authentication. I have
> create a window logon form. Could anyone can help me how to integrate form
> authentication and the sample together ? Actually I don't know how the
> report server can regonize the logon user.
> Thanks|||May,
Please see the thread "How do you set a cookie for axshdocvw".
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:2E81EC43-D180-4568-BFC7-686B39F138CF@.microsoft.com...
> I try to modify the RSExplorer example by using form authentication. I
have
> create a window logon form. Could anyone can help me how to integrate
form
> authentication and the sample together ? Actually I don't know how the
> report server can regonize the logon user.
> Thanks|||Where can I find the thread ?
"Teo Lachev" wrote:
> May,
> Please see the thread "How do you set a cookie for axshdocvw".
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:2E81EC43-D180-4568-BFC7-686B39F138CF@.microsoft.com...
> > I try to modify the RSExplorer example by using form authentication. I
> have
> > create a window logon form. Could anyone can help me how to integrate
> form
> > authentication and the sample together ? Actually I don't know how the
> > report server can regonize the logon user.
> >
> > Thanks
>
>|||I find it !!! Thanks. I will take a look on that.
"May Liu" wrote:
> Where can I find the thread ?
> "Teo Lachev" wrote:
> > May,
> >
> > Please see the thread "How do you set a cookie for axshdocvw".
> >
> > --
> > Hope this helps.
> >
> > ----
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ----
> >
> > "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> > news:2E81EC43-D180-4568-BFC7-686B39F138CF@.microsoft.com...
> > > I try to modify the RSExplorer example by using form authentication. I
> > have
> > > create a window logon form. Could anyone can help me how to integrate
> > form
> > > authentication and the sample together ? Actually I don't know how the
> > > report server can regonize the logon user.
> > >
> > > Thanks
> >
> >
> >

RSExecRole

What is the function of the RSExecRole? Should I be granting this to users
in a development environment who need to create reports?
Thanks,
SteveHi,
"RSExecRole" permission is given to ReportServer database. This can be used
for accessing master, msdb and reportserver tempdb. But when you configure
using report configuration tool, these permissions are granted automatically.
So dont have to give it again.
Regards
Amarnath
"Steven" wrote:
> What is the function of the RSExecRole? Should I be granting this to users
> in a development environment who need to create reports?
> Thanks,
> Steve
>
>

rsDataExtensionNotFound for using XML

Hi all,

I am using SQL Server 2005 reporting service and I am attempting to create a report via xml returned from a web service. Everything works fine while I am in the report designer of visual studio 2005.

However, when I attempt to deploy the report to the report server, it will complain that the xml data extension is not registered with the report server, giving me a rsDataExtensionNotFound. A check on the report server config file does show the xml data extension with all the microsoft namespaces. I had thought that Reporting Services in SQL Server 2005 does natively support xml data source.

Has anyone encountered a similar problem? Does anyone have any suggestions?

Does it matter that the SQL Server 2005 that I have is the workgroup edition ?

Thanks

HI,krayek:

As far as i know ,XML data sources are not supported in SQL Express:

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

(See "Unsupported Features" section.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Thanks for the reply.

However, my SQL version is SQL Server 2005 workgroup edition.

So, I am wondering if this SQL Server 2005 workgroup edition also does not support XML data extension ?

Regards,

David K

|||

HI, David K

No, SQL Server 2005 workgroup edition did not support non relational data source.

Features/Reporting Services Enhancements

EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)SE (32-bit) SE (64-bit)WG (32-bit)SSE (32-bit)SSEA (32-bit)Support for remote and nonrelational data sourcesYesYesNoNoNo

Please refer this article: http://msdn2.microsoft.com/en-us/library/ms143761.aspx

|||

Hi Rex,

Thanks for that info. Darn, looks like I need to get the standard edition then.. =)

Thanks again for the help, appreciate it.

Regards,

David K

|||

You are welcome,David.

It's my pleasure!

RS2005 and Reuse

Does RS2005 provide the ability to create reusable components? By component
I mean the ability to create graphs or textboxes that are tied to certain
expressions or sql queries and stored for reuse. This would allow an enduser
to simply select the component to put on the report without knowing anything
about the data. All they need to know is they want "Graph X" on the report.
Is this philosphy supported by Report Builder?
ThanksThe tools on the tools list are dot net classes... You can create a dot net
assembly, which subclasses the chart controls, etc, adding your custom stuff
( ie making it data-aware), deploy it to the developers desktop and RS
server. Then the developers can add the new custom controls to their toolbar
and go to work...
The big deal, is that now you must deploy/maintain this new assembly...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"tcs" wrote:
> Does RS2005 provide the ability to create reusable components? By component
> I mean the ability to create graphs or textboxes that are tied to certain
> expressions or sql queries and stored for reuse. This would allow an enduser
> to simply select the component to put on the report without knowing anything
> about the data. All they need to know is they want "Graph X" on the report.
> Is this philosphy supported by Report Builder?
>
> Thanks|||Thanks for the response Wayne. Its good to see the flexiblity is available
even if you need to maintain the assembly.
"tcs" wrote:
> Does RS2005 provide the ability to create reusable components? By component
> I mean the ability to create graphs or textboxes that are tied to certain
> expressions or sql queries and stored for reuse. This would allow an enduser
> to simply select the component to put on the report without knowing anything
> about the data. All they need to know is they want "Graph X" on the report.
> Is this philosphy supported by Report Builder?
>
> Thankssql

RS: Cannot create a connection to data source

Hi!

I've created a project includen 3 reports based on following code on 3 server. The report includes 3 different datasources an 3 different report. All 3 reports are grouped on Database and summerizad zise.

SELECT

SD.name [Database],

SMF.name [File],

SMF.size [Size]

FROM

sys.master_files SMF INNER JOIN sys.databases SD

ON SD.database_id = SMF.database_id

I can run all reports in Visual Studio (preview). But I can only run one the reports after depolying the project! I get this message when I raun the other 2 reports:

An error has occurred during report processing.

Cannot create a connection to data source 'uasql02_datasource'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

I tried running the report from an server (where reportingservices is installed) finding that all the reports works as they should. I logged in another server with the same credentials. I got same message on the server as I get on my own camputer, "Cannot create a connection to data source ..."

Is there anybody out there having same problem as I, or someone who has any suggestion?

Thanks for any suggestion!

/*

Fari Sah

*/

Hello, Fari-- I am also getting the "Cannot create a connection to data source..." message, but the rest says "Login failed for user..."

Everything works fine on my production server, but I'm having trouble getting the same reports to work on my development PC and my test server. I'm going to keep hunting, so please post any new information!

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.exe and Oracle

I am trying to create a .rss file that deploys my reports to the report
server. I have everything working except for the creation of the datasource.
The problem is that I am using an Oracle database and I cannot set the
correct setting in my code.
I can create a datasource; but I have to log into the report server and
change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
The below bit of code works (notice I am setting the Extension to SQL)
...
Dim definition As New DataSourceDefinition()
definition.CredentialRetrieval = CredentialRetrievalEnum.Store
definition.ConnectString = connectionString
definition.Enabled = True
definition.Extension = "SQL"
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
definition.WindowsCredentials = False
...
The below code DOES NOT work (I am setting the Extension to Oracle)
...
Dim definition As New DataSourceDefinition()
definition.CredentialRetrieval = CredentialRetrievalEnum.Store
definition.ConnectString = connectionString
definition.Enabled = True
definition.Extension = "Oracle"
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
definition.WindowsCredentials = False
...
There has to be some easy change here to get this to work with an Oracle
database, I just cannot find out what the Oracle string is to set the
Extension.
Any ideas? Thanks for any help or suggestion.
RobRob,
Here is my rs code that worked for me, looks the same but maybe give it a
shot, the only thing i see if you have "Oracle" and i have "ORACLE", not sure
if that is it.:
Dim Definition As New DataSourceDefinition
Dim Properties(1) As [Property]
Dim Description As New [Property]
Dim Hidden As New [Property]
Description.Name = "Description"
Description.Value = "DataSourceDescription"
Hidden.Name = "Hidden"
Hidden.Value = "False"
Properties(0) = Description
Properties(1) = Hidden
Definition.CredentialRetrieval = CredentialRetrievalEnum.Store
Definition.UserName = "UserName"
Definition.ConnectString = "Data Source=DATABASE;Unicode=True"
Definition.Enabled = True
Definition.Extension = "ORACLE"
Definition.WindowsCredentials = False ' (Prompt and Store)
Definition.ImpersonateUser = False ' (Store)
Definition.EnabledSpecified = True
Definition.ImpersonateUserSpecified = True
Definition.OriginalConnectStringExpressionBased = False
Definition.UseOriginalConnectString = False
"Rob" wrote:
> I am trying to create a .rss file that deploys my reports to the report
> server. I have everything working except for the creation of the datasource.
> The problem is that I am using an Oracle database and I cannot set the
> correct setting in my code.
> I can create a datasource; but I have to log into the report server and
> change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
> The below bit of code works (notice I am setting the Extension to SQL)
> ...
> Dim definition As New DataSourceDefinition()
> definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> definition.ConnectString = connectionString
> definition.Enabled = True
> definition.Extension = "SQL"
> definition.ImpersonateUser = False
> definition.ImpersonateUserSpecified = True
> definition.WindowsCredentials = False
> ...
> The below code DOES NOT work (I am setting the Extension to Oracle)
> ...
> Dim definition As New DataSourceDefinition()
> definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> definition.ConnectString = connectionString
> definition.Enabled = True
> definition.Extension = "Oracle"
> definition.ImpersonateUser = False
> definition.ImpersonateUserSpecified = True
> definition.WindowsCredentials = False
> ...
> There has to be some easy change here to get this to work with an Oracle
> database, I just cannot find out what the Oracle string is to set the
> Extension.
> Any ideas? Thanks for any help or suggestion.
> Rob
>|||One other thing, I posted this before, but here is how you can debug a RS.exe
script. Not sure if this is any help on this issue but can help down the road.
In Visual Studio
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.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||YES!!!
That was it. I used:
Definition.Extension = "ORACLE"
and the datasource was created successfully. Thank you so much for your
help. Sometimes the answer is right in front of your eyes yet one cannot see
it.
Once again, thanks.
Rob
"Reeves Smith" wrote:
> Rob,
> Here is my rs code that worked for me, looks the same but maybe give it a
> shot, the only thing i see if you have "Oracle" and i have "ORACLE", not sure
> if that is it.:
> Dim Definition As New DataSourceDefinition
> Dim Properties(1) As [Property]
> Dim Description As New [Property]
> Dim Hidden As New [Property]
> Description.Name = "Description"
> Description.Value = "DataSourceDescription"
> Hidden.Name = "Hidden"
> Hidden.Value = "False"
> Properties(0) = Description
> Properties(1) = Hidden
> Definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> Definition.UserName = "UserName"
> Definition.ConnectString = "Data Source=DATABASE;Unicode=True"
> Definition.Enabled = True
> Definition.Extension = "ORACLE"
> Definition.WindowsCredentials = False ' (Prompt and Store)
> Definition.ImpersonateUser = False ' (Store)
> Definition.EnabledSpecified = True
> Definition.ImpersonateUserSpecified = True
> Definition.OriginalConnectStringExpressionBased = False
> Definition.UseOriginalConnectString = False
>
> "Rob" wrote:
> > I am trying to create a .rss file that deploys my reports to the report
> > server. I have everything working except for the creation of the datasource.
> > The problem is that I am using an Oracle database and I cannot set the
> > correct setting in my code.
> >
> > I can create a datasource; but I have to log into the report server and
> > change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
> >
> > The below bit of code works (notice I am setting the Extension to SQL)
> > ...
> > Dim definition As New DataSourceDefinition()
> > definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> > definition.ConnectString = connectionString
> > definition.Enabled = True
> > definition.Extension = "SQL"
> > definition.ImpersonateUser = False
> > definition.ImpersonateUserSpecified = True
> > definition.WindowsCredentials = False
> > ...
> >
> > The below code DOES NOT work (I am setting the Extension to Oracle)
> > ...
> > Dim definition As New DataSourceDefinition()
> > definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> > definition.ConnectString = connectionString
> > definition.Enabled = True
> > definition.Extension = "Oracle"
> > definition.ImpersonateUser = False
> > definition.ImpersonateUserSpecified = True
> > definition.WindowsCredentials = False
> > ...
> >
> > There has to be some easy change here to get this to work with an Oracle
> > database, I just cannot find out what the Oracle string is to set the
> > Extension.
> >
> > Any ideas? Thanks for any help or suggestion.
> >
> > Rob
> >
> >

RS Utility- preserve folder structure and deploy RDSs

I am trying to figure out the RS command line utility. How do I
create/preserve a folder structure for organizing my reports, and how do I
deploy RDSs with this utility. Also, the sample script just shows how to
create data sources, not deploy the ones I have already created.
--
JasonThe RS.exe simply packages the SOAP API. So if you have an .RDS file,
you'll need to write parsing logic in your script to read the contents of it
and supply them to the CreateDataSource method.
BTW - there is no way to push a .rds file to the server; it's a file that is
used by the report designer while you're designing reports.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:F75E6394-E1CC-4C03-8F7F-0BC2B8CBFDFC@.microsoft.com...
>I am trying to figure out the RS command line utility. How do I
> create/preserve a folder structure for organizing my reports, and how do I
> deploy RDSs with this utility. Also, the sample script just shows how to
> create data sources, not deploy the ones I have already created.
> --
> Jason

RS utility - folder structure for storing reports

I am trying to use the RS utility for deploying reports I create to our
customers. I need to hand them an install CD that does everything. I can
deploy reports via RS, but I am wondering how to preserve a folder structure
for organizing the reports. Also, how do I script subscriptions, and deploy
RDSs. The sample MS provides creates a new data source, not use the ones I
have already created in report design.
Thanks,
--
JasonYou might want to have a look at Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
I haven't got around to subscriptions yet but it should handle most of you
requirements
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
>I am trying to use the RS utility for deploying reports I create to our
> customers. I need to hand them an install CD that does everything. I can
> deploy reports via RS, but I am wondering how to preserve a folder
> structure
> for organizing the reports. Also, how do I script subscriptions, and
> deploy
> RDSs. The sample MS provides creates a new data source, not use the ones
> I
> have already created in report design.
> Thanks,
> --
> Jason|||Thanks. Like like a great utility. Is it freeware?
"Jasper Smith" wrote:
> You might want to have a look at Reporting Services Scripter
> http://www.sqldbatips.com/showarticle.asp?ID=62
> I haven't got around to subscriptions yet but it should handle most of you
> requirements
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
> news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
> >I am trying to use the RS utility for deploying reports I create to our
> > customers. I need to hand them an install CD that does everything. I can
> > deploy reports via RS, but I am wondering how to preserve a folder
> > structure
> > for organizing the reports. Also, how do I script subscriptions, and
> > deploy
> > RDSs. The sample MS provides creates a new data source, not use the ones
> > I
> > have already created in report design.
> >
> > Thanks,
> > --
> > Jason
>
>

RS report integrated with .Net web app

I am trying to integrate a Reporting Services report within a .Net web
application. The easiest way to do this is to create a frame from within the
web application and link to the Reporting Services report. That way it
appears to be part of the application. But how can it be setup so that the
user doesn't have to log in twice? Once for the web application and then
again after they click on the link that goes to the Reporting Servies report.
How can I turn off the login prompt that comes up when the user clicks on
the link to the RS report but still lock down Report Manager? Also, how can
the roles be shared that is used from within the web application and the
reporting services report?Hi,
If you haven't resolved this issue first implement and install the Custom
Authentication Forms Authentication Example:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
and then see the following:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformsauthenticationacrossapplications.asp
Its actually quite simple to setup once you have configured and set up the
Custom Authentication Forms Authentication Example.
Good luck,
Nick @. INDATA
"David" wrote:
> I am trying to integrate a Reporting Services report within a .Net web
> application. The easiest way to do this is to create a frame from within the
> web application and link to the Reporting Services report. That way it
> appears to be part of the application. But how can it be setup so that the
> user doesn't have to log in twice? Once for the web application and then
> again after they click on the link that goes to the Reporting Servies report.
> How can I turn off the login prompt that comes up when the user clicks on
> the link to the RS report but still lock down Report Manager? Also, how can
> the roles be shared that is used from within the web application and the
> reporting services report?|||Did you get this to work? I am trying to do the same thing.
"David" wrote:
> I am trying to integrate a Reporting Services report within a .Net web
> application. The easiest way to do this is to create a frame from within the
> web application and link to the Reporting Services report. That way it
> appears to be part of the application. But how can it be setup so that the
> user doesn't have to log in twice? Once for the web application and then
> again after they click on the link that goes to the Reporting Servies report.
> How can I turn off the login prompt that comes up when the user clicks on
> the link to the RS report but still lock down Report Manager? Also, how can
> the roles be shared that is used from within the web application and the
> reporting services report?|||This is most likely a double hop issue. Windows NT Challenge Response does
not support double hop (in that once passed to the IIS server, the same
credentials cannot be passed to a back-end server for authentication). Do do
this you need to be using Kerberos. As far as Active Directory and Kerberos,
other than knowing you can do this, I don't know any more than that.
Another option, is to have RS on the same server as your app. The database
can be on a different machine. This does mean that you need to have a
license for SQL Server wherever RS is installed.
The other option is to implement Forms based authentication (i.e. you
provide the user authentication). This is non-trivial but is the method that
is used by people using RS over the internet.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Katie" <Katie@.discussions.microsoft.com> wrote in message
news:6A87F447-C852-4668-9542-3C7A19571C6D@.microsoft.com...
> Did you get this to work? I am trying to do the same thing.
> "David" wrote:
>> I am trying to integrate a Reporting Services report within a .Net web
>> application. The easiest way to do this is to create a frame from within
>> the
>> web application and link to the Reporting Services report. That way it
>> appears to be part of the application. But how can it be setup so that
>> the
>> user doesn't have to log in twice? Once for the web application and then
>> again after they click on the link that goes to the Reporting Servies
>> report.
>> How can I turn off the login prompt that comes up when the user clicks
>> on
>> the link to the RS report but still lock down Report Manager? Also, how
>> can
>> the roles be shared that is used from within the web application and the
>> reporting services report?

RS Authoring over the Internet

It appears that to enable true authoring over the internet, you need to
create local users on the RS/IIS box, and create identical SQL logins so
remote users can build their DSN's for their reports.
Other ideas?
JeffFor one, use AD groups in SQL.|||Nope, doesn't work. Just tried it again to verify. I created a local user on
the box, added him to a local group, created a login for the group, and
added the login to the database role.
When trying to connect over the internet using ISQLW for example, I get
"login failed for user 'erstesting'". Native SQL logins work just fine.
Jeff
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410131248.5c092472@.posting.google.com...
> For one, use AD groups in SQL.

RS and Oracle

Hello everyone. Does any one knows if it is possible to create reports in MS
Reporting services connected to Oracle DB in Visual Basic 2005 Express
edition?
If any one has done it before a few simple instructions will be greatly
appreciated.
Thank you.> Hello everyone. Does any one knows if it is possible to create reports in
> MS Reporting services connected to Oracle DB in Visual Basic 2005 Express
> edition?
RS can report ON any OLEDB comptable DBMS, meaning Oracle is fine. However,
RS itself cannot be installed onto Oracle, it is a feature of SQL Server
2000/2005.
If you want to report data from an Oracle database, you just enter the valid
connection credentials when creating your report, RS will do the rest.
Kind Regards
Taz

RS 2005: Subscription fails with Internal error

Hi all,

I have a (for me) strange problem with subscribing reports.

I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.

Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:

Failure writing file LIS04 : An internal error occurred on the report

server. See the error log for more details.

The Log file contains the following: (I highlighted what I think to be the key error)

ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
End of inner exception stack trace
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams

Does anyone have an idea what goes wrong here?

Best regards
Florian
Are you running 64 bit RS? If yes, it looks like a known problem that will be fixed in SP2.