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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply