SQL2005 cluster error MDB-05053 Errors when executing sql command: <p nr="

[Former Member]

Hi all,

We are migrating from 32 bit to x64 bit machines. SQL 2005 database on windows 2003.

I am trying to install E 4.7-200 SR1 on the clustered nodes. The installation manuals for 4.7 are very old and there is nothing for SQL2005 installation.

Now that some how we were able to have SQL up and running in clustered environment (It only took 10 days), After installing CI, I am not able to deploy the database and database creation phase is failing with the following error:

MDB-05053 Errors when executing sql command: <p nr="0"/>.

I am heavily relying on our server managment team on clustering and hoping they have done a good job, However I need some guidelines which can help me in verifying what they have done is correct and meets SAP and SQL requirments and issues we are facing is actually install problems not cluster.

SAP install manuals are not detailed in this regards. Also manuals are out dataed and they only show the sql 2000 clustering pre-requisit for 4.7 installls.

Can any one with clustering experience please help.

Calling out NPC, As his sql installation and upgrade manual has helped me with stand alone installs, Hoping he has some thing for clustering as well.

Regards,

KG

[rolfc_weber · Accepted solution]

Hi,

What installation CD/DVD are you using?

Try look at SAP note [924288|https://service.sap.com/sap/support/notes/924288],

and note [969699|https://service.sap.com/sap/support/notes/969699],

and note [967124|https://service.sap.com/sap/support/notes/967124],

and note [106275|https://service.sap.com/sap/support/notes/106275].

In special the last note say at the end:

"3. You must use the 51031444 CD to install Enterprise 4.7 on an x64 platform with SQL Server 2005. This CD installs the central instances and database instances. To convert the A and B nodes in MSCS, use the SAP NetWeaver 04 SR1 installation master CD or DVD."

Hope this helps

Regards

Rolf

[Former Member · Accepted solution]

Rolf,

This is good news, However I can not locate this CD. Do I need to order this?

Regards,

KG

[rolfc_weber · Accepted solution]

Hi,

Go for the so called patch collection CD/DVD (Cd no. 51032936), it's a newer combined installation CD/DVD for systems based on basis release 6.20 & 6.40, so it should include all in one.

Regards

Rolf

[Former Member · Accepted solution]

Rolf,

Thank you for your help. However problem was not the installation packages. Problem was the dependency of the drives. By correcting the dependencied I was able to proceed.

However, I am experiencing allots of issues installing SQL on clustered environment. Do you or Can you direct me to SAP notes or anything that can help me undrestand the pre-requesitis for SQL install/Upgrade on clustered environment?

SAP installation manuals are very basic when it comes to clustering.

Regards,

KG

[rolfc_weber · Accepted solution]

Hi,

The prerequisites are described in the SAP installation guide depending of your release and system type.

Big differance is that you can not use the SAP installation script to install SQL in Cluster, but have to install it manually with setup.exe....

SAP Notes? Well [803018|https://service.sap.com/sap/support/notes/803018] is maybe a starting point and from there further.

Regards

Rolf