Database Initialization Fails during install

[Jonathan Clark_2]

During the install of SIM. the step that saying Populating Database. It errors out with the following error: "Database Initialization failed"

I checked out the log and found this.

Connecting to database...
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1453/Insight_v50_0_184216296;domain=NAI;instance=INSIGHTMANAGER5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
HP Systems Insight Manager shutting down: com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

Please Assist.

[Jonathan Clark_2]

I found an article here: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336

which states about changing your MSDE connection to be Mixed Mode and gives a reg change.

I'm going to apply the change, uninstall, reboot, and try again. I'll let everyone know how it goes.

[Jonathan Clark_2]

Noppers. Changing to Mixed mode didn't work.. Please assist.

[Rob Buxton]

Were you doing this from a Domain or Local Account?

Is MSDE used for anything else?

I'd remove MSDE and HPSIM, login from a suitable Domain Admin Account and retry the installation. Let the HPSIM Install do the MSDE Installation.
That worked fine here on a test Server.

The errors seem to indicate it is some kind of access problem.

[Jonathan Clark_2]

um alright. How do I let the SIM do the MSDE install? I have other MSDE instances on this server that cannot be removed or replaced.

[Rob Buxton]

You might want to see the thread:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=948745

MSDE isn't the most flexible of database servers if you're trying to manage multiple databases.

[Jonathan Clark_2]

I thought that too so I decided to use my server that has SQL on it and create a database just for InsightManager. Low and behold I had the exact same issue. So its not isolated to MSDE or SQL.

[sam_193]

Have you created the database for hpsim manually or hpsim did during installation?

[Jonathan Clark_2]

tried both. neither worked.

[Jim Turner_6]

Jonathan Clark - NPS?

I'm seeing the same!

Have a clustered SQL 2000 Server (service pack 3)

I can successfully install SIM 4.2 fine (System DSN works).

SIM 5.0 fails on both a new install or an upgrade of a newly installed SIM 4.2.

Fails to initialize the database.

On a new install it creates the database tables but cannot populate them.

Here are some log exerts.

Error:Database initialization failed!

hpsim.log
[08-22-2005][17:33:27][Setup Shell]Startup
[08-22-2005][17:33:41][System Check]Startup
[08-22-2005][17:33:43][Install Shell]Startup
[08-22-2005][17:35:36][HP Systems Insight Manager]Startup.
[08-22-2005][17:35:36][HP Systems Insight Manager]
[08-22-2005][17:42:35][HP Systems Insight Manager]HP Systems Insight Manager installation completed.
Configuring Server Components (15):
1. Node Security File
- Updating
- Successful
2. Server Property File
- Updating
- Successful
3. Server Authentication Keys
- Updating
- Successful
4. SSH Keys
- Updating
- Successful
5. Status Property File
- Updating
- Successful
6. Task Results Output Cleanup
- Successful
7. Database Configuration
- Updating
- Successful
8. Database Content
- Updating
- Successful
9. Setup Property File
- Updating
- Successful
10. Web Server
- Updating
- Successful
11. Setup Property File
- Updating
- Successful
12. JBoss Setup
- Successful
13. Agent Configuration
- Failed
Details can be found in the log file at S:\Program Files\HP\SIM\logs\initconfig.log
Configuration failed to complete due to the following exception:
Access is denied
[08-22-2005][17:45:05][HP Systems Insight Manager]Error:Database initialization failed
[08-22-2005][17:45:05][HP Systems Insight Manager]Error:Database initialization failed
[08-22-2005][17:45:11][HP Systems Insight Manager]Shutdown.
[08-22-2005][17:45:37][Install Shell]Shutdown
[08-22-2005][17:46:30][Setup Shell]Shutdown

Jim Turner - FWS

[Jonathan Clark_2]

check out this thread. The last two-three post have the answer

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=950264

[Dan 304 Ameli]

The solution that worked for me on a Workstation running MSDE was to change the following registry entry: (set loginmode = 0)

HKLM/Software/Microsoft/MSSQLServer/MSSQLServer/loginmode = 0

This sets it to Windows Authentication Mode.

[Server-Support]

Hm.. can anyone share the SQL Server database initial setup to prepare before we setup the HP SIM 6.2 please ?