Monday, March 12, 2012

Reporting services install question

I know ReportServer is a SQL Server service. Do I need SQL Server on the IIS
/ Report Server machine. What if I don't want to use a local SQL Server, but
I want to use a standalone SQL Server.
frankmReportServer is an asp.net application. It requires SQL Server as an object
store. SQL Server can be either on the same machine, on a different machine
or on a different machine shared by multiple Report Servers (web farm). Note
that for licensing you need to have a SQL Server license for the machine
Report Server is installed on regardless of whether SQL Server Database is
installed on it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"frankm" <frankm@.nospam.postalias> wrote in message
news:uYcsWjRwEHA.1148@.TK2MSFTNGP12.phx.gbl...
> I know ReportServer is a SQL Server service. Do I need SQL Server on the
IIS
> / Report Server machine. What if I don't want to use a local SQL Server,
but
> I want to use a standalone SQL Server.
> frankm
>|||Thank you -
That's what I needed to know. I can install RptSvc without having SQL Server
on the same machine. Just as long as I have a SQL Server somewhere for the
store.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23oIxUrRwEHA.3908@.TK2MSFTNGP12.phx.gbl...
> ReportServer is an asp.net application. It requires SQL Server as an
object
> store. SQL Server can be either on the same machine, on a different
machine
> or on a different machine shared by multiple Report Servers (web farm).
Note
> that for licensing you need to have a SQL Server license for the machine
> Report Server is installed on regardless of whether SQL Server Database is
> installed on it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:uYcsWjRwEHA.1148@.TK2MSFTNGP12.phx.gbl...
> > I know ReportServer is a SQL Server service. Do I need SQL Server on the
> IIS
> > / Report Server machine. What if I don't want to use a local SQL Server,
> but
> > I want to use a standalone SQL Server.
> >
> > frankm
> >
> >
>|||Bruce,
On the IIS server where RS will be installed, does SQL Server have to be
installed, or is there a way to just input the license number. Like most, we
run our SQL Server on a separate box than our IIS server. I do not want to
install SQL Server on the IIS box unless absolutely necessary.
Thanks
Dane Dickey
"Bruce L-C [MVP]" wrote:
> ReportServer is an asp.net application. It requires SQL Server as an object
> store. SQL Server can be either on the same machine, on a different machine
> or on a different machine shared by multiple Report Servers (web farm). Note
> that for licensing you need to have a SQL Server license for the machine
> Report Server is installed on regardless of whether SQL Server Database is
> installed on it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:uYcsWjRwEHA.1148@.TK2MSFTNGP12.phx.gbl...
> > I know ReportServer is a SQL Server service. Do I need SQL Server on the
> IIS
> > / Report Server machine. What if I don't want to use a local SQL Server,
> but
> > I want to use a standalone SQL Server.
> >
> > frankm
> >
> >
>
>

No comments:

Post a Comment