Re: Failed installation of SQL Server 2000 Enterprise on Windows 2

Do you have any certificates at all? Maybe IIS with an SSL cert? SQL setup
is trying to create an encrypted connection and failing, this suggests there
is a certificate somewhere on the server.

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Always Learning" <AlwaysLearning@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:2829DF88-1F39-484A-9B69-7CA79330B071@xxxxxxxxxxxxxxxx
>I wish this would have helped...but I do not have Certificate Services
> installed.
>
> "Jasper Smith" wrote:
>
>> > [Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not
>> > supported
>> > on SQL Server
>>
>> Do you have Certificate Services (or any certificates) installed on the
>> server? If trying to install SQL on a server with Certificate Services
>> installed, you need to remove Certificate Services before installing SQL.
>>
>> --
>> HTH
>>
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>> "Always Learning" <AlwaysLearning@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:2D7E0A0D-F833-492E-B1E2-7017A94E67F4@xxxxxxxxxxxxxxxx
>> > Installation seems to go fine....until the very end.....below is the
>> > log
>> > file, andy help would be appreciated....
>> >
>> > 07:23:39 Begin Setup
>> > 07:23:39 8.00.194
>> > 07:23:39 Mode = Normal
>> > 07:23:39 ModeType = NORMAL
>> > 07:23:39 GetDefinitionEx returned: 0, Extended: 0x0
>> > 07:23:39 ValueFTS returned: 1
>> > 07:23:39 ValuePID returned: 1
>> > 07:23:39 ValueLic returned: 1
>> > 07:23:39 System: Windows NT Terminal Server
>> > 07:23:39 SQL Server ProductType: Enterprise Edition [0x3]
>> > 07:23:39 Begin Action: SetupInitialize
>> > 07:23:39 End Action SetupInitialize
>> > 07:23:39 Begin Action: SetupInstall
>> > 07:23:39 Reading
>> > Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
>> > ...
>> > 07:23:39 CommonFilesDir=C:\Program Files\Common Files
>> > 07:23:39 Windows Directory=C:\WINNT\
>> > 07:23:39 Program Files=C:\Program Files\
>> > 07:23:39 TEMPDIR=C:\DOCUME~1\ejohnson\LOCALS~1\Temp\1\
>> > 07:23:39 Begin Action: SetupInstall
>> > 07:23:39 digpid size : 256
>> > 07:23:40 digpid size : 164
>> > 07:23:40 Begin Action: CheckFixedRequirements
>> > 07:23:40 Platform ID: 0xf00
>> > 07:23:40 Version: 5.0.2195
>> > 07:23:40 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1622
>> > 07:23:40 End Action: CheckFixedRequirements
>> > 07:23:40 Begin Action: ShowDialogs
>> > 07:23:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
>> > 07:23:40 Begin Action ShowDialogsHlpr: 0x1
>> > 07:23:40 Begin Action: DialogShowSdWelcome
>> > 07:23:45 End Action DialogShowSdWelcome
>> > 07:23:45 Dialog 0x1 returned: 1
>> > 07:23:45 End Action ShowDialogsHlpr
>> > 07:23:45 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
>> > 07:23:45 Begin Action ShowDialogsHlpr: 0x2
>> > 07:23:45 Begin Action: DialogShowSdMachineName
>> > 07:23:56 ShowDlgMachine returned: 1
>> > 07:23:56 Name = NIMALTIRIS, Type = 0x1
>> > 07:23:56 Begin Action: CheckRequirements
>> > 07:23:56 Processor Architecture: x86 (Pentium)
>> > 07:23:56 Service Pack: 1024
>> > 07:23:56 ComputerName: NIMALTIRIS
>> > 07:23:56 User Name: ejohnson
>> > 07:23:56 IsAllAccessAllowed returned: 1
>> > 07:23:56 OS Language: 0x409
>> > 07:23:56 End Action CheckRequirements
>> > 07:23:56 This combination of Package and Operating System allows a full
>> > product install.
>> > 07:23:56 CreateSetupTopology(NIMALTIRIS), Handle : 0x1884438, returned
>> > : 0
>> > 07:23:56 CreateSetupTopology returned : 0, Handle : 0x1884438
>> > 07:23:56 Topology Type : 1, Return Value : 0
>> > 07:23:56 ST_GetPhysicalNode returned : 0, PNHandle : 0x1884488
>> > 07:23:56 PN_EnumerateEx returned : 0
>> > 07:23:56 PN_GetSQLStates returned : 0, SqlStates : 0x0
>> > 07:23:56 PN_StartScan [0x1884488] returned : 0
>> > 07:23:56 PN_GetNext [0x1884488] returned : 18, Handle: [0x0]
>> > 07:23:56 No more items in enumeration.
>> > 07:23:56 ReleaseSetupTopology
>> > 07:23:56 Named instance limit: 100, quota: 0
>> > 07:23:56 End Action DialogShowSdMachineName
>> > 07:23:56 begin ShowDialogsUpdateMask
>> > 07:23:56 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
>> > 07:23:56 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
>> > 07:23:56 Dialog 0x2 returned: 0
>> > 07:23:56 End Action ShowDialogsHlpr
>> > 07:23:56 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
>> > 07:23:56 Begin Action ShowDialogsHlpr: 0x4
>> > 07:23:56 Begin Action: DialogShowSdInstallMode
>> > 07:24:27 ShowDlgInstallMode returned: 1
>> > 07:24:27 InstallMode : 0x1
>> > 07:24:27 End Action DialogShowSdInstallMode
>> > 07:24:27 begin ShowDialogsUpdateMask
>> > 07:24:27 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
>> > 07:24:27 Updated Dialog Mask: 0x1bf40037, Disable Back = 0x1
>> > 07:24:27 Dialog 0x4 returned: 1
>> > 07:24:27 End Action ShowDialogsHlpr
>> > 07:24:27 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
>> > 07:24:27 Begin Action ShowDialogsHlpr: 0x10
>> > 07:24:27 Begin Action: DialogShowSdRegisterUserEx
>> > 07:24:37 End Action DialogShowSdRegisterUserEx
>> > 07:24:37 Dialog 0x10 returned: 1
>> > 07:24:37 End Action ShowDialogsHlpr
>> > 07:24:37 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
>> > 07:24:37 Begin Action ShowDialogsHlpr: 0x20
>> > 07:24:37 Begin Action: DialogShowSdLicense
>> > 07:24:39 End Action DialogShowSdLicense
>> > 07:24:39 Dialog 0x20 returned: 1
>> > 07:24:39 End Action ShowDialogsHlpr
>> > 07:24:39 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
>> > 07:24:39 Begin Action ShowDialogsHlpr: 0x40000
>> > 07:24:39 Begin Action: DialogShowSdCliSvr
>> > 07:24:39 DisplaySystemPreReq
>> > 07:25:34 ShowDlgClientServerSelect returned: 1
>> > 07:25:34 Type : 0x2
>> > 07:25:34 End Action DialogShowSdCliSvr
>> > 07:25:34 begin ShowDialogsUpdateMask
>> > 07:25:34 nFullMask = 0x1bf40037, nCurrent = 0x40000, nDirection = 1
>> > 07:25:34 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
>> > 07:25:34 Dialog 0x40000 returned: 1
>> > 07:25:34 End Action ShowDialogsHlpr
>> > 07:25:34 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
>> > 07:25:34 Begin Action ShowDialogsHlpr: 0x80000
>> > 07:25:34 Begin Action: DialogShowSdInstanceName
>> > 07:25:34 Begin Action: ShowDlgInstanceName
>> > 07:26:09 End Action: ShowDlgInstanceName
>> > 07:26:09 ShowDlgInstanceName returned : 1
>> > 07:26:09 InstanceName : MSSQLSERVER
>> > 07:26:09 CreateSetupTopology(NIMALTIRIS), Handle : 0x1884a00, returned
>> > : 0
>> > 07:26:09 CreateSetupTopology returned : 0, Handle : 0x1884a00
>> > 07:26:09 Topology Type : 1, Return Value : 0
>> > 07:26:09 ST_GetPhysicalNode returned : 0, PNHandle : 0x1884488
>> > 07:26:09 PN_EnumerateEx returned : 0
>> > 07:26:09 PN_GetSQLStates returned : 0, SqlStates : 0x0
>> > 07:26:09 PN_StartScan [0x1884488] returned : 0
>> > 07:26:09 PN_GetNext [0x1884488] returned : 18, Handle: [0x0]
>> > 07:26:09 No more items in enumeration.
>> > 07:26:09 ReleaseSetupTopology
>> > 07:26:09 End Action DialogShowSdInstanceName
>> > 07:26:09 begin ShowDialogsUpdateMask
>> > 07:26:09 nFullMask = 0x1bfc0037, nCurrent = 0x80000, nDirection = 1
>> > 07:26:09 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
>> > 07:26:09 Dialog 0x80000 returned: 1
>> > 07:26:09 End Action ShowDialogsHlpr
>> > 07:26:09 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
>> > 07:26:09 Begin Action ShowDialogsHlpr: 0x100000
>> > 07:26:09 Begin Action: DialogShowSdSetupType
>> > 07:26:09 Begin Action: Setup Type
>> > 07:28:01 SQL program folder: C:\Program Files\Microsoft SQL Server
>> > 07:28:01 SQL data folder: e:\express
>> > 07:28:01 Windows system folder: C:\WINNT\system32\
>> > 07:28:01 Prog req: 38205, Data req: 34432, Sys req: 182917
>> > 07:28:01 Prog avail: 4176400, Data avail: 60465916, Sys avail: 4176400
>> > 07:28:01 Prog req vs. avail, 221122, 4176400
>> > 07:28:01 Data req vs. avail, 34432, 60465916
>> > 07:28:01 Sys req vs. avail, 182917, 4176400
>> > 07:28:01 DisplaySystemPreReq
>> > 07:28:01 [SetupTypeSQL]
>> > 07:28:01 szDir = C:\Program Files\Microsoft SQL Server
>> > 07:28:01 szDir = %PROGRAMFILES%\Microsoft SQL Server
>> > 07:28:01 Result = 301
>> > 07:28:01 szDataDir = e:\express
>> > 07:28:01 szDataDir = e:\express
>> > 07:28:01 End Action: Setup Type
>> > 07:28:01 Setup Type: Typical (301)
>> > 07:28:02 End Action DialogShowSdSetupType
>> > 07:28:02 begin ShowDialogsUpdateMask
>> > 07:28:02 nFullMask = 0x1bfc0037, nCurrent = 0x100000, nDirection = 301
>> > 07:28:02 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
>> > 07:28:02 Dialog 0x100000 returned: 301
>> > 07:28:02 End Action ShowDialogsHlpr
>> > 07:28:02 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
>> > 07:28:02 Begin Action ShowDialogsHlpr: 0x400000
>> > 07:28:02 Begin Action: DlgServices
>> > 07:29:24 ShowDlgServices returned: 1
>> > 07:29:24 [DlgServices]
>> > 07:29:24 Local-Domain = 61680
>> > 07:29:24 AutoStart = 15
>> > 07:29:24 SQLDomain = IISD1
>> > 07:29:24 SQLDomainAcct = ejohnson
>> > 07:29:24 SQLDomainPwd
>> > 07:29:25 AgtDomain = IISD1
>> > 07:29:25 AgtDomainAcct = ejohnson
>> > 07:29:25 AgtDomainPwd
>> > 07:29:25 Result = 1
>> > 07:29:25 End Action DlgServices
>> > 07:29:25 begin ShowDialogsUpdateMask
>> > 07:29:25 nFullMask = 0x1bdc0037, nCurrent = 0x400000, nDirection = 1
>> > 07:29:25 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
>> > 07:29:25 Dialog 0x400000 returned: 1
>> > 07:29:25 End Action ShowDialogsHlpr
>> > 07:29:25 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
>> > 07:29:25 Begin Action ShowDialogsHlpr: 0x800000
>> > 07:29:25 Begin Action: DlgSQLSecurity
>> > 07:29:55 ShowDlgSQLSecurity returned: 1
>> > 07:29:55 LoginMode = 2,szPwd
>> > 07:29:55 End Action DlgSQLSecurity
>> > 07:29:55 begin ShowDialogsUpdateMask
>> > 07:29:55 nFullMask = 0x1bdc0037, nCurrent = 0x800000, nDirection = 1
>> > 07:29:55 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
>> > 07:29:55 Dialog 0x800000 returned: 1
>> > 07:29:55 End Action ShowDialogsHlpr
>> > 07:29:55 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
>> > 07:29:55 Begin Action ShowDialogsHlpr: 0x1000000
>> > 07:29:55 Begin Action: DlgCollation
>> > 07:29:55 ShowDlgCollation returned: 1
>> > 07:29:55 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name =
>> > Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
>> > 07:29:55 End Action DlgCollation
>> > 07:29:55 begin ShowDialogsUpdateMask
>> > 07:29:55 nFullMask = 0x1bdc0037, nCurrent = 0x1000000, nDirection = 1
>> > 07:29:55 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
>> > 07:29:55 Dialog 0x1000000 returned: 1
>> > 07:29:55 End Action ShowDialogsHlpr
>> > 07:29:55 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
>> > 07:29:55 Begin Action ShowDialogsHlpr: 0x2000000
>> > 07:29:55 Begin Action: DlgNetwork
>> > 07:29:55 ShowDlgNetwork returned: 1
>> > 07:29:55 [DlgServerNetwork]
>> > 07:29:55 NetworkLibs = 255
>> > 07:29:55 TCPPort = 1433
>> > 07:29:55 TCPPrxy = Default
>> > 07:29:55 NMPPipeName = \\.\pipe\sql\query
>> > 07:29:55 Result = 1
>> > 07:29:55 End Action DlgNetwork
>> > 07:29:55 begin ShowDialogsUpdateMask
>> > 07:29:55 nFullMask = 0x1bdc0037, nCurrent = 0x2000000, nDirection = 1
>> > 07:29:55 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
>> > 07:29:55 Dialog 0x2000000 returned: 1
>> > 07:29:55 End Action ShowDialogsHlpr
>> > 07:29:55 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
>> > 07:29:55 Begin Action ShowDialogsHlpr: 0x8000000
>> > 07:29:55 Begin Action: DialogShowSdStartCopy
>> > 07:30:20 End Action DialogShowSdStartCopy
>> > 07:30:20 begin ShowDialogsUpdateMask
>> > 07:30:20 nFullMask = 0x1bdc0037, nCurrent = 0x8000000, nDirection = 1
>> > 07:30:20 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
>> > 07:30:20 Dialog 0x8000000 returned: 1
>> > 07:30:20 End Action ShowDialogsHlpr
>> > 07:30:20 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
>> > 07:30:20 Begin Action ShowDialogsHlpr: 0x10000000
>> > 07:30:20 Begin Action: DialogShowSdLicenseMode
>> > 07:31:54 ShowDlgLicense returned: 1
>> > 07:31:54 ShowDlgLicense returned: LicenseMode = 2, LicenseLimit = 4
>> > 07:31:54 End Action DialogShowSdLicenseMode
>> > 07:31:54 Dialog 0x10000000 returned: 1
>> > 07:31:54 End Action ShowDialogsHlpr
>> > 07:31:54 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
>> > 07:31:54 End Action ShowDialogs
>> > 07:31:54 Begin Action ProcessBeforeDataMove:
>> > 07:31:54 DeinstallStart returned (C:\Program Files\Microsoft SQL
>> > Server\MSSQL): 0
>> > 07:31:54 End Action ProcessBeforeDataMove:
>> > 07:31:54 Begin Action SetToolsComponentSelection:
>> > 07:31:54 End Action SetToolsComponentSelection:
>> > 07:31:54 Begin Action ProcessComponentSelection:
>> > 07:31:54 End Action ProcessComponentSelection
>> > 07:31:54 Begin Action LogSelectedComponents:
>> > 07:31:54 SQLProg
>> > 07:31:54 SQLProg\SQLServr
>> > 07:31:54 SQLProg\SQLServr\Help
>> > 07:31:54 SQLProg\SQLServr\SCMDev
>> > 07:31:54 SQLProg\SQLServr\SCMDev\SCMh
>> > 07:31:54 SQLProg\SQLServr\SCMDev\SCMX86Lb
>> > 07:31:54 SQLProg\SQLServr\SCMDev\SCMALb
>> > 07:31:54 SQLProg\SQLServr\Rs1033
>> > 07:31:54 SQLProg\SQLServr\RsIntl
>> > 07:31:54 SQLProg\SQLServr\ActiveX
>> > 07:31:54 SQLProg\SQLServr\System
>> > 07:31:54 SQLProg\UpgTools
>> > 07:31:54 SQLProg\UpgTools\UpgSys
>> > 07:31:54 SQLProg\UpgTools\ActiveX
>> > 07:31:54 SQLProg\UpgTools\Res1033
>> > 07:31:54 SQLProg\UpgTools\ResOther
>> > 07:31:54 SQLProg\UpgTools\Resld
>> > 07:31:54 SQLProg\ReplSupp
>> > 07:31:54 SQLProg\ReplSupp\ReplDat
>> > 07:31:54 SQLProg\ReplSupp\RepComm
>> > 07:31:54 SQLProg\ReplSupp\RepNoDk
>> > 07:31:54 SQLProg\ReplSupp\ActiveX
>> > 07:31:54 SQLProg\Install
>> > 07:31:54 SQLProg\System
>> > 07:31:54 SQLProg\SvrExt
>> > 07:31:54 SQLProg\SvrExt\Help
>> > 07:31:54 SQLProg\SvrExt\SvrExtRs
>> > 07:31:54 SQLProg\SvrExt\ResIntl
>> > 07:31:54 SQLProg\Dat
>> > 07:31:54 SQLProg\DatSmpl
>> > 07:31:54 SQLProg\BaseSys
>> > 07:31:54 SQLProg\BaseBinn
>> > 07:31:54 SQLProg\MSSearch
>> > 07:31:54 SQLProg\MSSearch\Help
>> > 07:31:54 SQLProg\MSSearch\ActiveX
>> > 07:31:54 SQLProg\BaseInst
>> > 07:31:54 SQLProg\Symbols
>> > 07:31:54 SQLProg\Symbols\EXE
>> > 07:31:54 SQLProg\Symbols\DLL
>> > 07:31:54 SQLProg\Perfmon
>> > 07:31:54 SQLProg\Perfmon\System


.

Relevant Pages

  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)