SQL7 and SP3

  • One of my users has W98 and SQL7 Desktop intalled. He tried to run Setup.bat from SP3, but got the following

    "PRODUCT_NAME - entry not found in the string table" followed by more missing keys and strings. Finally the setup program aborts.

    What could be causing this ?

    Many Thanks

    Simon


    Simon

  • There should be two files left behind by the install I cannot rememeber their names but they are something like sql(something).log and cnfg but they should have been created on the day this was run. Finds thes and post their content as they have a lot of detail which can help solve this issue.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Here is the contents of sqlsp.log

    16:39:08 Mode: Normal

    16:39:25 ComputerName: LOUISE

    16:39:29 ValueLic returned: 1

    16:39:29 GetDefinition returned: 1

    16:39:29 Previous SQL Server ProductType: Desktop Edition [0x2]

    16:39:29 Begin Action: Detection

    16:39:32 7.00.961

    16:39:32 Begin Rules

    16:39:32 SZ_VERSION=7.0.961

    16:39:32 CurrentVersion=7.0.623

    16:39:32 SQL Server version already installed: 7.00.623

    16:39:32 Previous Install SQL Path: C:\MSSQL7

    16:39:32 Previous Install SQL Data Path: C:\MSSQL7

    16:39:32 SUPPORTDIR - C:\WINDOWS\TEMP\_ISTMP9.DIR16:39:32

    16:39:33

    16:39:33 Lang 0x0 vs. 0x9

    16:39:34 File Version - C:\MSSQL7\BINN\sqlservr.exe: 1998.11.13.0

    16:39:34 Look at: F:\70SP3\X86\BINN

    16:39:35 File Version - F:\70SP3\X86\BINN\sqlservr.exe: 2000.10.24.0

    16:39:35 End Action Detection

    16:39:35 Lang 0x0 vs. 0x9

    16:39:36 TARGETDIR - C:\MSSQL7

    16:39:36 ComponentSetTarget - <SQLDataDir> C:\MSSQL7

    16:39:36 ComponentSetTarget - <SQLResDir> C:\MSSQL7\Binn\Resources\1033

    16:39:36 ComponentSetTarget - <MSD98Res> C:\Program Files\Common Files\Microsoft Shared\MSDesigners98\Resources\1033

    16:39:36 Begin SelectComponents

    16:39:37 End SelectComponents

    16:39:37 Prog req vs. avail, 44032, 2096832, C:

    16:39:37 Data req vs. avail, 6144, 2096832, C:

    16:39:37 Sys req vs. avail, 41984, 2096832, C:

    16:39:37 Begin ShowDialogs

    16:39:37 Begin Welcome Dialog

    16:39:54 Begin License Dialog

    16:41:13

    16:41:13 JET

    16:41:13 Base

    16:41:13 Base\Base Files

    16:41:13 Base\Base Res Files

    16:41:13 Base\Base Sys Files

    16:41:13 Base\Base Resi Files

    16:41:13 Base\Base Rg Files

    16:41:13 Base Server

    16:41:13 Base Server\Base Server Files

    16:41:13 Base Server\Base Server Sh Repl Files

    16:41:13 Base Server\Base Server SQL Files

    16:41:13 Base Client

    16:41:13 Base Client\Base Client Files

    16:41:13 Base Client\Base Client Res Files

    16:41:13 Base Client\Base Client Resi Files

    16:41:13 Extended Server

    16:41:13 Extended Server\Extended Server Files

    16:41:13 Extended Server\Extended Server Res Files

    16:41:13 Extended Server\Extended System

    16:41:13 SEM MSD98

    16:41:13 SEM MSD98\MSD98

    16:41:13 SEM MSD98\MSD98SYS

    16:41:13 SEM MSD98\MSD98Res

    16:41:13 SEM MSD98\MSD98Rsl

    16:41:13 Repl

    16:41:13 Repl\Server Repl Files

    16:41:13 Repl\Server Repl Rg Comm Files

    16:41:13 Repl\Server Repl Data Files

    16:41:13 Profiler

    16:41:13 SEM

    16:41:13 SEM\SEM Rg Files

    16:41:13 SEM\SEM Sys Files

    16:41:13 SEM\SEM Files

    16:41:13 SEM\SEM Res Files

    16:41:13 SEM\SEM Resi Files

    16:41:13 SEM\SEM FullText Files

    16:41:13 SEM\SEM Repos Files

    16:41:13 SEM\SEM HTML Files

    16:41:13 SvrExt

    16:41:13 SvrExt\Svr Ext Files

    16:41:13 SvrExt\Svr Ext Repos Files

    16:41:13 SvrExt\Svr Ext Res Files

    16:41:13 SvrExt\Svr Ext Resi Files

    16:41:13 UtilQraz

    16:41:13 UtilQraz\UtilQras Files

    16:41:13 UtilQraz\UtilQras Res Files

    16:41:13 UtilQraz\UtilQras Resi Files

    16:41:13 Wzcnflct

    16:41:13 DTSBase

    16:41:13 DTSBase\DTSBase Files

    16:41:13 DTSBase\DTSBase Res Files

    16:41:13 DTSBase\DTSBase Resi Files

    16:41:13 DTSBase\DTSBase Rg Files

    16:41:13 Books

    16:41:13 TraceSvr

    16:41:13 TraceClnt

    16:41:13 SfExt

    16:41:13 SfExt\SfExt1033

    16:41:13 SfExt\SfExtOther

    16:41:13 SQL Package - Desktop Edition . 2

    16:41:13 Client Install - YES

    16:41:13 Server Install - YES

    16:41:13 Begin SDPassword Dialog

    16:42:04 End SDPassword Dialog

    Any clues ??!!

    Simon


    Simon

  • Ok this file looks fine. However does he have OLAP server items installed for SQL. If so then take a look here at MS KB Article

    quote:


    BUG: OLAP Service Pack Install May Fail When Incorrect Language Version of Service Pack is Applied (Q256150)

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q256150


    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Thanks, I'll get them to try this (another user has exactly the same problem !!)

    Simon


    Simon

  • My user machine reports that it is running us_english version of SQL as is my machine (which performed the sp installation Ok), so any further ideas, or will I have to re-install SQL on these machines ?

    Simon


    Simon

  • Ok, I am baffled primarily since the sqlsp.log file does not containt a failed line. My last thought is find the .out files that occurr when the upgrade is done and see if any have messages about failure, without any other information on this message or any details on what sql was oing when it failed I would have to then say reinstall (which may require wipping to get a clean install).

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Looks like I will have to do a clean install, which is a bit of bore, however, no data has been lost !!

    Thanks for your help

    Simon


    Simon

  • Sorry couldn't offer a better option.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply