SIM 4.10 Install failed, "Cannot open database requested in login" in initconfig.log

[Holger Mundhahs]

Hello,
today I want to install SIM 4.10 on a Windows Server 2003. The installation fails, in initconfig.log are the folowing entries:
---------------------------------------------
...
6. Task Results Output Cleanup
- Successful
7. Database Configuration
Database initialization failed for URL: jdbc:odbc:Insight_v1_0 Ex: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'Insight_v1_0_12212212'. Login fails.
...repeat the last line 20 times
Creating database 'Insight_v1_0_12212212'...
Creating schema...
*** WARNING: FAILED the following SQL command:
====
CREATE index notice_st_dev_sv_index on notices(State, deviceKey, noticeseverity)
====
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'deviceKey' does not exist in the target table.
... and many more
---------------------------------------------
I can see the created database, and in the database are 178 tables.

Environment:
Windows Server 2003 Standard
MS SQL Server 2000 SP3a + Fix 919
MDAC 2.8 + last Security Fix
SUN JRE 1.42_03

I've tried 2 different users, both are local admins.

Is the anybody who can help me?

Regards
Holger

[Joel Rubenstein · Accepted solution]

Please check that you did not specify a non default collation sequence when you installed SQL 2000. If you specify "dictionary case sensitive" you will see errors like you have reported.

[Holger Mundhahs]

@Joel
Thanks for your help. I've re-installed the SQL Server with defaults and now I got only 10 lines with "Database initialization failed for URL...", then the initializaion works fine. Now I've another problem on the frontend system(JRE 1.42_04 installed, but will not recognized), but I'll first do some tests before I post a new entry.

Regards
Holger