Move RS log files

Is there a way to change the location of the Reporting Services Log Files?
I've seen several folks ask this question but no answer as of yet.
Thanks,
JoeYou need to modify the web.config and ReportingServicesService.exe.config
files. Look for the RSTrace element and add a new line like follows:
<add name="Directory" value="location you would like" />
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Clifford" <Joe Clifford@.discussions.microsoft.com> wrote in message
news:842A5546-99DC-455C-8B64-BCE09F86771C@.microsoft.com...
> Is there a way to change the location of the Reporting Services Log Files?
> I've seen several folks ask this question but no answer as of yet.
> Thanks,
> Joe
>
>

Move RS database to a new computer

we are aware of KB84245 Titled:
"How to move a Reporting Servides database from a computer that is running
Reporting Services to another computer".
this seems rather clear. But I have I a question.
Does this article assume the original DB is on the web server machine, and
if so would these
exact instructions apply to mvoing a database in a multi-tier arrangement.
By which I mean: in our case we have a Web Server and a Database Server.
The Web Server Hosts ReportingSservices and the Database Server hosts the
ReportingService DBs. We are moving our reportingservice DB to a different
database server.
are there additional/different instructions I should follow for a move in a
multi-tier arrangement? Are is this KB good to go for all situations?
thanks.
dlrHi Dennis,
I just successfully moved a RS database to a new server in a 2-tiered
environment, and the MS instructions worked perfectly. I backed up the 2
dbs to files, then restored them to the new db server. Then on the IIS
machine, I used rsconfig utility to reconfigure the db location/connection
info. I moved the reportserver component to a new IIS machine as well, so I
had to backup/restore the encryption keys, too - but I don't think you'll
have to do that, as you're not moving the reportserver.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Dennis Redfield wrote:
> we are aware of KB84245 Titled:
> "How to move a Reporting Servides database from a computer that is
> running Reporting Services to another computer".
> this seems rather clear. But I have I a question.
> Does this article assume the original DB is on the web server
> machine, and if so would these
> exact instructions apply to mvoing a database in a multi-tier
> arrangement.
> By which I mean: in our case we have a Web Server and a Database
> Server. The Web Server Hosts ReportingSservices and the Database
> Server hosts the ReportingService DBs. We are moving our
> reportingservice DB to a different database server.
> are there additional/different instructions I should follow for a
> move in a multi-tier arrangement? Are is this KB good to go for all
> situations?
> thanks.
> dlr|||well i did have problems. I moved the RS databases to a new server (which
was a clean SQL Server install with no prior RS history). and indeed
everything seemed to work fine until I got permission errors when attempting
a snap-shot execution. The problem:
RS creates an RSExecRole in the databases it creates AND in the master
database and adds your connection user to those roles. On the databases
moved to the new server theRSExecRole move along with the restore. The
master database on the new machine is not restored from anywhere, of course,
and thus IT DOES NOT HAVE THE RSExecRole. If you are using the prinicple of
least previlge and use a RS database connection user with few intrinsic
rights you will see the permission error. Solution: manually create the
RSExecRole in "master" and manually add your connection user to this role.
Easy but not fun in a disaster recovery situation.
dlr
"Jake Marx" <msnews@.longhead.com> wrote in message
news:OPxDc7PvEHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi Dennis,
> I just successfully moved a RS database to a new server in a 2-tiered
> environment, and the MS instructions worked perfectly. I backed up the 2
> dbs to files, then restored them to the new db server. Then on the IIS
> machine, I used rsconfig utility to reconfigure the db location/connection
> info. I moved the reportserver component to a new IIS machine as well, so
I
> had to backup/restore the encryption keys, too - but I don't think you'll
> have to do that, as you're not moving the reportserver.
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> Dennis Redfield wrote:
> > we are aware of KB84245 Titled:
> > "How to move a Reporting Servides database from a computer that is
> > running Reporting Services to another computer".
> >
> > this seems rather clear. But I have I a question.
> >
> > Does this article assume the original DB is on the web server
> > machine, and if so would these
> > exact instructions apply to mvoing a database in a multi-tier
> > arrangement.
> >
> > By which I mean: in our case we have a Web Server and a Database
> > Server. The Web Server Hosts ReportingSservices and the Database
> > Server hosts the ReportingService DBs. We are moving our
> > reportingservice DB to a different database server.
> >
> > are there additional/different instructions I should follow for a
> > move in a multi-tier arrangement? Are is this KB good to go for all
> > situations?
> >
> > thanks.
> >
> > dlr
>

Move Reporting Services Web Installation to another Web Server

Move Reporting Services Web Installation to another Web ServerI assume this is RS 2000. You may want to check this KB article (in
particular the second section of the article):
http://support.microsoft.com/default.aspx?scid=842425
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Ennamorato" <PaulEnnamorato@.discussions.microsoft.com> wrote in
message news:2C6E33F4-A377-4803-9A8B-B46CBE7E5662@.microsoft.com...
>

Move Reporting Services Database

I need to move the database for reporting services from one server to
another. I know how to move the database itself. Could someone tell me what
needs to be changed to make reporting services use the database on the new
server?
Thanks.
TTRun RSConfig. Check out MSKB 842425 for details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
--
Hope this helps.
Dan Guzman
SQL Server MVP
"TT" <TT@.discussions.microsoft.com> wrote in message
news:032668B1-5316-425C-8258-1780644FE7A3@.microsoft.com...
>I need to move the database for reporting services from one server to
> another. I know how to move the database itself. Could someone tell me
> what
> needs to be changed to make reporting services use the database on the new
> server?
> Thanks.
> TT
>|||Thanks a lot.
"Dan Guzman" wrote:
> Run RSConfig. Check out MSKB 842425 for details:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "TT" <TT@.discussions.microsoft.com> wrote in message
> news:032668B1-5316-425C-8258-1780644FE7A3@.microsoft.com...
> >I need to move the database for reporting services from one server to
> > another. I know how to move the database itself. Could someone tell me
> > what
> > needs to be changed to make reporting services use the database on the new
> > server?
> >
> > Thanks.
> >
> > TT
> >
>
>

move report to other machine

Hi,
How can I move a report I developed in my computer (in Reporting Services
for SQL Server 2000) to another computer that already has SQL Server 2000
and Reporting Services installed?
Is it with Import/Export, generated scripts, ... ?
Thanks,
Nuno MachadoCopy your RDL file from your computer, to the other computer.
Go to Report Manager on the other computer, and click on the Upload File
button.
Find your RDL file where you copied it to and upload it.
Try your report.
You might have to create new datasources on the other report server. Just
copy whatever settings you have on the first one and do any adjustments you
need to do.
If you can access the other server from your computer (type in
http://whatever/reportserver ), then you don't have to copy the file, just
upload it from your web page. Or try deploying it directly through Visual
Studio, if you have the right access rights.
Kaisa M: Lindahl
"Nuno Machado" <nuno.machado@.vpconsulting.pt> wrote in message
news:er%23rSxCHGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi,
> How can I move a report I developed in my computer (in Reporting Services
> for SQL Server 2000) to another computer that already has SQL Server 2000
> and Reporting Services installed?
> Is it with Import/Export, generated scripts, ... ?
> Thanks,
> Nuno Machado
>

Move linked reports to new server

I am moving reporting services to a new server and I want to move the
reports, file structure, and linked reports over as well. I have created a
few parameterized base reports that I can simply re-deploy, but there are
numerous linked reports - they run specific parameters on a scheduled basis
and distribute via subscriptions - that were created on the server itself.
Is there any simple way to move the linked reports over to the new server?
Perhaps go into the old server and just grab certain files and copy them over?The easiest way is to write a script file to do this (or .Net program using
SOAP). There is no easy way using the UI.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Echinodermata" <Echinodermata@.discussions.microsoft.com> wrote in message
news:14E5B132-F351-42D1-8B74-92152FB5E60C@.microsoft.com...
>I am moving reporting services to a new server and I want to move the
> reports, file structure, and linked reports over as well. I have created
> a
> few parameterized base reports that I can simply re-deploy, but there are
> numerous linked reports - they run specific parameters on a scheduled
> basis
> and distribute via subscriptions - that were created on the server itself.
> Is there any simple way to move the linked reports over to the new server?
> Perhaps go into the old server and just grab certain files and copy them
> over?
>|||Does anyone know of any example scripts on how to copy reports to a server? I
have a product that I am distributing - part of it utilizes reports in
reporting services - I would like to be able to install those reports with a
setup program - has anyone done this? If someone could point me in the right
direction, it would be greatly appreciated.
"Daniel Reib [MSFT]" wrote:
> The easiest way is to write a script file to do this (or .Net program using
> SOAP). There is no easy way using the UI.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Echinodermata" <Echinodermata@.discussions.microsoft.com> wrote in message
> news:14E5B132-F351-42D1-8B74-92152FB5E60C@.microsoft.com...
> >I am moving reporting services to a new server and I want to move the
> > reports, file structure, and linked reports over as well. I have created
> > a
> > few parameterized base reports that I can simply re-deploy, but there are
> > numerous linked reports - they run specific parameters on a scheduled
> > basis
> > and distribute via subscriptions - that were created on the server itself.
> >
> > Is there any simple way to move the linked reports over to the new server?
> > Perhaps go into the old server and just grab certain files and copy them
> > over?
> >
>
>

MS Reports with out SQL Server

I have a customer using Oracle DB and Oracle Reports (older version), they
need the feature to export reports to excel and like the MS Reporting
Services format. Most of the reports have already been developed in VS2k3
for another customer that uses strictly MS SQL and I have converted these to
VS2k5 and been looking at the ReportViewer winform and webform controls. I
would like to use it in local mode because this customer doesnâ't want a
SQLServer installed anywhere. Ideally I would just like to pass an Oracle DB
connection string to the report viewer and let the SQL in the rdl file do its
work. But, as I understand it, I have to pass the DataTable directly to the
report when using local mode? So is there anyway to open an rdl file and
obtain the SQL? I can then query the DB and pass the resulting data back to
the ReportViewer.LocalReport.DataSource. Any example code would help, I
canâ't imagine all this is required just to run a simple report without a
SSRS? My customer now wants me to consider using crystal reports instead but
I would like to stay on the MS format. Will there be any better options for
this situation in future versions of ReportingServices or the ReportViewer?There are so many examples on the web.
What seems to be a problem?
You can pass any data- no sql server required.
Can't you do something like that?
DataTable reportData = _controller.GetReportData();
rview.LocalReport.DataSources.Clear();
rview.Clear();
rview.Reset();
byte[] data = GetRDL();
MemoryStream ms = new MemoryStream(data);
rview.ProcessingMode = ProcessingMode.Local;
rview.LocalReport.LoadReportDefinition(ms);
ReportDataSource rds = new ReportDataSource("ds", reportData);
rview.LocalReport.DataSources.Add(rds);
rview.RefreshReport();
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:AE726184-FFE0-4297-974D-C795D02F0E38@.microsoft.com...
>I have a customer using Oracle DB and Oracle Reports (older version), they
> need the feature to export reports to excel and like the MS Reporting
> Services format. Most of the reports have already been developed in VS2k3
> for another customer that uses strictly MS SQL and I have converted these
> to
> VS2k5 and been looking at the ReportViewer winform and webform controls. I
> would like to use it in local mode because this customer doesn't want a
> SQLServer installed anywhere. Ideally I would just like to pass an Oracle
> DB
> connection string to the report viewer and let the SQL in the rdl file do
> its
> work. But, as I understand it, I have to pass the DataTable directly to
> the
> report when using local mode? So is there anyway to open an rdl file and
> obtain the SQL? I can then query the DB and pass the resulting data back
> to
> the ReportViewer.LocalReport.DataSource. Any example code would help, I
> can't imagine all this is required just to run a simple report without a
> SSRS? My customer now wants me to consider using crystal reports instead
> but
> I would like to stay on the MS format. Will there be any better options
> for
> this situation in future versions of ReportingServices or the
> ReportViewer?|||hey buddy i am so sorry that Oracle doesn't have as many features as
SQL Server does.
you should tell them to re-evaluate their database of choice.
-Aaron
Oleg Yevteyev myfistname wrote:
> There are so many examples on the web.
> What seems to be a problem?
> You can pass any data- no sql server required.
> Can't you do something like that?
> DataTable reportData = _controller.GetReportData();
> rview.LocalReport.DataSources.Clear();
> rview.Clear();
> rview.Reset();
> byte[] data = GetRDL();
> MemoryStream ms = new MemoryStream(data);
> rview.ProcessingMode = ProcessingMode.Local;
> rview.LocalReport.LoadReportDefinition(ms);
> ReportDataSource rds = new ReportDataSource("ds", reportData);
> rview.LocalReport.DataSources.Add(rds);
> rview.RefreshReport();
>
> "Drew" <Drew@.discussions.microsoft.com> wrote in message
> news:AE726184-FFE0-4297-974D-C795D02F0E38@.microsoft.com...
> >I have a customer using Oracle DB and Oracle Reports (older version), they
> > need the feature to export reports to excel and like the MS Reporting
> > Services format. Most of the reports have already been developed in VS2k3
> > for another customer that uses strictly MS SQL and I have converted these
> > to
> > VS2k5 and been looking at the ReportViewer winform and webform controls. I
> > would like to use it in local mode because this customer doesn't want a
> > SQLServer installed anywhere. Ideally I would just like to pass an Oracle
> > DB
> > connection string to the report viewer and let the SQL in the rdl file do
> > its
> > work. But, as I understand it, I have to pass the DataTable directly to
> > the
> > report when using local mode? So is there anyway to open an rdl file and
> > obtain the SQL? I can then query the DB and pass the resulting data back
> > to
> > the ReportViewer.LocalReport.DataSource. Any example code would help, I
> > can't imagine all this is required just to run a simple report without a
> > SSRS? My customer now wants me to consider using crystal reports instead
> > but
> > I would like to stay on the MS format. Will there be any better options
> > for
> > this situation in future versions of ReportingServices or the
> > ReportViewer?

MS Reporting, Oracle

Hi,
when I try to run a select-statement to an oracle database (10.1.03) with a
parameter from the SQL-area in MS Reporting I get a message like:
'The provider can not determine parameter information and setParameterInfo'
is not called' (or similar, the original message is in german).
The select statement is like:
SELECT LOT, MACHINENUM, ARTICLE10, ARTICLEVARIANT, MEAS_MODE,
TOTALCOUNT, PDATE_START, PDATE_END, GRINDCLASS, GRINDLIMIT
FROM TBLLOT
WHERE (MACHINENUM = @.machineNum)
ORDER BY LOT
There is no problem without the parameter, and there is no problem with the
parameter when I use a SQLServer DB.
Can someone help?
Thanks
Ulf
@.param is SQL Server specific, from BOL
Support for parameters in Oracle depends on the data provider that is used
to connect to the Oracle database. If your query contains named parameters
(for example, SELECT * FROM <table> WHERE <column name> = :ParameterName)
then you must use the Oracle data processing extension. If your query
contains unnamed parameters (for example, SELECT * FROM <table> WHERE
<column name> = ?), then you must use the OLE DB data processing extension
and select Microsoft OLE DB Provider for Oracle as a data provider
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Ulf" <Ulf@.discussions.microsoft.com> wrote in message
news:AFA90B76-8342-4EBA-AF07-BA5B01A78715@.microsoft.com...
> Hi,
> when I try to run a select-statement to an oracle database (10.1.03) with
> a
> parameter from the SQL-area in MS Reporting I get a message like:
> 'The provider can not determine parameter information and
> setParameterInfo'
> is not called' (or similar, the original message is in german).
> The select statement is like:
> SELECT LOT, MACHINENUM, ARTICLE10, ARTICLEVARIANT, MEAS_MODE,
> TOTALCOUNT, PDATE_START, PDATE_END, GRINDCLASS, GRINDLIMIT
> FROM TBLLOT
> WHERE (MACHINENUM = @.machineNum)
> ORDER BY LOT
> There is no problem without the parameter, and there is no problem with
> the
> parameter when I use a SQLServer DB.
> Can someone help?
> Thanks
> Ulf
|||Hi Jasper,
thank you for your answer. But this answer does not solve my problem. It is
simply not possible to use a syntax like :parameter in MS Reporting, and I
have had no success with unnamed parameters. It also seems like a MS
Reporting problem (or bug). I expect that MS Reporting will replace my
parameter (@.machineNum) with the value before sendeing the statement to
Oracle but may be I am wrong in this point.
I need a method to send a select-statement to Oracle with consideartion of
a user input. May be stored procedures will help but I prefer not to use
them.
ulf
"Ulf" wrote:

> Hi,
> when I try to run a select-statement to an oracle database (10.1.03) with a
> parameter from the SQL-area in MS Reporting I get a message like:
> 'The provider can not determine parameter information and setParameterInfo'
> is not called' (or similar, the original message is in german).
> The select statement is like:
> SELECT LOT, MACHINENUM, ARTICLE10, ARTICLEVARIANT, MEAS_MODE,
> TOTALCOUNT, PDATE_START, PDATE_END, GRINDCLASS, GRINDLIMIT
> FROM TBLLOT
> WHERE (MACHINENUM = @.machineNum)
> ORDER BY LOT
> There is no problem without the parameter, and there is no problem with the
> parameter when I use a SQLServer DB.
> Can someone help?
> Thanks
> Ulf
|||Hi Jasper,
thank you for your answer. But this answer does not solve my problem. It is
simply not possible to use a syntax like :parameter in MS Reporting, and I
have had no success with unnamed parameters. It also seems like a MS
Reporting problem (or bug). I expect that MS Reporting will replace my
parameter (@.machineNum) with the value before sendeing the statement to
Oracle but may be I am wrong in this point.
I need a method to send a select-statement to Oracle with consideartion of
a user input. May be stored procedures will help but I prefer not to use
them.
ulf
"Jasper Smith" wrote:

> @.param is SQL Server specific, from BOL
> Support for parameters in Oracle depends on the data provider that is used
> to connect to the Oracle database. If your query contains named parameters
> (for example, SELECT * FROM <table> WHERE <column name> = :ParameterName)
> then you must use the Oracle data processing extension. If your query
> contains unnamed parameters (for example, SELECT * FROM <table> WHERE
> <column name> = ?), then you must use the OLE DB data processing extension
> and select Microsoft OLE DB Provider for Oracle as a data provider
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Ulf" <Ulf@.discussions.microsoft.com> wrote in message
> news:AFA90B76-8342-4EBA-AF07-BA5B01A78715@.microsoft.com...
>
>

Ms Reporting Services install

Where can I find the Reporting Service setup ?
Is it linked to a particular version of SQLServer 2000 (Standard...)
On the CD ?SQL Server 2000 Reporting Services is not a part of a SQL installation, it comes on different CD. It also comes in different edditions (Standard, Advanced, Development...).|||HI ,

To have it function properly ,you will need visual studio.net 2003

MS Reporting Services Error

I have MS RS installed on the W2K3 EE member server, SQL 2000 SP4 and IIS 6
are also installed on the same machine.
For some reason when I connect to:
http://<servername>/reports
or
http://<IP>/reports
or
http://<Localhost>/reports
I'm showed the error message:
"The underlying connection was closed: Unable to connect to the remote
server."
From checking the web and this newsgroup it is clear that there is very
little information about this which leads me to believe this must be some
obvious setting that most people are aware of. Can anyone provide assistance?
Thanks in Advance,
CRHave you checked the event logs on the server?
One other things that come to mind is connection timeouts.
Check the newsgroup on how to change this.
I did have an issue installing RS on a domain controller basically it
didn't set up the ASPNet user properly but I was generally getting
permission denied problems with this one.
Chris
CR wrote:
> I have MS RS installed on the W2K3 EE member server, SQL 2000 SP4 and
> IIS 6 are also installed on the same machine.
> For some reason when I connect to:
> http://<servername>/reports
> or
> http://<IP>/reports
> or
> http://<Localhost>/reports
> I'm showed the error message:
> "The underlying connection was closed: Unable to connect to the
> remote server."
> From checking the web and this newsgroup it is clear that there is
> very little information about this which leads me to believe this
> must be some obvious setting that most people are aware of. Can
> anyone provide assistance?
> Thanks in Advance,
> CR

MS Reporting Services and Passing Credentials from .NET App

Expert Needed,
Is it possible to pass credentials from a .NET application into MS reporting
services?
For example we want to filter our data for our reports based on the user's
login into the .NET app.
Thank you in advance.
RichI am trying to do the very same thing from a .Net windows application and if
get it will post my results.
Dan
"Rich" <rwatson@.brick.net> wrote in message
news:eNq3unf9FHA.3664@.TK2MSFTNGP10.phx.gbl...
> Expert Needed,
> Is it possible to pass credentials from a .NET application into MS
> reporting
> services?
> For example we want to filter our data for our reports based on the user's
> login into the .NET app.
> Thank you in advance.
> Rich
>|||The recommended approach will be the use RS custom security if you need to
pass the user credentials. Alternatively, once the application
authenticates, it can use a single "trusted" Wi ndows account to connect and
authenticates against RS.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Rich" <rwatson@.brick.net> wrote in message
news:eNq3unf9FHA.3664@.TK2MSFTNGP10.phx.gbl...
> Expert Needed,
> Is it possible to pass credentials from a .NET application into MS
> reporting
> services?
> For example we want to filter our data for our reports based on the user's
> login into the .NET app.
> Thank you in advance.
> Rich
>|||Is possible to pass credentials, you need to include in your .NET
application a reference to Web Services that is installed on Server that had
Reporting Services. Then, you can use all the method that this web services
expose, as
ReportingService rs = new ReportingService();
System.Net.NetworkCredential cr = new System.Net.NetworkCredential(UserName,
Password, Domain);
rs.Credentials = cr;
I hope that this help you.
"Rich" <rwatson@.brick.net> wrote in message
news:eNq3unf9FHA.3664@.TK2MSFTNGP10.phx.gbl...
> Expert Needed,
> Is it possible to pass credentials from a .NET application into MS
reporting
> services?
> For example we want to filter our data for our reports based on the user's
> login into the .NET app.
> Thank you in advance.
> Rich
>

MS Reporting Services 2000 Error ?

hi

when i try to use Reporting Services to render a report from aspx page

(web app) (vb.net) by usingReportingServices.dll (by add referennces)

i am not using (web referennces)

i get this erorr :

==================

System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.RSException .

note:

=====

- i have windows 2003 server ent.

- sql 2000 sp3 .

- MS Reporting Services 2000 sp2 .

- i am login as administrator .

pls tell me what i can do ?

thank you all

Hi,

as you did not post any code, I can give you a common suggestion. If you use impersonation, you will have to use the credentials of the actual user and add it to the instantiated proxy of the webservice. This will make the call to the webservice under the credentials and the permissions of the impersonated user.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Correct me if I'm wrong, but if you don't do this then it uses the identity of the app pool under which the website runs which by default is network service for the default app pool|||yep.

MS Reporting Services

I want to install reporting services. Where can I get a copy? Thanks.for SQL Server 2000

othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

I want to install reporting services. Where can I get a copy? Thanks.

|||Forget it. I tried to install it after downloading. It asks for too
many things (IIS, ASP net, .net blah blah blah) and at the end asks for
service pack 3. I am not going to install Microsoft Software after this
experience (any software). Enough.

othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

for SQL Server 2000
>
othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

I want to install reporting services. Where can I get a copy? Thanks.

|||On 16 Jan 2007 01:16:36 -0800, othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

>Forget it. I tried to install it after downloading. It asks for too
>many things (IIS, ASP net, .net blah blah blah) and at the end asks for
>service pack 3. I am not going to install Microsoft Software after this
>experience (any software). Enough.
>
>othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

>for SQL Server 2000
>>
>othellomy@.yahoo.com wrote:

Quote:

Originally Posted by

I want to install reporting services. Where can I get a copy? Thanks.

Yes, it uses IIS as the presentation layer. Why would you write a new
one when a good one already exists?

MS Reporting Service for Client Application

1. We have Thin Client which is connecting to the Sql Express database. Is it
possible to use MS Reporting Service in Sql Express database.
2. What are the pre requisites shoule be there in my thin client to see my
reports in the thin client.SQL Express is not supported for RS 2000. It will be supported for RS 2005
with SQL Express but this will be a release after the release of SQL Server
2005. My understanding is sometime in the first half of next year.
What is your thin client? You can integrate reporting services multiple
ways. You can use URL integration (IE 6 works best). You can use web
services. Also, Visual Studio 2005 will have 2 controls, a winform and a
webform control. Note that these can work in local mode where no server is
required. There are some limitations (for instance you lose some exporting
formats, no scheduling etc) but in general pretty fully functional. You give
it a dataset and a report. Depending on what you want this might fulfill
your needs. In that case Express is just a datasource that you get your
dataset from. These controls will work in local mode with the release of VS
2005 (November).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mohan" <Mohan@.discussions.microsoft.com> wrote in message
news:100416CF-2203-4D42-A5D6-2D17328AE7D0@.microsoft.com...
> 1. We have Thin Client which is connecting to the Sql Express database. Is
> it
> possible to use MS Reporting Service in Sql Express database.
> 2. What are the pre requisites shoule be there in my thin client to see my
> reports in the thin client.
>|||Hi Bruce,
Thanks for you reply.
My Requrments is I want to view a report in my thin client(windows
applicaion). what the pre requisits need in the client applicaion.
Regards
Mohan
"Bruce L-C [MVP]" wrote:
> SQL Express is not supported for RS 2000. It will be supported for RS 2005
> with SQL Express but this will be a release after the release of SQL Server
> 2005. My understanding is sometime in the first half of next year.
> What is your thin client? You can integrate reporting services multiple
> ways. You can use URL integration (IE 6 works best). You can use web
> services. Also, Visual Studio 2005 will have 2 controls, a winform and a
> webform control. Note that these can work in local mode where no server is
> required. There are some limitations (for instance you lose some exporting
> formats, no scheduling etc) but in general pretty fully functional. You give
> it a dataset and a report. Depending on what you want this might fulfill
> your needs. In that case Express is just a datasource that you get your
> dataset from. These controls will work in local mode with the release of VS
> 2005 (November).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mohan" <Mohan@.discussions.microsoft.com> wrote in message
> news:100416CF-2203-4D42-A5D6-2D17328AE7D0@.microsoft.com...
> > 1. We have Thin Client which is connecting to the Sql Express database. Is
> > it
> > possible to use MS Reporting Service in Sql Express database.
> >
> > 2. What are the pre requisites shoule be there in my thin client to see my
> > reports in the thin client.
> >
> >
>
>|||RS 2005 for Express is not available yet even in beta form. The controls are
available with the Visual Studio beta (which is currently release
candidate). The controls are free with VS. No licensing needed to create or
run the report. All is client side, you provide the report, you provide the
dataset. If you need server side and express then you will have to wait
until that combination is released next year. My understanding is that
Express has some other limitations (for instance, I think the data you are
going after has to be on the same box as the report, it doesn't support
cubes, etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mohan" <Mohan@.discussions.microsoft.com> wrote in message
news:422C3A50-41A2-4F0B-94DA-6BE627D0FBAC@.microsoft.com...
> Hi Bruce,
> Thanks for you reply.
> My Requrments is I want to view a report in my thin client(windows
> applicaion). what the pre requisits need in the client applicaion.
> Regards
> Mohan
> "Bruce L-C [MVP]" wrote:
>> SQL Express is not supported for RS 2000. It will be supported for RS
>> 2005
>> with SQL Express but this will be a release after the release of SQL
>> Server
>> 2005. My understanding is sometime in the first half of next year.
>> What is your thin client? You can integrate reporting services multiple
>> ways. You can use URL integration (IE 6 works best). You can use web
>> services. Also, Visual Studio 2005 will have 2 controls, a winform and a
>> webform control. Note that these can work in local mode where no server
>> is
>> required. There are some limitations (for instance you lose some
>> exporting
>> formats, no scheduling etc) but in general pretty fully functional. You
>> give
>> it a dataset and a report. Depending on what you want this might fulfill
>> your needs. In that case Express is just a datasource that you get your
>> dataset from. These controls will work in local mode with the release of
>> VS
>> 2005 (November).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Mohan" <Mohan@.discussions.microsoft.com> wrote in message
>> news:100416CF-2203-4D42-A5D6-2D17328AE7D0@.microsoft.com...
>> > 1. We have Thin Client which is connecting to the Sql Express database.
>> > Is
>> > it
>> > possible to use MS Reporting Service in Sql Express database.
>> >
>> > 2. What are the pre requisites shoule be there in my thin client to see
>> > my
>> > reports in the thin client.
>> >
>> >
>>

MS Reporting on internet with Forms Authentication

Could anyone tell me if you have had any success and are currently
running MS Reporting Services on the Internet with Forms
Authentication, using the Ufairs example from Microsoft?
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
Can you actually do this? I can make this work on my intranet, but
unfortunately, I have been unable to make the transition to the
Internet. If you have been able to make this work, here is my problem.
When I am in the ulogin web page and enter in the correct username and
password, I am returned back to the ulogin page. I think this is a
cookie issue. I have been working with Microsoft support for this, but
have been unable to make this work.
Any suggestion? Any help will be greatly appreciated.
Thank you for your time in advance.Daniel - I don't believe that being returned to the login page mean you have
an issue if you are attempting the url http://localhost/reports/, try
http://localhost/reports/Pages/Folder.aspx and you should be ok
Hope this helps,
Michael
"Daniel" wrote:
> Could anyone tell me if you have had any success and are currently
> running MS Reporting Services on the Internet with Forms
> Authentication, using the Ufairs example from Microsoft?
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> Can you actually do this? I can make this work on my intranet, but
> unfortunately, I have been unable to make the transition to the
> Internet. If you have been able to make this work, here is my problem.
> When I am in the ulogin web page and enter in the correct username and
> password, I am returned back to the ulogin page. I think this is a
> cookie issue. I have been working with Microsoft support for this, but
> have been unable to make this work.
> Any suggestion? Any help will be greatly appreciated.
> Thank you for your time in advance.
>|||Michael
Thank you for your quick response. I made sure I was calling with the
"/Pages/Folder.aspx" added on with the same results.
The only difference was I called via the Internet(which is my issue,
not the Intranet)
http://www.mywebsite.com/reports/Pages/Folder.aspx
Any other ideas? I am truely lost here trying to make this work.
Again, Thank you all for any help.
Michael Nichols wrote:
> Daniel - I don't believe that being returned to the login page mean
you have
> an issue if you are attempting the url http://localhost/reports/, try
> http://localhost/reports/Pages/Folder.aspx and you should be ok
> Hope this helps,
> Michael
> "Daniel" wrote:
> > Could anyone tell me if you have had any success and are currently
> > running MS Reporting Services on the Internet with Forms
> > Authentication, using the Ufairs example from Microsoft?
> >
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> >
> > Can you actually do this? I can make this work on my intranet, but
> > unfortunately, I have been unable to make the transition to the
> > Internet. If you have been able to make this work, here is my
problem.
> >
> > When I am in the ulogin web page and enter in the correct username
and
> > password, I am returned back to the ulogin page. I think this is a
> > cookie issue. I have been working with Microsoft support for this,
but
> > have been unable to make this work.
> >
> > Any suggestion? Any help will be greatly appreciated.
> >
> > Thank you for your time in advance.
> >
> >|||Daniel - I'm not sure if this will help you, but my last post should have
been to change the url to: http://<your
server>/Reports/Pages/Folder.aspx?ViewMode=List.
While I implemented this on our Intranet, I have not implemented this on the
Internet, so you may be dealing with an issue different then I encountered.
"Daniel" wrote:
> Michael
> Thank you for your quick response. I made sure I was calling with the
> "/Pages/Folder.aspx" added on with the same results.
> The only difference was I called via the Internet(which is my issue,
> not the Intranet)
> http://www.mywebsite.com/reports/Pages/Folder.aspx
> Any other ideas? I am truely lost here trying to make this work.
> Again, Thank you all for any help.
>
>
>
> Michael Nichols wrote:
> > Daniel - I don't believe that being returned to the login page mean
> you have
> > an issue if you are attempting the url http://localhost/reports/, try
> > http://localhost/reports/Pages/Folder.aspx and you should be ok
> >
> > Hope this helps,
> > Michael
> > "Daniel" wrote:
> >
> > > Could anyone tell me if you have had any success and are currently
> > > running MS Reporting Services on the Internet with Forms
> > > Authentication, using the Ufairs example from Microsoft?
> > >
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> > >
> > > Can you actually do this? I can make this work on my intranet, but
> > > unfortunately, I have been unable to make the transition to the
> > > Internet. If you have been able to make this work, here is my
> problem.
> > >
> > > When I am in the ulogin web page and enter in the correct username
> and
> > > password, I am returned back to the ulogin page. I think this is a
> > > cookie issue. I have been working with Microsoft support for this,
> but
> > > have been unable to make this work.
> > >
> > > Any suggestion? Any help will be greatly appreciated.
> > >
> > > Thank you for your time in advance.
> > >
> > >
>|||Michael,
I changed my url and was still was redirected to the "UILogon.aspx"
page.
I thought this was a cookie issue, and somewhat still do. But I read an
article on a TCP sniffer
(http://www.devx.com/dotnet/Article/27133/0/page/5) and tried tcptrace
program (http://www.pocketsoap.com/tcptrace/).
When I run the internet version www.mywebsite.com/reports, I see the
cookie
Cookie:
sqlAuthCookie=C8E363B83D175024F7E26E07AEF5D9B9DDD62ECB2A66ACA884D02455BA3F198013694C187FC3059544B83E3F731351376669B8501DE866EAB97B51375FDD8867308454050AE23350
Thank you Michael for you insight.
If anyone has any success in making this work, I would deeply
appreciate you assistance.
Thank you
Daniel
Michael Nichols wrote:
> Daniel - I'm not sure if this will help you, but my last post should
have
> been to change the url to: http://<your
> server>/Reports/Pages/Folder.aspx?ViewMode=List.
> While I implemented this on our Intranet, I have not implemented this
on the
> Internet, so you may be dealing with an issue different then I
encountered.
>
>
> "Daniel" wrote:
> > Michael
> >
> > Thank you for your quick response. I made sure I was calling with
the
> > "/Pages/Folder.aspx" added on with the same results.
> >
> > The only difference was I called via the Internet(which is my
issue,
> > not the Intranet)
> >
> > http://www.mywebsite.com/reports/Pages/Folder.aspx
> >
> > Any other ideas? I am truely lost here trying to make this work.
> >
> > Again, Thank you all for any help.
> >
> >
> >
> >
> >
> >
> >
> > Michael Nichols wrote:
> > > Daniel - I don't believe that being returned to the login page
mean
> > you have
> > > an issue if you are attempting the url http://localhost/reports/,
try
> >
> > > http://localhost/reports/Pages/Folder.aspx and you should be ok
> > >
> > > Hope this helps,
> > > Michael
> > > "Daniel" wrote:
> > >
> > > > Could anyone tell me if you have had any success and are
currently
> > > > running MS Reporting Services on the Internet with Forms
> > > > Authentication, using the Ufairs example from Microsoft?
> > > >
> >
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> > > >
> > > > Can you actually do this? I can make this work on my intranet,
but
> > > > unfortunately, I have been unable to make the transition to the
> > > > Internet. If you have been able to make this work, here is my
> > problem.
> > > >
> > > > When I am in the ulogin web page and enter in the correct
username
> > and
> > > > password, I am returned back to the ulogin page. I think this
is a
> > > > cookie issue. I have been working with Microsoft support for
this,
> > but
> > > > have been unable to make this work.
> > > >
> > > > Any suggestion? Any help will be greatly appreciated.
> > > >
> > > > Thank you for your time in advance.
> > > >
> > > >
> >
> >|||Oh,
I would like to point out while you guys think of anything, I can go to
http://www.mywebsite.com/Reportserver , enter in the username and
password and the redirect works like a champ. I can see the
reportserver listing.
More confused than ever...Of course any ideas would be helpful.
<<Knocks on the reporting services development team's door and hopes
someone will answer>>|||Daniel,
I am running into this exact issue, Were you able to resolve this,
I think your guess is correct IE somehow does not pass the cookie(only reason
would be it it sees them as different domains)
Let me know if you can,
thanks,
Rakesh
"Daniel" wrote:
> Oh,
> I would like to point out while you guys think of anything, I can go to
> http://www.mywebsite.com/Reportserver , enter in the username and
> password and the redirect works like a champ. I can see the
> reportserver listing.
> More confused than ever...Of course any ideas would be helpful.
> <<Knocks on the reporting services development team's door and hopes
> someone will answer>>
>|||Rakesh
Thank you for your interest in this issue. I know I am not the only one
out there trying to make Reporting Services work in the Internet with
Forms Authentication. I feel confident that someone has made this
function.
I am currently working with Microsoft on this issue. As a matter of
fact, I just got off the phone with a manager in the Reporting Services
Support group. I should have some word tomorrow. When I find something
out, I will post here to help others. I know frustrating feeling you
are having with this problem. Hopefully through the trials and
tribulations I am going thru, I can smooth out your troubles a bit.
In the meantime, if anyone has any suggestions please feel free to
post.
Thank you!
Danny|||2 places I think control this behavior: The Webapplication.confi
loginUrl and the IIS virtual directory properties for defaul
content
You will need to adjust these until you find the right mix
Chances are you want the virtual directory default content pointed t
your login page and try the home.aspx page for your loginurl in th
webapplication.config setting