Skip to Content
author's profile photo Former Member
Former Member

SQL_Latin1_General_CP850_BIN Problem


I trying to install the SAP Enterprise Portal 6.0 SP4 NetWeaver Stack 2 Developer Workplace Sneak Preview, and I'm getting a fatal error on the AS install.

I adjusted my SQL Server 2000 (Personal Edition) database as required in the sql.htm file: (changed code page, SP3 installed, HotFix installed, collation installed) but install fails with the message:

Errors checking server:

Error by Collation check: Wrong server collation; J2EE requires SQL_Latin1_General_CP850_BIN2 collation.

If I check my SQL Server, it's collation is SQL_Latin1_General_CP850_BIN - and there doesn't seem to be a way to change it otherwise - and I did run the instcoll utility which was supposed to install the collation...

Many thanks,

Ed Bryant

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2004 at 06:14 AM

    Let me answer my own questions, for the benefit of others. When you run instcoll.exe, from windows explorer, it pops a DOS window, runs, and exits, so you think all is well. It wasn't.

    When I ran it from a dos window I saw the error (database created after system upgrade). Removed the new database, re-ran instcoll, and all appears well.

    The default collation sequence of the database is correct. Installation is proceeding.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.