CIM7 SP1.2 Upgrade to SP2

[Martin Hamilton_2]

This is a strange one but I am sure that someone else must have had these issues??

I had an initial installation of SP1 from the OEM disk supplied with a server.. I then applied SP1.1 and SP1.2 with no issues.... I now want to apply SP2 and have the following issues


1 - during installation it says that I require SP2 or greater for MSDE/SQL... I download the SQL SP3 update from Mircosoft and from a DOS prompt run

setup.exe /upgradesp SQLRUN BLANKSAPWD=1

..as per the instructions but I just get error messages back saying that it can't find instances of SQL server or MSDE on this system (not good!!)

2 - when I run osql from a prompt I get asked for a password, don't ever remember setting one up and when it fails I get 'login failed for user 'nt logon''..... doesn't even work when I enter my correct BT password...

Obviously without upgrading MSDE I can't upgrade to SP2... I am sure that I am running MSDE v7 (the version that came with SP1) but can't check...

Anyone got any ideas???.. it's probably a simple one.. but then so am I sometimes!!!

[Harro Fleurke]

So I also have problems with installing SP2.

I use a MSDE database instead of a real SQL database.

So I first downloaded:

Sql2kdesksp3.exe

From: http://www.microsoft.com/sql/downloads/2000/sp3.asp

I also go the message, after running setup: can't find instances of SQL server.

So I edited the setup.ini:
SAPPWD=xxxxx (Password of sa account)
INSTANCENAME=SQL_DATABASE_NAME

So it did an upgrade, but when I tried to install SP2 I still get an error saying I need to upgrade the database. Maybe this will help some, and I am eager to hear if anyone knows what I am forgetting

HArro

[George_71]

I downloded SQL2KDeskSP2.exe from Microsoft and it all went OK no problems.

[Harro Fleurke]

So I tried some more. The update dit not work. Instead of update de database, it adds another database. The option: Instancename=SQL_DATABSE_NAME , better kan be ignored.

I did found this on the microsoft webpage. I installed MSDE from de Compaq cd-roms, with the file: MSDEX86.exe So I am going to ask compaq for the right update file!

MSDE users must know how their instance of MSDE was installed to know how to patch it. In particular, you must know the original package name for your instance of MSDE. To determine the original package name, see article 13296, How to Identify Which MSI File Was Used for an Existing MSDE Installation in the Microsoft Knowledge Base.
If the original package name for your instance was SqlRun01.msi, download the file SQL2KDeskSP2.exe to apply SP2.
If the original package name for your instance was SqlRun02.msi through SqlRun16.msi, download the file ql2kdeskfullsp2.exe to apply SP2.
If the original package name for your instance was Sample.msi or SampleUpg.msi, see article 13297, How To Create Patch Files for the MSDE 2000 Sample.msi File.
If your original package name indicates the package was installed by the .NET SDK or Microsoft Application Center, see the Microsoft Products That Include MSDE 2000 on the Microsoft TechNet site for instructions on how to upgrade that instance of MSDE.
If the product code associated with your instance of MSDE is not listed in the article, then the instance was installed by the setup utility of an application. You cannot use either of the downloadable files listed on this page (SQL2KDeskSP2.exe or sql2kdeskfullsp2.exe) to apply SP2 to such MSDE instances. Instead, you must get a patch file from the company who wrote the application. If the application came from a company other than Microsoft, you must contact that company for a patch file. If the application came from Microsoft, see Microsoft Products That Include MSDE 2000 -- this page will be updated with information about how to upgrade those instances of MSDE.

[Harro Fleurke]

Here the solution on how to use osql:
Goto a command prompt on the server:
Type:
C:>osql -Slocalhost -Usa
Password: (password sa account)
1> select @@version
2>go

This is to check the version. You can also do other actions I don't know!