Multiple RS Instances using same SQL Server repository?

Is it possible (or supported) to have multiple Report Server instances
pointing to or using the same SQL Server repository?
Thanks,
MattI wanted to clarify my objective here. We don't want a web farm scenario.
We want to work with Standard Edition and have 5 developers (who already run
VS.NET and IIS on their Win2K Pro machines) also run RS locally but run the
SQL Server repository on a DIFFERENT box that all of them point to. The
benefit is that RS will run locally and be consistent with our local IIS
model and also reduce complexity with having to copy reports and stuff
between developer's instances of the repository. Is this possible?
Thanks
"ISGADMIN" wrote:
> Is it possible (or supported) to have multiple Report Server instances
> pointing to or using the same SQL Server repository?
> Thanks,
> Matt|||Hi, ISGADMIN
From your descriptions, I understood that you would like to connect to a
remote repository database. Have I understood you? Correct me if I was
wrong.
Yes, it is possible to do so. You could use rsconfig.exe to sepcify this
like the command line below
rsconfig -c"c:\program files\microsoft sql server\mssql\reporting
services\reportserver\rsreportserver.config"
-s<RemoteRepositoryDatabaseServerName> -dReportServer -aSQL
-u<YourAccountWithLocalAdminPermissiononForYourRemoteRepositoryDatabaseServe
rName> -p<yourpassword>
Hope this helps and please show me the error message and you detailed
command line when it fails on your side. Please refer to the Reporting
Services Books Online or MSDN links below to find more information about
reconfig.exe
rsconfig Utility
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm
/cpu_rsconfig_v1_5f1e.asp
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I don't think that is what he is asking. My feeling is that each developer
wants to have IIS locally and have all of them use the same SQL Server
repository. If so, the answer is no. They could all use the same SQL Server
and have different names for the repository (pretty sure of this, correct me
if I am wrong) but they can not all use the same repository (that by
definition is a web farm, it is just a web farm of developers but it is a
web farm).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:ShMODr%23uEHA.3152@.cpmsftngxa10.phx.gbl...
> Hi, ISGADMIN
> From your descriptions, I understood that you would like to connect to a
> remote repository database. Have I understood you? Correct me if I was
> wrong.
> Yes, it is possible to do so. You could use rsconfig.exe to sepcify this
> like the command line below
> rsconfig -c"c:\program files\microsoft sql server\mssql\reporting
> services\reportserver\rsreportserver.config"
> -s<RemoteRepositoryDatabaseServerName> -dReportServer -aSQL
> -u<YourAccountWithLocalAdminPermissiononForYourRemoteRepositoryDatabaseSer
ve
> rName> -p<yourpassword>
> Hope this helps and please show me the error message and you detailed
> command line when it fails on your side. Please refer to the Reporting
> Services Books Online or MSDN links below to find more information about
> reconfig.exe
> rsconfig Utility
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm
> /cpu_rsconfig_v1_5f1e.asp
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Bruce, I was just about to reply back to Michael when I got your response.
You are dead on. Nuts - I was hoping this was possible and/or supported.
Is the objective I am trying to achieve (that of each developer having the
RS server components installed locally just like we have IIS installed
locally) a "standard" practice? We wanted to do this because it seems to
mimic our production environment more. What are your thoughts on this
configuration (although based on your response, we'd have to have a separate
repository instance for each user)?
thanks guys
"Bruce L-C [MVP]" wrote:
> I don't think that is what he is asking. My feeling is that each developer
> wants to have IIS locally and have all of them use the same SQL Server
> repository. If so, the answer is no. They could all use the same SQL Server
> and have different names for the repository (pretty sure of this, correct me
> if I am wrong) but they can not all use the same repository (that by
> definition is a web farm, it is just a web farm of developers but it is a
> web farm).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> ""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:ShMODr%23uEHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi, ISGADMIN
> >
> > From your descriptions, I understood that you would like to connect to a
> > remote repository database. Have I understood you? Correct me if I was
> > wrong.
> >
> > Yes, it is possible to do so. You could use rsconfig.exe to sepcify this
> > like the command line below
> >
> > rsconfig -c"c:\program files\microsoft sql server\mssql\reporting
> > services\reportserver\rsreportserver.config"
> > -s<RemoteRepositoryDatabaseServerName> -dReportServer -aSQL
> > -u<YourAccountWithLocalAdminPermissiononForYourRemoteRepositoryDatabaseSer
> ve
> > rName> -p<yourpassword>
> >
> > Hope this helps and please show me the error message and you detailed
> > command line when it fails on your side. Please refer to the Reporting
> > Services Books Online or MSDN links below to find more information about
> > reconfig.exe
> >
> > rsconfig Utility
> >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm
> > /cpu_rsconfig_v1_5f1e.asp
> >
> > Thank you for your patience and corperation. If you have any questions or
> > concerns, don't hesitate to let me know. We are here to be of assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>|||You need to either do this or at least have a development server. Each
developer could have their own folder on the development server. The reason
you do need this is that there are a few cases where the preview in the IDE
has difficulties so I will check it out by deploying it. Also, if you ever
need to use the jump to URL this needs to be tested with a deployed report.
SQL Server is pretty good about having a low footprint so I have not had any
difficulties in having it installed just for the repository.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:67318603-7A0E-4416-93D6-B8823E71AD2B@.microsoft.com...
> Hi Bruce, I was just about to reply back to Michael when I got your
response.
> You are dead on. Nuts - I was hoping this was possible and/or supported.
> Is the objective I am trying to achieve (that of each developer having the
> RS server components installed locally just like we have IIS installed
> locally) a "standard" practice? We wanted to do this because it seems to
> mimic our production environment more. What are your thoughts on this
> configuration (although based on your response, we'd have to have a
separate
> repository instance for each user)?
> thanks guys
> "Bruce L-C [MVP]" wrote:
> > I don't think that is what he is asking. My feeling is that each
developer
> > wants to have IIS locally and have all of them use the same SQL Server
> > repository. If so, the answer is no. They could all use the same SQL
Server
> > and have different names for the repository (pretty sure of this,
correct me
> > if I am wrong) but they can not all use the same repository (that by
> > definition is a web farm, it is just a web farm of developers but it is
a
> > web farm).
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > ""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
message
> > news:ShMODr%23uEHA.3152@.cpmsftngxa10.phx.gbl...
> > > Hi, ISGADMIN
> > >
> > > From your descriptions, I understood that you would like to connect to
a
> > > remote repository database. Have I understood you? Correct me if I was
> > > wrong.
> > >
> > > Yes, it is possible to do so. You could use rsconfig.exe to sepcify
this
> > > like the command line below
> > >
> > > rsconfig -c"c:\program files\microsoft sql server\mssql\reporting
> > > services\reportserver\rsreportserver.config"
> > > -s<RemoteRepositoryDatabaseServerName> -dReportServer -aSQL
> >
> -u<YourAccountWithLocalAdminPermissiononForYourRemoteRepositoryDatabaseSer
> > ve
> > > rName> -p<yourpassword>
> > >
> > > Hope this helps and please show me the error message and you detailed
> > > command line when it fails on your side. Please refer to the Reporting
> > > Services Books Online or MSDN links below to find more information
about
> > > reconfig.exe
> > >
> > > rsconfig Utility
> > >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm
> > > /cpu_rsconfig_v1_5f1e.asp
> > >
> > > Thank you for your patience and corperation. If you have any questions
or
> > > concerns, don't hesitate to let me know. We are here to be of
assistance!
> > >
> > >
> > > Sincerely yours,
> > >
> > > Michael Cheng
> > >
> > > Online Partner Support Specialist
> > > Partner Support Group
> > > Microsoft Global Technical Support Center
> > > ---
> > > Get Secure! - http://www.microsoft.com/security
> > >
> > > This posting is provided "as is" with no warranties and confers no
rights.
> > > Please reply to newsgroups only, many thanks!
> > >
> >
> >
> >|||Hi Bruce and isgadmin,
Oops, I am sorry for my poor understanding.
Yes, as MVP Bruce said, it was not possible to share one repository with
multiusers on different machines. I think the workaround Bruce gives is
very helpful and I will also give this feedback to our development team
internally.
Thanks again for Bruce's kindness!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!