Error Installation SAP PI on NW 7.4 and MSSQL 2008 in database instance, Errors when executing sql command

[Former Member]

Hi All,

We are in the midst of implementing SAP PI based on NW 7.4 running on Windows server 2008 R2 and MSSQL server 2008.

The installation type is distributed.

We were successfully able to install the ASCS and SCS instance on the SAP host.

Have also installed the MSSQL software on the DB host and SQL Native client software on the SAP host.

However, during the installation of Database instance on the DB host we face the below error when we define parameters related to database named instance.

After providing details on the database instance we get the below error in the sapinst log.

FCO-00011  The step dAskForConnection with step key |NW_Doublestack_DB|ind|ind|ind|ind|0|0|NW_GetSidMaybeProfiles|ind|ind|ind|ind|getSid|0|NW_GetSidFromProfilesPartial|ind|ind|ind|ind|havepf|0|NW_getDBInfo|ind|ind|ind|ind|db|0|NW_MSS_DBINFO|ind|ind|ind|ind|mss|0|MssLoginInfo|ind|ind|ind|ind|login|0|dAskForConnection was executed with status ERROR ( Last error reported by the step: Errors when executing sql command: [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared

<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support. </p>).

As per OSS 1609770 - Tracing database queries executed by sapinst, SWPM or SAP Tools for SQL Server we set the environment variable SAPINST_MSS_LOG = ON to capture the exact query causing the error.

Details of the MSSlog as below

------------------------------------------------

select (@@microsoftversion / 65536) / 256

------------------------------------------------

executeSQL is called with following parameters:

Server: XXXXX

Login: integrated security

Resultset will be copied to t_MssErrorLogEntriesLight

Ignore errors is false

Append results is false

------------------------------------------------

create table #temp(v1 varchar(100), v2 varchar(100), v3 varchar(4000))

insert #temp execute master..xp_readerrorlog

select case when v3 is NULL then '' else v3 end from #temp where v3 like 'Server is listening%'

drop table #temp

------------------------------------------------

[Microsoft][ODBC SQL Server Driver]Associated statement is not prepared

------------------------------------------------

Request your kind assistance in resolving this issue.

Regards,

Nilesh Jagtap

[former_member188883]

Hi Nilesh,

Please have a look into below SAP note

1887354 *

[ODBC SQL Server Driver] Associated statement is not prepared

Hope this helps.

Regards,

Deepak Kori

[former_member184473]

Hello Nilesh,

Whish SWPM version are you using?

This issue is normally related to SQL Server errorlog being rebuilded (sp_cycle_errorlog).

Proceed as following:

1) Stop the SAP installation

2) Restart SQL Server (not log rebuild)

3) Restart the SAP installation

Regards,

Eduardo Rezende