Error while install SQL2005

[Former Member]

Hi, All:

While installing SQL 2005, followed <b>SQL4SAP_docu.pdf</b>, after first step when i choose <b>default</b>, error occurred.

The error message is <b>This version of SQL Server is not supported by this script.</b>.

The related <b>sql4sap.log</b> is posted below.

Anyone met the same problem?

Any info will be highly appreciated!

<b>SQL4SAP.log</b>

******************************************************

• Customized installation of SQL Server 2005 for SAP *

******************************************************

Log File: C:\WINDOWS\SQL4SAP.log

Script started 2007-4-3 19:54:42 on CNSHAISV

-

---

System settings:

Win32_Processor.Name=Intel(R) Xeon(TM) MP CPU 3.16GHz

Win32_Processor.Name=Intel(R) Xeon(TM) MP CPU 3.16GHz

Win32_Processor.Name=Intel(R) Xeon(TM) MP CPU 3.16GHz

Win32_Processor.Name=Intel(R) Xeon(TM) MP CPU 3.16GHz

Win32_ComputerSystem.SystemType=X86-based PC

Win32_OperatingSystem.OSType=18

Win32_OperatingSystem.Version=5.2.3790

Win32_OperatingSystem.ServicePackMajorVersion=1

Win32_OperatingSystem.Caption=Microsoft(R) Windows(R) Server 2003, Enterprise Edition

Win32_OperatingSystem.ProductType=3

Win32_OperatingSystem.OSProductSuite=274

Win32_OperatingSystem.OSLanguage=1033

-

---

Windows version:

OSVersion = 5.2

OSFamily = Windows2003

OSServicePack = 1

OSEdition = Server

OSSystemType = X86

OSProductSuite = Enterprise | Terminal Server

OSMsiVersion = 3.1.4000.2435

OSMdacVersion = 2.82.1830.0

OSLanguage = English ?United States

OSLanguageID = 1033

-

---

Environment on CNSHAISV:

userDir = C:\Documents and Settings\Administrator\

tmpDir = C:\DOCUME_1\ADMINI1\LOCALS~1\Temp\2\

rootDir = C:\WINDOWS\

prgDir = C:\Program Files\

prgDirX86 = \

-

---

SQL4SAP version:

version: ' v3.2.31 May 2006: additional return codes

size: 78434

created: 2006-6-30 13:38:33

modified: 2006-6-30 13:38:36

exe: C:\WINDOWS\system32\cscript.exe

script: P:\SQL2005SP1\SQL4SAP.vbs

P: P:

-

---

Script path:

myRoot = P:\SQL2005SP1\

myDir = P:\SQL2005SP1\x86\

myDirUNC = P:\SQL2005SP1\x86\

-

---

Script settings:

SqlAuthInstall = False

SilentInstall = False

DeEditionOnly = False

DeEditionPossible = False

SapItMsgBox = False

-

---

-

---

Service Account:

"P:\SQL2005SP1\x86\SqlCmd\GetSidName.exe" S-1-5-18 =>NT AUTHORITY\SYSTEM

OSSystemAccount= NT AUTHORITY\SYSTEM

-

---

2007-4-3 19:54:50

-

---

Input Box "Select SQL Server instance"

The following SQL Server instances were found:

Default Instance . 8.00.2040

SQL Server Native Client not installed

SQL Server 2005 Client Tools not installed

Enter a new or existing instance name.

- for a Default Instance, enter: (default) or .

- for a Named Instance, enter: <SID>

To install SQL Client Tools Only, press Cancel.

Result: (default)

-

---

2007-4-3 19:55:07

-

---

executing SQL script:

select @@version

........................................

Command: "P:\SQL2005SP1\x86\SqlCmd\sqlcmd.exe" -E -dmaster -b -h-1 -m4 -Q"select @@version"

Result:

-

---

2007-4-3 19:55:07

-

---

Message Box "Version error"

This version of SQL Server is not supported by this script.

SQL Instance: .

SQL Version:

Result: vbOK

-

---

Registry settings (2/2):

-

---

HKLM\SOFTWARE\Microsoft\DataAccess\FullInstallVer

READ: 2.82.1830.0

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\KB899761(ENU)\DisplayName

READ: Hotfix 2040 for SQL Server 2000 ENU (KB899761)

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Microsoft SQL Server 2000\DisplayName

READ: Microsoft SQL Server 2000

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\MSSQLSERVER

READ:

HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters\SQLArg0

READ: -dC:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf

HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters\SQLArg1

READ: -eC:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG

HKLM\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion\Version

READ:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion\PatchLevel

READ:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion\CurrentVersion

READ:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion\CSDVersion

READ:

-

---

2007-4-3 19:55:08

Quit script with return code 1

[clas_hortien]

Hello,

the SQL4SAP script doesn't support upgrades of SQL Server 2000 to SQL Server 2005. On your system is a SQL 2000 installed and you want to install SQL 2005. If you want to upgrade your installation you have to start the setup.exe from the directory

<platform>\EnterpriseEdition\Servers

Or you install a named instance in paralell. Therefor you have to specify a name for the instance in the first inputbox.

Best regards

Clas