- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: Unable to Connect to Database - HPSIM 7.1
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2013 10:55 AM
тАО01-03-2013 10:55 AM
Unable to Connect to Database - HPSIM 7.1
Several weeks ago, I installed HP Systems Insight Management. My setup included a SIM Management Server, with a SQL shared with several other apps. After being out of the office for several weeks, I tried to pick up where I left off, only to be met with an error screen when I try to log into HP Systems Insight Manager. The error message pops up in a box called:
"HP Systems Insight Manager Check Service"
"Unable to Connect to Database. Check if database service is running."
I have checked communication with the SQL server. I've verified that the services on the HPSIM server are started. Verified that there are no issues with the SQL Server itself. I've rebooted the HPSIM server, however, cannot of course reboot the SQL box.....any suggestions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2013 11:01 AM
тАО01-03-2013 11:01 AM
Re: Unable to Connect to Database - HPSIM 7.1
Hope the service is running on 1433 and username and passwd are set correctly.
Use CLI - mxgetdbinfo
check for the logs inside <HPSIM_Install>\logs\mxdomain*.0.log
\T Bajpai
HP Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2013 11:04 AM
тАО01-03-2013 11:04 AM
Re: Unable to Connect to Database - HPSIM 7.1
I should have also included that Insight Management had worked fine for several days. I was beginning to bring my server environment into the system, etc........
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2013 11:18 AM
тАО01-03-2013 11:18 AM
Re: Unable to Connect to Database - HPSIM 7.1
Database initialization failed for URL: jdbc:jtds:sqlserver://SQL04.OURDOMAIN.COM:1433/Insight_v50_0_121726231;loginTimeout=20;domain=OURDOMAIN;instance= Ex: java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
I see this error is all of the logs that mentioned.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2013 12:16 PM
тАО01-03-2013 12:16 PM
Re: Unable to Connect to Database - HPSIM 7.1
Hope the DB is not remote, make a entry for domain into "Host" file for SQL04.OURDOMAIN.COM
C:\Windows\System32\drivers\etc\hosts
entry :
<IP OF System> SQL04.OURDOMAIN.COM
i.e
127.0.0.1 localhost
16.x.x.x SQL04.OURDOMAIN.COM
\T Bajpai
HP Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2013 05:26 AM
тАО01-22-2013 05:26 AM
Re: Unable to Connect to Database - HPSIM 7.1
Hello! This thread seems to be the answer to my problem, but I have one question. Are we to enter the exact string "sql04.ourdomain.com" or is it sql04.<domain>.com?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2013 09:01 AM
тАО01-22-2013 09:01 AM
Re: Unable to Connect to Database - HPSIM 7.1
it is FQDN of the server mapped to the IP address
\T Bajpai
HP Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2013 12:39 PM
тАО04-30-2013 12:39 PM
Re: Unable to Connect to Database - HPSIM 7.1
I have a very similar problem as the one discussed on this thread. I have HP SIM server running on a Virtual Windows 2008 R2 server, and I have installed SIM and its database locally (MSSQLSERVER that comes with HPSIM 7.1). Originally, I installed HP SIM using my AD account. but then I created a service account for HPSIM, and I was able to run HP Systems Insight Manager service for several weeks (I gave the HP SIM accounts all rights and used it to run this service).
Everything worked fine fore several weeks, until I changed my AD account password (which was going to expire in 1 week). About one hour after the password change, HP SIM stopped working. All services are running with exception of SQL Server Agent service, which is a dependent service for SQL Server service. Can you please advise on troubleshooting? Currently, SQL Server Service runns under the HPSIM service account, and SQL Server Agent runs under Network Service account.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2013 07:10 AM
тАО05-22-2013 07:10 AM
Re: Unable to Connect to Database - HPSIM 7.1
I had a similar issue and found the fix:
if you have already verified that the database is fine and reachable the next is to check the configuration files in the folder Program Files\HP\Systems Insight Manager\config:
database.admin
database.props
databaseadminupd.tpl
databaseupdate.tpl
Update the user ID/server name as per your configuration.
if you change the user ID you would need to update the password as well for whcih you would have to go to the folder
Program Files\HP\Systems Insight Manager\bin
using command prompt and execute mxpassword.exe -g
this will provide a graphical interface using which the passord for the user specified in the configuration files can be updated.
I hope I have been able to help.... :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2013 09:04 AM
тАО12-19-2013 09:04 AM
Re: Unable to Connect to Database - HPSIM 7.1
-JGH