WAS640 MSSql fail to be installed

[Former Member]

I had installed WAS 640 with ease bundled SAP database.

After download EP sneak preview, I found EP could not find J2E server and J2ee instance.

I decided to install WAS MsSQL version. According to its instruction file, I choose install J2EE server I fail when create database

log:

Successfully connected to "cactsps"]]></line><line><![CDATA[ERROR 2004-06-18 14:00:32

MDB-05042 Error when executing script "create table #sapinst_check_table ([name] varchar(100) primary key, [status] varchar(20), [message] varchar(1000) not null)]]></line><line><![CDATA[declare @tmp varchar(100)

]]></line><line><![CDATA[-- major version

select @tmp = (@@microsoftversion / 65536) / 256if ( @tmp >= 8 ) insert #sapinst_check_table values ('Product version check', 'OK', 'none')else insert #sapinst_check_table values ('Product version check', 'ERROR', 'Wrong version of MS SQL Server')]]></line><line><![CDATA[-- patch level

select @tmp = @@microsoftversion % 65536if ( @tmp >= 760 ) insert #sapinst_check_table values ('Patch level check', 'OK', 'none')else insert #sapinst_check_table values ('Patch level check', 'ERROR', 'MS SQL Server patch level is too low; please read the note 62988.')]]></line><line><![CDATA[-- product edition

select @tmp = substring(convert(sysname, serverproperty('edition')), 1, 10)if ( @tmp = 'Enterprise' ) insert #sapinst_check_table values ('Edition check', 'OK', 'none')else insert #sapinst_check_table values ('Edition check', 'WARNING', 'Only enterprise edition is supported in productive environment!')]]></line><line><![CDATA[-- collation

select @tmp = convert(sysname, serverproperty('collation'))if ( @tmp = 'SQL_Latin1_General_CP850_BIN2' ) insert #sapinst_check_table values ('Collation check', 'OK', 'none')else insert #sapinst_check_table values ('Collation check', 'ERROR', 'Wrong server collation; J2EE installation requires SQL_Latin1_General_CP850_BIN2 collation')]]></line><line><![CDATA[-- sysadmin rights

select @tmp = IS_SRVROLEMEMBER('sysadmin')if ( @tmp = 1 ) insert #sapinst_check_table values ('Sysadmin rights check', 'OK', 'none')else insert #sapinst_check_table values ('Sysadmin rights check', 'ERROR', 'You do not have administrator rights on this MS SQL Server instance')]]></line><line><![CDATA[select * from #sapinst_check_table

drop table #sapinst_check_table"; error: "[Microsoft][ODBC SQL Server Driver][SQL Server]'serverproperty' is not a recognized function name.[Microsoft][ODBC SQL Server Driver][SQL Server]'serverproperty' is not a recognized function name.".]]></line><line><![CDATA[ERROR 2004-06-18 14:00:32

MDB-05034 Call to a threaded function returned "4".]]></line><line><![CDATA[***** Transaction end **********************************************************

]]></line><line><![CDATA[WARNING 2004-06-18 14:00:33

The step dAskForConnection with step key J2EE_EngineEnterprise_OneHost|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|MssJ2eeDatabase|ind|ind|ind|ind|ind|0|MssLoginInfo|ind|ind|ind|ind|ind|0|dAskForConnection was executed with status ERROR.]]></line></sapinstlog>

2004.06.18 14:00:37: XML Doc: sapinstlog

2004.06.18 14:00:37: received log document

2004.06.18 14:00:37:

2004.06.18 14:00:45: Action: ACTION_OK

2004.06.18 14:00:45: Sending:

<?xml version="1.0" encoding="utf-8"?>

<sapinstguiresp><action>ACTION_OK</action></sapinstguiresp>

2004.06.18 14:00:45: Main window activated

2004.06.18 14:00:45: Received message of length 72

2004.06.18 14:00:45: Received:

<sapinstguilogon version="1.0"><logoff version="1.0"/></sapinstguilogon>

2004.06.18 14:00:45: XML Doc: sapinstguilogon

2004.06.18 14:00:45: received logon/off request

[Former Member]

Hi

Have you got any solution for this. I am also getting similar error.

Regards

Sunil