Windows Forum

Ask something
Discussion Locked

SMS 2.0 and SQL 2000

0 helpful
4 replies

by tcstech

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to install in a test invironment SMS and SQL 2000. I am running Win2000 AS w/ sp2, dual Xeon 2.2 w/ 1gb mem. During the SMS setup, I need to have SQL installed (it is) and it checks for whick version (options are 6.5 and 7.0). I check 7.0, but I am actually using 8.0.
I need a work around to get the SMS server installed. Do I need to specify no SQL server? Manually install the Db later?

Any help would be great, as I know nothing on either subject

TIA
Reed

4 replies

by cg it

I have SMS installed on my W2K SBS network. For SMS to install correctly, your network has to be up and running [at least one client connected] and SQL server has to be installed and functional. So for a test environment, you'll need at least two computers. One Server, one client. During the setup Wizard for SMS your prompted to specify what version and where SQL is located and to create a SMS Site Database on SQL for SMS usage.[created during SMS setup] {there isn't a default SMS data base} [took me a couple of times installing it to get it right]. [Once installed though boy, wonderful network tool.]

by cg it

Make sure SQL service is running when you try to install SMS as SMS will autodetect for SQL.

by tcstech

Network is up and running. Ths main issue is that SMS asks for what version of SQL. I am using SQL 2000 and my options are to choose either SQL 6.5 or 7.0. SQL 2000 is considered ver 8.0 and I receive errors during the finish of setup. I am thinking that I may need to install SQL 7.0, then SMS, then upgrade to SQL 2000.....

Reed

This discussion is closed to new replies.