Would there be any advantage to running multiple instances? Or is there
some 3rd party software that requires it? I cant think of a good reason
right off. Why not just put up another server if you need more than one
sql?
Greg Tupper
<gtupper@Acit To: "NT System Admin Issues"
el.com> <[EMAIL PROTECTED]>
cc:
08/31/2001 Subject: RE: SMS 2.0 & SQL 2K
11:09 AM
Please
respond to
"NT System
Admin Issues"
Paul,
With sql2k you can run multiple instances on the same box. This means that
you can have more then one sql server running on the same box. All you
really need is to name each installation a different name. With SMS you
are
required to use the default installation or the first installation as the
server that holds the sms databases. Usually the default installation is
the
server name and that is probably why it requires this. Hope this helps.
greg
-----Original Message-----
From: Paul Armstrong [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 12:44 PM
To: NT System Admin Issues
Subject: FW: SMS 2.0 & SQL 2K
Okay, i found something saying that SQL 2K works with SMS 2.0. Now I
have another question about the below statement:
SQL Server 2000 is fully supported in Systems Management Server 2.0
Service Pack 2 (SP2) with the following limitations:
* Only the default SQL Server instance is supported for use as
Systems Management Server site databases. Additional instances can be
used for other applications that support instancing.
What the hell do they mean by instances, could someone elaborate? TIA!!!
> -----Original Message-----
> From: Paul Armstrong
> Sent: Friday, August 31, 2001 1:27 PM
> To: NT System Admin Issues (E-mail)
> Subject: SMS 2.0 & SQL 2K
>
> Hello All,
>
> I am doing some research on working with SMS 2.0. I know I can work
> with it on Windows 2000 using the latest SMS service packs but what
> about using SQL 2000 instead of SQL 7? I am searching M$'s site right
> now and have yet to find an answer? Can someone confirm if this would
> work and where I can find more info on this setup? TIA!!
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
