Error in Upgrading to MS SQL 2005

[Former Member]

i have Nw2004 installed wiht MS SQL 2000 as database.

Iam in the process of upgrading this server to NW2004s.

As a pre-requisite i upgraded the MS SQL 2000 to MS SQL 2005 Server

But after upgradation of MS SQL only(NW2004 is there) when i start the SAP Instance the SAP Instance is starting.

but when i login to SAP and run any transactions it is giving a message

START_CALL_SICK.

Please let me know whether i can run MS SQL 2005 server with NW2004

[Former Member · Accepted solution]

hello Balaji,

You can ignore this error. Basically just restart the system. I would say reboot the machine. restart database and then SAP. However before that execute the transaction SICK and look for any errors.If there are any error then you need to solve them. May be you can paste them here. MS SQL 2005 is supported with Netwaeaver 04.

Check this:

https://websmp104.sap-ag.de/platforms

Regards.

Ruchit.

Message was edited by:

Ruchit Khushu

[Former Member · Accepted solution]

Dear Ruchit,

i restarted the system, Database and SAP.

But still i am having the issue

[Former Member · Accepted solution]

hello Balaji,

Did you execute SICK transaction. What is its output?Please paste it here.

Regards.

Ruchit.

[Former Member · Accepted solution]

this refers me to a note and the contents of the note are as follows

<b>The minimum basis support package levels to run on SQL Server 2005 are:

Release 4.6C -

---

> 53

Release 6.20 -

---

> 57

Release 6.40 -

---

> 15</b>

What is this support pack for SQL. Is this a component or what

[Former Member · Accepted solution]

Hello Balaji,

You need to import basis support pack 15. Go to SPAM and let me know the highest support package you have under component SAP_BASIS.

I mean you need to go for support pack upgrade using SPAM.

Regards.

Ruchit.

[Former Member · Accepted solution]

the highest support pack level is 9(SAPKB64009).

But pls confirm me whether i can run MS SQL2005 as backend for Nw2004

[Former Member · Accepted solution]

Dear Balaji,

Did you check OSS note 799058 before doing the upgrade. It clearly states the Basis SP level?

Regards.

Ruchit.

[Former Member · Accepted solution]

Dear Balaji,

Yes you can run Netweaver 04 on MS SQL 2005.

But you need to upgrade support packages upto SAPKB64015

Regards.

Ruchit.