It's good for use in development areas where buying multiple servers
makes no sense with a limited user count, and also because you can
create SQL servers using different sort orders or character sets all on
the same machine
Ian
mailto:[EMAIL PROTECTED]
------------------------------------------------
"If you are not free to choose wrongly and irresponsibly, you are not
free at all." -- Jacob Hornberger
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 14:14
To: NT System Admin Issues
Subject: RE: SMS 2.0 & SQL 2K
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
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
