on 09-07-2010 8:25 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will not need re-installation.
Check out the following microsoft guide for changing your collation settings:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.