SAP down after SQL 2012 Upgrade

[Former Member]

Hi Team,

We have upgraded the Database from 2008R2 SP1 to 2012 SP1. Next we ran database upgrade completion from database tools.

After that SAP is not coming up, disp+work is stopped.

It is showing below error, updated SQL 2012 version is version is 11.00.2100.60 with SQL native client , and here 10.50.2769 version is old 2008R2 Native clients. Im not sure why it is showing older version. Could you guys help me on this.

C  Error: The driver release (10) is lower than the server release (11)

M Thu Mar 19 20:34:40 2015

M  calling db_connect ...

B  Loading DB library 'G:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll' ...

B  Library 'G:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll' loaded

B  Version of 'G:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll' is "721.02", patchlevel (0.225)

C  Callback functions for dynamic profile parameter registered

C  Thread ID:3468

C  Thank You for using the SLODBC-interface

C  Using dynamic link library 'G:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll'

C  7210 dbmssslib.dll patch info

C    SAP patchlevel  0

C    SAP patchno  300

C    Last MSSQL DBSL patchlevel 0

C    Last MSSQL DBSL patchno         225

C    Last MSSQL DBSL patchcomment Workprocess exit when reading long character fields using (1996416)

C  ODBC Driver chosen: SQL Server Native Client 10.0 native

C  Network connection used from XXXXXXDEVCI1 to XXXXXXDQDB1 using tcp:XXXXXXDQDB1

C  Network connection used from XXXXXXDEVCI1 to XXXXXXDQDB1 using tcp:XXXXXXDQDB1

C  Driver: sqlncli10.dll Driver release: 10.50.2769

C  GetDbRelease: 11.00.2100.60

C  GetDbRelease: Got DB release numbers (11,0,2100,60)

C  Error: The driver release (10) is lower than the server release (11)

B  ***LOG BY2=> sql error 0      performing CON [dbsh         1246]

B  ***LOG BY0=> <message text not available> [dbsh         1246]

B  ***LOG BY2=> sql error 0      performing CON [dblink       544]

B  ***LOG BY0=> <message text not available> [dblink       544]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1524]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11535]

Regards

Nani

[mamartins · Accepted solution]

Hi,

On the SAP host server, you need to upgrade the SQL Server Native Client to match the SQL Server version.

It's also valid if both reside on same server. Probably, the upgrade step you choose only upgrade the SQL Server instance.

MM

[Former Member · Accepted solution]

Thanks Martins, that works like a charm.

Regards

Nani