Multiple servers running

We have our main core processing running Oracle but uses sqlpipe to reach the
data center. We are now installing new software that uses sql as it's
database server. The problem I have is each instance looks for the same
servername. can you add multiple servernames with the sql.ini file or how
would you go about this?
--
Scott"Spenbank" <Spenbank@.discussions.microsoft.com> wrote in message
news:D05AE45F-EBE7-43BA-96A3-EBEBCF73AC43@.microsoft.com...
> We have our main core processing running Oracle but uses sqlpipe to reach
the
> data center. We are now installing new software that uses sql as it's
> database server. The problem I have is each instance looks for the same
> servername. can you add multiple servernames with the sql.ini file or how
> would you go about this?
Look up INSTANCES in books online.
So you'd have something like:
SERVER\Instance1
SERVER\Instance2
etc.
Generally at least in non cluster situations I find having separate
instances not a big help for SQL Server.
> --
> Scott|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:qnFtd.39078$1u.35551@.twister.nyroc.rr.com...
> "Spenbank" <Spenbank@.discussions.microsoft.com> wrote in message
> news:D05AE45F-EBE7-43BA-96A3-EBEBCF73AC43@.microsoft.com...
>> We have our main core processing running Oracle but uses sqlpipe to reach
> the
>> data center. We are now installing new software that uses sql as it's
>> database server. The problem I have is each instance looks for the same
>> servername. can you add multiple servernames with the sql.ini file or how
>> would you go about this?
> Look up INSTANCES in books online.
> So you'd have something like:
> SERVER\Instance1
> SERVER\Instance2
> etc.
> Generally at least in non cluster situations I find having separate
> instances not a big help for SQL Server.
>
>> --
>> Scott
>
Ahh, but in our hosted environment, each company can have it's own
"instance" and have their own set of security credentials that give them
access to their instance, but no one elses. =)
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OA4qrOU3EHA.4072@.TK2MSFTNGP10.phx.gbl...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:qnFtd.39078$1u.35551@.twister.nyroc.rr.com...
> >
> > Generally at least in non cluster situations I find having separate
> > instances not a big help for SQL Server.
> >
> >
> >> --
> >> Scott
> >
> >
> Ahh, but in our hosted environment, each company can have it's own
> "instance" and have their own set of security credentials that give them
> access to their instance, but no one elses. =)
Hence my qualification. :-)
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>