"Jeff McAhren" <Jeff McAhren@discussions.microsoft.com> wrote in message
news:5224E8E7-E5C3-4300-A6F8-7FB4FCB94B0B@microsoft.com...
> Our app platform consists of a MSSQL2k sp3 database server, and a Domino
> web
> server with CE9 installed.
>
> We currently run only unmanaged reports that are called via URL's from the
> client. We don't use the CE report manager console or anything like that.
>
> 1) Is this possible with MSRS?.. to call reports from URL's without a
> report manager?

>
> 2) Our current reporting app, CE, is installed on our web server. I take
> it that we would install MSRS on our SQL database server, correct? Does
> that
> server have to have IIS installed? We currently have IIS running on our
> web
> server, would that work?

>
> 3) I assume that we could still serve reports from CE at the same time
> that
> we serve reports from MSRS. Any issues with this?
Shouldn't matter. Just another asp.net application
>
> Thanks!
>
>

"Bruce L-C [MVP]" wrote:

> See answers in line:
>
> "Jeff McAhren" <Jeff McAhren@discussions.microsoft.com> wrote in message
> news:5224E8E7-E5C3-4300-A6F8-7FB4FCB94B0B@microsoft.com...
> > Our app platform consists of a MSSQL2k sp3 database server, and a Domino
> > web
> > server with CE9 installed.
> >
> > We currently run only unmanaged reports that are called via URL's from the
> > client. We don't use the CE report manager console or anything like that.
> >
> > 1) Is this possible with MSRS?.. to call reports from URL's without a
> > report manager?
> yes. You can either integrate with URL integration or with web services.
> Also, there are new controls with VS 2005 that work with RS 2005 that
> provide very good integration (note that RS 2005 can be installed using SQL
> Server 2000 db as its object/metadata store).
> >
> > 2) Our current reporting app, CE, is installed on our web server. I take
> > it that we would install MSRS on our SQL database server, correct? Does
> > that
> > server have to have IIS installed? We currently have IIS running on our
> > web
> > server, would that work?
> RS is an asp.net app. It is 1.1 app if RS 2000, RS 2005 is 2.0 framework.
> You can run on your web server installed but you need to have a SQL Server
> license on the box that is running RS. If you do this, I suggest doing RS
> 2005 since you would be buying a license anyway. RS 2005 has lots of good
> additional features, is faster and you have the option of using the new VS
> controls.
> >
> > 3) I assume that we could still serve reports from CE at the same time
> > that
> > we serve reports from MSRS. Any issues with this?
> Shouldn't matter. Just another asp.net application
> >
> > Thanks!
> >
> >
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>