SAP central system installation, required MS SQL collation

[Former Member]

How do you set correct MS SQL server collation

for the SAP system

Central system : Netweaver EHP1 R1( Java only )

OS=Windows server 2008 R2

DB= Ms sql server 2008

Edited by: Franklin Jayasim on Sep 7, 2010 9:37 PM

[Former Member · Accepted solution]

Hey,

You do not need to worry about setting up Collation settings. We recently installed CI with MS SQL SERVER 2005.

If you have downloaded the required RDBMS dvd media then you will find two scripts inside your media:

sql4sap.vbs & sqlauth.vbs script.

-You can install sql server by executing SQL4SAP.VBS script. It will ask you for the instance name and it will install the correct collation setting required. There is also no need to install service pack independently. It installs Service packs too. (However, installation guide in marketplace has mentioned the collation that is required).

-sqlauth.vbs will be required to be executed if you want to change the default windows authentication to windows and sql server authentication after the installation.

[Former Member · Accepted solution]

Hi,

I am installing on MS SQL2008

I ran the scripts you mentioned it says the SQL instance is uptodate no change is required.

[Former Member · Accepted solution]

Hi ,

The install stopped saying the SAP needs SQL_LATIN1_General_CP850_BIN2

but my server has SQL_LATIN1_General_CP1_CI_AS

any ideas other than reinstallation will be very helpful

[Former Member · Accepted solution]

You will not need re-installation.

Check out the following microsoft guide for changing your collation settings:

http://msdn.microsoft.com/en-us/library/ms179254.aspx

[thunder_feng]

Hi Franklin,

As of SQL Server 2005, only Collation BIN2 is supported. so you will have to use the collation for your SAP database to BIN2 ,

and you can find detailed steps in sap note 600027.

https://service.sap.com/sap/support/notes/62988

Best Regards,

Thunder