Multiple instances

The Result:
Two people using the same computer running RS that connect to different
instances on the on the SQL computer, so that one person has no indication
that the other is present.
The Question:
How can I achieve the above result
The Plead:
All information regarding this problem is greatly appreciated.
The Closing:
Thank youIf they run only a report noone will ever see the other instance, or do you
want to decide at report level to which instacne the suer will connect to
during runtime ? Then you should use a stored procedure which evaluates the
destination while the user is quering the data and firing the appropiate
Query for this user.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
news:BDCD5D89-595A-4D7B-917C-B6CF486A4E76@.microsoft.com...
> The Result:
> Two people using the same computer running RS that connect to different
> instances on the on the SQL computer, so that one person has no indication
> that the other is present.
> The Question:
> How can I achieve the above result
> The Plead:
> All information regarding this problem is greatly appreciated.
> The Closing:
> Thank you|||Yes -- I want to decide at report level to which instance the user will
connect to during runtime. My wish: To install RS 2 times on one server
using 2 SQL instances -- one RS1 "instance" uses SQL1 and RS2 uses SQL2, but
both SQL1 & SQL2 are on the same SQLBOX. Is THIS possible?
"Jens Sü�meyer" wrote:
> If they run only a report noone will ever see the other instance, or do you
> want to decide at report level to which instacne the suer will connect to
> during runtime ? Then you should use a stored procedure which evaluates the
> destination while the user is quering the data and firing the appropiate
> Query for this user.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:BDCD5D89-595A-4D7B-917C-B6CF486A4E76@.microsoft.com...
> > The Result:
> > Two people using the same computer running RS that connect to different
> > instances on the on the SQL computer, so that one person has no indication
> > that the other is present.
> >
> > The Question:
> > How can I achieve the above result
> >
> > The Plead:
> > All information regarding this problem is greatly appreciated.
> >
> > The Closing:
> > Thank you
>
>|||I don't know about 2 instances of RS on the same box. You would have to
install to different URL's for each instance. And if you're going to have
different URL's, then you might as well use two different servers, or use
Virtual PC or VMware to get two virtual servers on the same physical box.
It sounds like all you really need is a report that sends UserId as a query
parameter, and a stored procedure that is smart enough to use the UserId to
query different data for different people. The "different data" in the query
could be separate SQL Server instances if you want.
HTH,
Ted
"savvy95" wrote:
> Yes -- I want to decide at report level to which instance the user will
> connect to during runtime. My wish: To install RS 2 times on one server
> using 2 SQL instances -- one RS1 "instance" uses SQL1 and RS2 uses SQL2, but
> both SQL1 & SQL2 are on the same SQLBOX. Is THIS possible?
> "Jens Sü�meyer" wrote:
> > If they run only a report noone will ever see the other instance, or do you
> > want to decide at report level to which instacne the suer will connect to
> > during runtime ? Then you should use a stored procedure which evaluates the
> > destination while the user is quering the data and firing the appropiate
> > Query for this user.
> >
> > HTH, Jens Suessmeyer.
> >
> > --
> > http://www.sqlserver2005.de
> > --
> >
> >
> > "savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:BDCD5D89-595A-4D7B-917C-B6CF486A4E76@.microsoft.com...
> > > The Result:
> > > Two people using the same computer running RS that connect to different
> > > instances on the on the SQL computer, so that one person has no indication
> > > that the other is present.
> > >
> > > The Question:
> > > How can I achieve the above result
> > >
> > > The Plead:
> > > All information regarding this problem is greatly appreciated.
> > >
> > > The Closing:
> > > Thank you
> >
> >
> >|||Thanks Ted K. and Jens Sü�meyer
I'm the IT guy, even though I know quite a bit about RS, the DBA will given
admin privileges (creating reports, users and setting permissions).
Presently there's another person in Business Intellegence who has the other
admin roll. That makes 2 Admin. My boss asked me to investigate the
possibility of not having to create another box with RS. Rather to find a
way to run 2 instances on the same box.
I will not be involved in installing RS and ensuring its operations. I told
my boss I didn't think there was a way to do what he wants, BUT I needed to
research it more. Your assistance has been greatly appreciated and has
confirmed my exploration into this matter as "not possible".
Mind you if I were the Admin, I would indeed take your advices and create
stored procedures.
Thanks again
"Ted K" wrote:
> I don't know about 2 instances of RS on the same box. You would have to
> install to different URL's for each instance. And if you're going to have
> different URL's, then you might as well use two different servers, or use
> Virtual PC or VMware to get two virtual servers on the same physical box.
> It sounds like all you really need is a report that sends UserId as a query
> parameter, and a stored procedure that is smart enough to use the UserId to
> query different data for different people. The "different data" in the query
> could be separate SQL Server instances if you want.
> HTH,
> Ted
> "savvy95" wrote:
> > Yes -- I want to decide at report level to which instance the user will
> > connect to during runtime. My wish: To install RS 2 times on one server
> > using 2 SQL instances -- one RS1 "instance" uses SQL1 and RS2 uses SQL2, but
> > both SQL1 & SQL2 are on the same SQLBOX. Is THIS possible?
> >
> > "Jens Sü�meyer" wrote:
> >
> > > If they run only a report noone will ever see the other instance, or do you
> > > want to decide at report level to which instacne the suer will connect to
> > > during runtime ? Then you should use a stored procedure which evaluates the
> > > destination while the user is quering the data and firing the appropiate
> > > Query for this user.
> > >
> > > HTH, Jens Suessmeyer.
> > >
> > > --
> > > http://www.sqlserver2005.de
> > > --
> > >
> > >
> > > "savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
> > > news:BDCD5D89-595A-4D7B-917C-B6CF486A4E76@.microsoft.com...
> > > > The Result:
> > > > Two people using the same computer running RS that connect to different
> > > > instances on the on the SQL computer, so that one person has no indication
> > > > that the other is present.
> > > >
> > > > The Question:
> > > > How can I achieve the above result
> > > >
> > > > The Plead:
> > > > All information regarding this problem is greatly appreciated.
> > > >
> > > > The Closing:
> > > > Thank you
> > >
> > >
> > >sql