how to change compability level in sql 2008 from 100 to 90

[Former Member]

hellow to everyone

im installed ecc 6 sr3- distrbute system- as-abap only

the sql on diffrent host

when i start the install of the centeral instance, i got the massege that i need to change the compatibility level of the sql server 2008 - from 100 to 90//

i chang it - but i still got the massege//

need help here to understand the all process to change it in the sql

maybe i done somthing wrong

thanks

yossi:-)

[markus_doehr2 · Accepted solution]

> when i start the install of the centeral instance, i got the massege that i need to change the compatibility level of the sql server 2008 - from 100 to 90//

Update your kernel so that the system knows the SQL server 2008.

Markus

[Former Member]

thanks---

i have another question please///

in diffrent installation

i start "sql4sap" to install the sql

and it start the installation automat in c drive/

i want to install it in a diffrent drive///

how can i change the drive please//

yossi

[clas_hortien]

Hi,

you cannot redirect the installation on another drive when using sql4sap.vbs. You have to follow the installation instructions in the SAP installation guide and then you can change the destination folders for some (not all) components. During the installation you come to an component select screen and in this screen you can change the folder for some of the components (eg. the storage engine) one by one. But the shared components will always be installed on the drive where "Program Files" lives.

Best regards

Clas

[Former Member]

hi

im in the midel of the centeral instance installation

so i cant change the kernel/

i start to install the centeral instance- and i get the massege in the level of the define parameter.

[clas_hortien]

Hi,

the installation files you are using do not know anything about SQL 2008.

To fix this, stop the current SAPInst and switch to the SapInst installation directory (C:\program files\sapisnt_instdir\....)

Open the control.xml file with write.exe or sappad.exe.

Find the function MssInfo.prototype.checkCompLevel and replace it with this one:

MssInfo.prototype.checkCompLevel= function(db) {
    this.getServerProperties();
    var cmd = "select cmptlevel from master.dbo.sysdatabases where name = '$db$'";
    cmd = cmd.replace(/\$db\$/g, db);
    var res = this._mss.sql.exe(cmd);

    if ( (this.Release.toString() == "8" && res == "80") ||
				 (this.Release.toString() == "9" && res == "90") ||    
         (this.Release.toString() == "10" && res == "100") ) {
      installer.writeTrace("Compatibility level check for " + db + ": ok.");
    }
    else {
      var m = "The database " + db + " has wrong compatibiliy level.";
      throw new MssCheckError(MssCheckError.COMPLEVEL, m, ["dbmodmssql.checks.compLevel", db]);
    }
}

Save and exit the file. Restart the sapinst from the original location and choose to continue the old installation. This should skip you over the compatibility level check then.

Best regards

Clas