you may be able to run the setup again but this time leave the default
instance name check on instead of specifying a name. If that does not work
then you will want to uninstall and reinstall. Note: if you are going to
use 7.0 on this along with 2k the default instance will be 7.0 i believe. If
you have 7.0 on the box and run the setup with the default check in place it
should upgrade the server to 2k. Hope this helps.
greg
-----Original Message-----
From: Paul Armstrong [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 2:02 PM
To: NT System Admin Issues
Subject: RE: SMS 2.0 & SQL 2K
Okay, so i haven't worked with SQL2K before, I haven't gotten past 7.0
yet. Anyway, i want try it out with SQL2K so that i can learn both
platforms at the same time. I just installed SQL2K on Win2K server and
when it asked for an instance name I entered SMS. When i go into the
Enterprise manager it shows the server as being servername\SMS, is this
considered the default instance or would the default instance just be
servername? If so, I will have to uninstall SQL and re-install and leave
the instance naming blank and see if that works.
-----Original Message-----
From: Greg Tupper [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 2:10 PM
To: NT System Admin Issues
Subject: RE: SMS 2.0 & SQL 2K
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
