Another SQL Server Question


Recommended Posts

I want to install SQL Server 2000 on W2K3, but I get an error that SQL needs to be >=SP3. My SQL version is SP2, and I do have the patch to update to SP3.

:huh: Is there a way to "Slipstream" SQL Server install files with the new SP?

:huh: Or maybe a way to tell W2K3 that it IS SP3?

Any help is appreciated.

Link to comment
Share on other sites

ok.. first things first. Copy all the files from sql2k to the hard drive as well as sp3 (you'll see why in a sec)

Then download the application compatibility toolkit from the MS website.

Then disconnect the nic cable from the back of the machine (so you do not get slammerfied or slammer anyone else)

The run compatadmin from the toolkit

Find the sql2k entry under the application list and disable it.

Then install sql as normal then reboot

Then install sp3 and reboot.

re-enable the sql2k entry in compat admin

Plug in the network cable.

Voila.

Link to comment
Share on other sites

I want to install SQL Server 2000 on W2K3, but I get an error that SQL needs to be >=SP3. My SQL version is SP2, and I do have the patch to update to SP3.

:huh: Is there a way to "Slipstream" SQL Server install files with the new SP?

:huh: Or maybe a way to tell W2K3 that it IS SP3?

Any help is appreciated.

Glad to see Microsoft did this for reasons of SQL Slammer.

Link to comment
Share on other sites

Yup strictly slammer reasons. Also, in answer to the last question, it is a serious pain in the butt to slipstream sql because of the way files are verified. If you use my above methods (copying the files is really only necessary if they are located on the network as mine are) If they are cd based then you can skip that step.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.