Can i have multiple Report Server 05 instances on one machine conneting to
one remote Sql Database instance. Each Report Server will have its own
database in the SQL instanceOn Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> Can i have multiple Report Server 05 instances on one machine conneting to
> one remote Sql Database instance. Each Report Server will have its own
> database in the SQL instance
This link should be helpful.
http://technet.microsoft.com/en-us/library/ms403426.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||i read through the documentatation, but its not clear to me if 2 RS 05
standard ed on one machine can share the same database server but separate
databases. Unless i'm misunderstading it... any ideas?
"EMartinez" wrote:
> On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> > Can i have multiple Report Server 05 instances on one machine conneting to
> > one remote Sql Database instance. Each Report Server will have its own
> > database in the SQL instance
>
> This link should be helpful.
> http://technet.microsoft.com/en-us/library/ms403426.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Aug 16, 7:45 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> i read through the documentatation, but its not clear to me if 2 RS 05
> standard ed on one machine can share the same database server but separate
> databases. Unless i'm misunderstading it... any ideas?
> "EMartinez" wrote:
> > On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> > > Can i have multiple Report Server 05 instances on one machine conneting to
> > > one remote Sql Database instance. Each Report Server will have its own
> > > database in the SQL instance
> > This link should be helpful.
> >http://technet.microsoft.com/en-us/library/ms403426.aspx
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
As far as I know, this should be fine as long as your virtual
directories for Reports and ReportServer are physically separate for
both SQL instances. Also, you will want to make sure that you have at
least one default SQL Server Instance and one named SQL Server
Instance local to SSRS. As long as your SQL Servers are not mixed
(i.e., one SQL Server 2000 and one SQL Server 2005), it should be ok.
Regards,
Enrique Martinez
Sr. Software Consultant|||So am I understanding you correctly that each RS (standard ed) instance will
need to have their own SQL Server Database Instance?
Here is what my environment looks like:
WebServer has RSSite1(default) AND RSSite2(Named)
DatabaseServer has one Instance Of Sql Server called DBServ
DBServ has four databases:
RSSite1_ReportServer
RSSite1_ReportServerTempDb
RSSite2_ReportServer
RSSite2_ReportServerTempDb
I'm doing this right now, but i'm running into some issues. Just want to
know if this is supported so i can stop troubleshooting this.
Thanks
"EMartinez" wrote:
> On Aug 16, 7:45 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> > i read through the documentatation, but its not clear to me if 2 RS 05
> > standard ed on one machine can share the same database server but separate
> > databases. Unless i'm misunderstading it... any ideas?
> >
> > "EMartinez" wrote:
> > > On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> > > > Can i have multiple Report Server 05 instances on one machine conneting to
> > > > one remote Sql Database instance. Each Report Server will have its own
> > > > database in the SQL instance
> >
> > > This link should be helpful.
> > >http://technet.microsoft.com/en-us/library/ms403426.aspx
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant
>
> As far as I know, this should be fine as long as your virtual
> directories for Reports and ReportServer are physically separate for
> both SQL instances. Also, you will want to make sure that you have at
> least one default SQL Server Instance and one named SQL Server
> Instance local to SSRS. As long as your SQL Servers are not mixed
> (i.e., one SQL Server 2000 and one SQL Server 2005), it should be ok.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||They need their own databases, not their own instance. RS 2005 should have
no problem with this at all.
From the article that Enrique provided a link to:"You can install multiple
instances of Reporting Services on the same computer. Installing multiple
instances is useful if you want to host different content for specific
sites. Each instance will have its own report server database, configuration
files, and virtual directories. "
Note it says report server database NOT instance.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:06567929-6302-4508-8B96-80D7A02B439E@.microsoft.com...
> So am I understanding you correctly that each RS (standard ed) instance
> will
> need to have their own SQL Server Database Instance?
> Here is what my environment looks like:
> WebServer has RSSite1(default) AND RSSite2(Named)
> DatabaseServer has one Instance Of Sql Server called DBServ
> DBServ has four databases:
> RSSite1_ReportServer
> RSSite1_ReportServerTempDb
> RSSite2_ReportServer
> RSSite2_ReportServerTempDb
> I'm doing this right now, but i'm running into some issues. Just want to
> know if this is supported so i can stop troubleshooting this.
> Thanks
> "EMartinez" wrote:
>> On Aug 16, 7:45 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
>> > i read through the documentatation, but its not clear to me if 2 RS 05
>> > standard ed on one machine can share the same database server but
>> > separate
>> > databases. Unless i'm misunderstading it... any ideas?
>> >
>> > "EMartinez" wrote:
>> > > On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
>> > > > Can i have multiple Report Server 05 instances on one machine
>> > > > conneting to
>> > > > one remote Sql Database instance. Each Report Server will have its
>> > > > own
>> > > > database in the SQL instance
>> >
>> > > This link should be helpful.
>> > >http://technet.microsoft.com/en-us/library/ms403426.aspx
>> >
>> > > Regards,
>> >
>> > > Enrique Martinez
>> > > Sr. Software Consultant
>>
>> As far as I know, this should be fine as long as your virtual
>> directories for Reports and ReportServer are physically separate for
>> both SQL instances. Also, you will want to make sure that you have at
>> least one default SQL Server Instance and one named SQL Server
>> Instance local to SSRS. As long as your SQL Servers are not mixed
>> (i.e., one SQL Server 2000 and one SQL Server 2005), it should be ok.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>|||Thank You for the clarification...I've been trying that configuration with no
luck. I'll look more into it then. Thanks.
"Marvin" wrote:
> Can i have multiple Report Server 05 instances on one machine conneting to
> one remote Sql Database instance. Each Report Server will have its own
> database in the SQL instance|||Thank you for clarifying...so here's my issue.
I installed a default instance of Report Services Std on a Non-Default
Website with Sql Server on a remote machine. I implemented custom security.
No problems so far. I am able to log-in using Forms Auth and add a Folder.
Then I would install a named instance on the same webserver. Without even
touching it after install (choosing to configure later), the DEFAULT instance
returns a "Bad Request" error when trying to log in. I planned to set up the
named instance on another Website.
Any Ideas?
"Bruce L-C [MVP]" wrote:
> They need their own databases, not their own instance. RS 2005 should have
> no problem with this at all.
> From the article that Enrique provided a link to:"You can install multiple
> instances of Reporting Services on the same computer. Installing multiple
> instances is useful if you want to host different content for specific
> sites. Each instance will have its own report server database, configuration
> files, and virtual directories. "
> Note it says report server database NOT instance.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
> news:06567929-6302-4508-8B96-80D7A02B439E@.microsoft.com...
> > So am I understanding you correctly that each RS (standard ed) instance
> > will
> > need to have their own SQL Server Database Instance?
> >
> > Here is what my environment looks like:
> > WebServer has RSSite1(default) AND RSSite2(Named)
> > DatabaseServer has one Instance Of Sql Server called DBServ
> > DBServ has four databases:
> > RSSite1_ReportServer
> > RSSite1_ReportServerTempDb
> > RSSite2_ReportServer
> > RSSite2_ReportServerTempDb
> >
> > I'm doing this right now, but i'm running into some issues. Just want to
> > know if this is supported so i can stop troubleshooting this.
> >
> > Thanks
> >
> > "EMartinez" wrote:
> >
> >> On Aug 16, 7:45 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> >> > i read through the documentatation, but its not clear to me if 2 RS 05
> >> > standard ed on one machine can share the same database server but
> >> > separate
> >> > databases. Unless i'm misunderstading it... any ideas?
> >> >
> >> > "EMartinez" wrote:
> >> > > On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> >> > > > Can i have multiple Report Server 05 instances on one machine
> >> > > > conneting to
> >> > > > one remote Sql Database instance. Each Report Server will have its
> >> > > > own
> >> > > > database in the SQL instance
> >> >
> >> > > This link should be helpful.
> >> > >http://technet.microsoft.com/en-us/library/ms403426.aspx
> >> >
> >> > > Regards,
> >> >
> >> > > Enrique Martinez
> >> > > Sr. Software Consultant
> >>
> >>
> >> As far as I know, this should be fine as long as your virtual
> >> directories for Reports and ReportServer are physically separate for
> >> both SQL instances. Also, you will want to make sure that you have at
> >> least one default SQL Server Instance and one named SQL Server
> >> Instance local to SSRS. As long as your SQL Servers are not mixed
> >> (i.e., one SQL Server 2000 and one SQL Server 2005), it should be ok.
> >>
> >> Regards,
> >>
> >> Enrique Martinez
> >> Sr. Software Consultant
> >>
> >>
>
>|||Did you use different databases for the second install of RS?
Have you checked to see what the default website is? Could it have changed
to the second installation of RS?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:7CA5523E-B6D7-4524-A3C2-DA30939B3F2B@.microsoft.com...
> Thank you for clarifying...so here's my issue.
> I installed a default instance of Report Services Std on a Non-Default
> Website with Sql Server on a remote machine. I implemented custom
> security.
> No problems so far. I am able to log-in using Forms Auth and add a Folder.
> Then I would install a named instance on the same webserver. Without even
> touching it after install (choosing to configure later), the DEFAULT
> instance
> returns a "Bad Request" error when trying to log in. I planned to set up
> the
> named instance on another Website.
> Any Ideas?
> "Bruce L-C [MVP]" wrote:
>> They need their own databases, not their own instance. RS 2005 should
>> have
>> no problem with this at all.
>> From the article that Enrique provided a link to:"You can install
>> multiple
>> instances of Reporting Services on the same computer. Installing multiple
>> instances is useful if you want to host different content for specific
>> sites. Each instance will have its own report server database,
>> configuration
>> files, and virtual directories. "
>> Note it says report server database NOT instance.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
>> news:06567929-6302-4508-8B96-80D7A02B439E@.microsoft.com...
>> > So am I understanding you correctly that each RS (standard ed) instance
>> > will
>> > need to have their own SQL Server Database Instance?
>> >
>> > Here is what my environment looks like:
>> > WebServer has RSSite1(default) AND RSSite2(Named)
>> > DatabaseServer has one Instance Of Sql Server called DBServ
>> > DBServ has four databases:
>> > RSSite1_ReportServer
>> > RSSite1_ReportServerTempDb
>> > RSSite2_ReportServer
>> > RSSite2_ReportServerTempDb
>> >
>> > I'm doing this right now, but i'm running into some issues. Just want
>> > to
>> > know if this is supported so i can stop troubleshooting this.
>> >
>> > Thanks
>> >
>> > "EMartinez" wrote:
>> >
>> >> On Aug 16, 7:45 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
>> >> > i read through the documentatation, but its not clear to me if 2 RS
>> >> > 05
>> >> > standard ed on one machine can share the same database server but
>> >> > separate
>> >> > databases. Unless i'm misunderstading it... any ideas?
>> >> >
>> >> > "EMartinez" wrote:
>> >> > > On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com>
>> >> > > wrote:
>> >> > > > Can i have multiple Report Server 05 instances on one machine
>> >> > > > conneting to
>> >> > > > one remote Sql Database instance. Each Report Server will have
>> >> > > > its
>> >> > > > own
>> >> > > > database in the SQL instance
>> >> >
>> >> > > This link should be helpful.
>> >> > >http://technet.microsoft.com/en-us/library/ms403426.aspx
>> >> >
>> >> > > Regards,
>> >> >
>> >> > > Enrique Martinez
>> >> > > Sr. Software Consultant
>> >>
>> >>
>> >> As far as I know, this should be fine as long as your virtual
>> >> directories for Reports and ReportServer are physically separate for
>> >> both SQL instances. Also, you will want to make sure that you have at
>> >> least one default SQL Server Instance and one named SQL Server
>> >> Instance local to SSRS. As long as your SQL Servers are not mixed
>> >> (i.e., one SQL Server 2000 and one SQL Server 2005), it should be ok.
>> >>
>> >> Regards,
>> >>
>> >> Enrique Martinez
>> >> Sr. Software Consultant
>> >>
>> >>
>>|||i was able to figure out my problem...i used the custom security extention
sample and during login it was returning the wrong url from one of the
methods (using WMI for some reason to get the url). i just overrid that and
got the correct value from web.config. all is well. thank you for taking the
time to help me.
"Bruce L-C [MVP]" wrote:
> Did you use different databases for the second install of RS?
> Have you checked to see what the default website is? Could it have changed
> to the second installation of RS?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
> news:7CA5523E-B6D7-4524-A3C2-DA30939B3F2B@.microsoft.com...
> > Thank you for clarifying...so here's my issue.
> > I installed a default instance of Report Services Std on a Non-Default
> > Website with Sql Server on a remote machine. I implemented custom
> > security.
> > No problems so far. I am able to log-in using Forms Auth and add a Folder.
> >
> > Then I would install a named instance on the same webserver. Without even
> > touching it after install (choosing to configure later), the DEFAULT
> > instance
> > returns a "Bad Request" error when trying to log in. I planned to set up
> > the
> > named instance on another Website.
> >
> > Any Ideas?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> They need their own databases, not their own instance. RS 2005 should
> >> have
> >> no problem with this at all.
> >> From the article that Enrique provided a link to:"You can install
> >> multiple
> >> instances of Reporting Services on the same computer. Installing multiple
> >> instances is useful if you want to host different content for specific
> >> sites. Each instance will have its own report server database,
> >> configuration
> >> files, and virtual directories. "
> >>
> >> Note it says report server database NOT instance.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
> >> news:06567929-6302-4508-8B96-80D7A02B439E@.microsoft.com...
> >> > So am I understanding you correctly that each RS (standard ed) instance
> >> > will
> >> > need to have their own SQL Server Database Instance?
> >> >
> >> > Here is what my environment looks like:
> >> > WebServer has RSSite1(default) AND RSSite2(Named)
> >> > DatabaseServer has one Instance Of Sql Server called DBServ
> >> > DBServ has four databases:
> >> > RSSite1_ReportServer
> >> > RSSite1_ReportServerTempDb
> >> > RSSite2_ReportServer
> >> > RSSite2_ReportServerTempDb
> >> >
> >> > I'm doing this right now, but i'm running into some issues. Just want
> >> > to
> >> > know if this is supported so i can stop troubleshooting this.
> >> >
> >> > Thanks
> >> >
> >> > "EMartinez" wrote:
> >> >
> >> >> On Aug 16, 7:45 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> >> >> > i read through the documentatation, but its not clear to me if 2 RS
> >> >> > 05
> >> >> > standard ed on one machine can share the same database server but
> >> >> > separate
> >> >> > databases. Unless i'm misunderstading it... any ideas?
> >> >> >
> >> >> > "EMartinez" wrote:
> >> >> > > On Aug 14, 12:58 pm, Marvin <Mar...@.discussions.microsoft.com>
> >> >> > > wrote:
> >> >> > > > Can i have multiple Report Server 05 instances on one machine
> >> >> > > > conneting to
> >> >> > > > one remote Sql Database instance. Each Report Server will have
> >> >> > > > its
> >> >> > > > own
> >> >> > > > database in the SQL instance
> >> >> >
> >> >> > > This link should be helpful.
> >> >> > >http://technet.microsoft.com/en-us/library/ms403426.aspx
> >> >> >
> >> >> > > Regards,
> >> >> >
> >> >> > > Enrique Martinez
> >> >> > > Sr. Software Consultant
> >> >>
> >> >>
> >> >> As far as I know, this should be fine as long as your virtual
> >> >> directories for Reports and ReportServer are physically separate for
> >> >> both SQL instances. Also, you will want to make sure that you have at
> >> >> least one default SQL Server Instance and one named SQL Server
> >> >> Instance local to SSRS. As long as your SQL Servers are not mixed
> >> >> (i.e., one SQL Server 2000 and one SQL Server 2005), it should be ok.
> >> >>
> >> >> Regards,
> >> >>
> >> >> Enrique Martinez
> >> >> Sr. Software Consultant
> >> >>
> >> >>
> >>
> >>
> >>
>
>
