November 7, 2005 at 10:22 am
I have started a new job and am trying to get the service packs up to date. I have installed SP 4 on the default instance without any errors, it had no SP at all previously. When I try to install on a database instance I get the following error:-
STARTEAM is not a SQL Server 2000 instance.
Setup will now exit.
I ran @@version to see what version was already there.
Microsoft SQL Server 2000 - 8.00.679 (Intel X86)
Aug 26 2002 15:09:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 3)
This is the SQLsp.log
16:30:30 Begin Setup
16:30:30 Version on Media: 8.00.2039
16:30:30 Mode = Normal
16:30:30 ModeType = NORMAL
16:30:30 Loading library - sqlsut.dll (#L1)
16:30:30 Begin: SetupInitialize()
16:30:30 End: SetupInitialize()
16:30:30 Begin: CheckFixedRequirements()
16:30:30 Platform ID: 0xf00
16:30:30 Version: 5.0.2195
16:30:30 File Version - C:\WINNT\System32\shdocvw.dll: 5.0.3502.5400
16:30:30 End: CheckFixedRequirements()
16:30:30 Begin Action: CheckRequirements
16:30:30 Processor Architecture: x86 (Pentium)
16:30:30 Service Pack: 768
16:30:30 ComputerName: WEBDEV
16:30:30 User Name: administrator
16:30:30 IsAllAccessAllowed returned: 1
16:30:30 OS Language: 0x409
16:30:30 End Action CheckRequirements
16:30:30 CreateSetupTopology(WEBDEV), Handle : 0x17d4308, returned : 0
16:30:30 CreateSetupTopology returned : 0, Handle : 0x17d4308
16:30:30 Topology Type : 1, Return Value : 0
16:30:30 ST_GetPhysicalNode returned : 0, PNHandle : 0x17d4328
16:30:30 PN_EnumerateEx returned : 0
16:30:31 PN_GetSQLStates returned : 0, SqlStates : 0x88028225
16:30:31 PN_StartScan [0x17d4328] returned : 0
16:30:31 PN_GetNext [0x17d4328] returned : 0, Handle: [0x17d48b0]
16:30:31 SQLI_GetPackageId [0x17d48b0] returned : 0, PackageId = 0x2
16:30:31 SQLI_GetVersion [0x17d48b0] returned : 0, Version = 8.00.194
16:30:31 PN_GetNext [0x17d4328] returned : 0, Handle: [0x17d5268]
16:30:31 PN_GetNext [0x17d4328] returned : 18, Handle: [0x0]
16:30:31 ReleaseSetupTopology
16:30:31 This combination of Package and Operating System allows a full product install.
16:30:31 Begin: SetupInstall()
16:30:31 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
16:30:31 CommonFilesDir=C:\Program Files\Common Files
16:30:31 Windows Directory=C:\WINNT\
16:30:31 Program Files=C:\Program Files\
16:30:31 TEMPDIR=C:\DOCUME~1\ADMINI~1.MIL\LOCALS~1\Temp\
16:30:31 End: SetupInstall()
16:30:31 Begin: ShowDialogs()
16:30:31 Initial Dialog Mask: 0x8300037, Disable Back=0x1
16:30:31 Begin Action ShowDialogsHlpr: 0x1
16:30:31 Begin Action: DialogShowSdWelcome
16:30:33 End Action DialogShowSdWelcome
16:30:33 Dialog 0x1 returned: 1
16:30:33 End Action ShowDialogsHlpr
16:30:33 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:30:33 Begin Action ShowDialogsHlpr: 0x2
16:30:33 Begin Action: DialogShowSdMachineName
16:30:33 ShowDlgMachine returned: 1
16:30:33 Name = WEBDEV, Type = 0x1
16:30:33 End Action DialogShowSdMachineName
16:30:33 begin ShowDialogsUpdateMask
16:30:33 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
16:30:33 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
16:30:33 Dialog 0x2 returned: 0
16:30:33 End Action ShowDialogsHlpr
16:30:33 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:30:33 Begin Action ShowDialogsHlpr: 0x4
16:30:33 Begin Action: DialogShowSdInstallMode
16:30:33 ShowDlgInstallMode returned: 1
16:30:33 InstallMode : 0x2
16:30:33 End Action DialogShowSdInstallMode
16:30:33 begin ShowDialogsUpdateMask
16:30:33 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
16:30:33 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
16:30:33 Dialog 0x4 returned: 1
16:30:33 End Action ShowDialogsHlpr
16:30:33 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
16:30:33 Begin Action ShowDialogsHlpr: 0x20
16:30:33 Begin Action: DialogShowSdLicense
16:30:34 End Action DialogShowSdLicense
16:30:34 Dialog 0x20 returned: 1
16:30:34 End Action ShowDialogsHlpr
16:30:34 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
16:30:34 Begin Action ShowDialogsHlpr: 0x200
16:30:34 Begin Action: DialogShowSdInstanceName
16:30:35 Begin Action: ShowDlgInstanceName
16:30:41 This machine has SQL Server 2000 SP2 already installed
16:30:41 Version of installed Service Pack: 8.00.534
16:30:41 The language on the CD is 1033 and installed is 1033
16:30:41 End Action : Verify Language
16:30:41 SKU is : Desktop Engine
16:30:41 End Action: ShowDlgInstanceName
16:30:41 ShowDlgInstanceName returned : 0
16:30:41 InstanceName : STARTEAM
16:30:41 End Action DialogShowSdInstanceName
16:30:41 begin ShowDialogsUpdateMask
16:30:41 nFullMask = 0xb000627, nCurrent = 0x200, nDirection = 0
16:30:41 Updated Dialog Mask: 0xbc00627, Disable Back = 0x1
16:30:41 Dialog 0x200 returned: 0
16:30:41 End Action ShowDialogsHlpr
16:30:41 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
16:30:41 Begin Action ShowDialogsHlpr: 0x400
16:30:41 Begin Action: DialogShowSdMaintain
16:30:41 ShowDlgMaintainInstall returned : 1
16:30:41 Type : 0xc
16:30:41 CreateSetupTopology(WEBDEV), Handle : 0x17d5210, returned : 0
16:30:41 CreateSetupTopology returned : 0, Handle : 0x17d5210
16:30:41 Topology Type : 1, Return Value : 0
16:30:41 ST_GetPhysicalNode returned : 0, PNHandle : 0x17d4308
16:30:41 PN_EnumerateEx returned : 0
16:30:41 PN_GetSQLStates returned : 0, SqlStates : 0x88028225
16:30:41 PN_GetInstance for STARTEAM [0x17d4308] returned : 0
16:30:41 SQLI_GetPackageId [0x17d5268] returned : 0, PackageId = 0x4
16:30:41 SQLI_GetVersion [0x17d5268] returned : 0, Version = 8.00.194
16:30:41 SQLI_GetSQLStates for STARTEAM [0x17d5268] returned : 0, SQLStates: 0xc20804
16:32:27 STARTEAM is not a SQL Server 2000 instance.
Setup will now exit.
16:32:27 ReleaseSetupTopology
16:32:27 End Action DialogShowSdMaintain
16:32:27 End: ShowDialogs()
16:32:27 Action CleanUpInstall:
16:32:27 Installation Failed.
Is there any way I can get round this without reinstalling SQL Server for this instance?
Regards
Carolyn
November 7, 2005 at 11:57 am
Did you run it as STARTEAM or servername\STARTEAM?
-SQLBill
November 8, 2005 at 2:31 am
November 9, 2005 at 8:40 am
I saw this on Tek-Tips.com. While it is for MSDE, it seems to be the same problem you are having. Try following the directions but using the SQL Server folder.
From NigelRivett on tek-tips.com
Found this on sqljunkies from a search in google
sql2kdesksp3.exe instance
If installing MSDE Service Pack 3 causes the error "Instance name is invalid," do the following:
Browse to the folder that you extracted the MSDE service pack files to.
1.Browse to the MSDE directory.
2.Right-click on the Setup.exe file and select Create Shortcut.
3.Right-click on the shortcut to Setup.exe and select Properties.
4.In the target field add /upgradesp sqlrun blanksapwd=1 after Setup.exe.
If you extracted the files to C:\sql2ksp3\MSDE the string is
"C:\sql2ksp3\MSDE\setup.exe /upgradesp sqlrun blanksapwd=1".
(do not use " " if the original string does not have it)
5.Double-click on the shortcut to Setup.exe to run the upgrade.
-SQLBill
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy