topic Re: SIM 5 SQL init error in Server Management - Systems Insight Manager

SIM 5 SQL init error

Ondra Ernyei — Tue, 22 Nov 2005 10:11:42 GMT

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

Re: SIM 5 SQL init error

Ondra Ernyei — Tue, 22 Nov 2005 11:02:58 GMT

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

Re: SIM 5 SQL init error

Joel Rubenstein — Tue, 22 Nov 2005 13:31:53 GMT

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?

Re: SIM 5 SQL init error

Ondra Ernyei — Wed, 23 Nov 2005 09:30:36 GMT

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

Re: SIM 5 SQL init error

Ondra Ernyei — Wed, 23 Nov 2005 09:31:49 GMT

SQL collator problem.