MSSCONCHECK.SQL query

[Former Member]

We are in the process of running the SAP R/3 Upgrade from 4.0B to ECC

5.0. Current environment is:

- Windows 2003 Std

- MSSQL server 2000

We are receiving an error when the PREPARE program reaches the point of

running the MSSCONCHECK.SQL query.

The following query does not work on the commandline, (suggested by the

program as a test):

osql -E -S [HOSTNAME] -Q "select VERSION from SVERS" -n

As the output is:

[Shared Memory]SQL Server does not exist or access denied.

[Shared Memory]ConnectionOpen (Connect()).

When I edit the query as follows:

osql -E -S [HOSTNAME]\[INSTANCE] -Q "select VERSION from

[INSTANCE].dbo.SVERS" -n

I receive the following message:

VERSION

-

---

40B

(1 row affected)

I've read and review the note 908718 and the user <sid>adm is correct.

Thank's in advanced

[former_member185954]

Hi,

Check the following note and ensure all environment variables are set:

Note 98678 - SQL Server Connection Issues

Regards,

Siddhesh