Hi Amr,
Please check installation manual. It refers ( I copied the section):
***********************************************************************
<b>Installing the Corrected MS SQL Server Collation</b>
When you install the MS SQL Server 2000 database for an SAP system, in the eld Collation Settings we recommend
that you select Binary order for use with the 850 (Multilingual) Character Set.
This means that all new databases and table columns will be created with this collation setting.
. Note
To view the default collation of MS SQL Server use the query:
select serverproperty('collation')
This query returns the default collation of the overall server. When you have selected code page cp850, it
returns: SQL_Latin1_General_CP850_BIN
Unfortunately this collation setting does not sort Unicode data as it is required by an SAP system. To solve this
problem, Microsoft provides a corrected collation as a hot x (QFE) for SQL Server. The QFE is included in the
hot x you installed during the standard installation for the MS SQL Server database. [page 11]
When you have installed the hot x, you have to run the executable INSTCOLL.EXE from SAP, as desribed
below. For more information on INSTCOLL.EXE, see SAP Note 600027.
Prerequisites
■ You have installed the MS SQL Server 2000 database. In the eld Collation Settings, you selected Binary order for
use with the 850 (Multilingual) Character Set.
■ If you run your SQL Server in a 32-bit system, you have installed SP3 and the latest hot x. For more
information, refer to SAP Notes 62988 and SAP Note 608651.
■ If you run your SQL Server in a 64-bit system, you have installed the latest hot x. For more information,
see SAP Note 608651.
. Note
Besides applying SP3 and/or the hot x you do not have to make any changes on the client side (SAP
application servers).
■ To obtain a correct collation order with MS SQL Server, you have to use the new collation for all new
installations of a Unicode or non-Unicode SAP system with the MS SQL Server database. New versions of
the SAPinst installation tool check for the new collation.
■ At present, there is no need to convert existing SAP system installations to the new collation.
■ A new SAP system using the new collation and an existing SAP system that is using the old collation cannot
run as two databases in the same MS SQL Server instance. If you want to install a new system on a database
server with an existing system you have to apply the new collation with INSTCOLL.EXE.
Procedure
1. Download the INSTCOLL.EXE le, which is attached as zip le to SAP Note 600027, and extract it to your
server.
2. Open a command prompt and change to the directory where you extracted the INSTCOLL.EXE le.
16 PUBLIC December 22, 2004
2 Standard Installation
2.1 Installation Process
3. Enter the following:
■ For a default instance enter: INSTCOLL.EXE
■ For a named instance enter: INSTCOLL.EXE -S<server>\<instance> (without any spaces after —S)
The collation executable starts the SQL Server Service if it is not running already and runs several checks.
When you are asked to apply the new collation to all databases conrm with Yes.
When the conversion has nished it stops the SQL Server Service.
4. To verify whether the MS SQL Server is properly congured, run:
select serverproperty('collation')
. Caution
You have to run INSTCOLL.EXE only once to apply the new collation. To convert a single SAP database
to the new collation, see SAP Note 600027
**********************************************************************
Cheers !!
Satya.
PS: Points always encourage me to reply...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.