cancel
Showing results for 
Search instead for 
Did you mean: 

SAP central system installation, required MS SQL collation

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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