SIM 5 SQL init error

[Ondra Ernyei]

Hello,

I'm getting error while initializing database during SIM 5.00.00.02 install.
"Error:Database initialization failed"

I'm running Windows 2000 Server SP4, MS SQL 2000 SP4 - local instance.
SQL server collation is SQL_Latin1_General_CP1250_CS_AS.

The database is created, contains user tables, but the install process cannot run some scripts. Please have a look to the install log attached (C:\Program Files\HP\Systems Insight Manager\logs\initconfig.log).

I will appreciate any info leading to the issue resolution !

Regards,

Ondra

[Ondra Ernyei]

Btw. I was trying to play with the Regional Settings, System locale, no impact. I changed from Czech to English.

I hope the problem is not caused by the SQL collation, because it is something I cannot change on this box.

Have anyone seen SQL collation prerequisities in SIM manuals ?

Ondra

[Joel Rubenstein]

Yes I am afraid the problem is caused by the SQL collation sequence. Can you create another database instance with the default collation sequence to install SIM into?

[Ondra Ernyei]

Thanks Joel for your response. You were right, when pointing the install to a different SQL server using Czech_CS_AS collator the setup did finished without problems.

Regards,

Ondra

[Ondra Ernyei]

SQL collator problem.