- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: Liking HPSIM 5.2 to SQL troubles
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
тАО03-17-2008 07:18 AM
тАО03-17-2008 07:18 AM
Liking HPSIM 5.2 to SQL troubles
I've double-checked the permissions on the SQL server and BUILTIN/Administrators has the System Administrators role, and the account in question is part of domain admins which are in turn part of the builtin administrators group.
What are the next steps I should take? Is there any additional log information I can check to see why this process thinks the account does not have the necessary permissions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:38 AM
тАО03-17-2008 08:38 AM
Re: Liking HPSIM 5.2 to SQL troubles
I think one is used to actually install the product, and hence needs system admin rights to SQL. The other account is what the HP services will run under to "run SIM" and talk to the databases, and I believe the installer "gives" this account the correct permissions in SQL to the database and such.
These two accounts might be one in the same - I guess that is up to you.
So when you are getting this error, for which of the above two accounts are you getting it for?
Nelson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:49 AM
тАО03-17-2008 08:49 AM
Re: Liking HPSIM 5.2 to SQL troubles
I have verified the account has administrator permissions on both machines.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:52 AM
тАО03-17-2008 08:52 AM
Re: Liking HPSIM 5.2 to SQL troubles
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 09:05 AM
тАО03-17-2008 09:05 AM
Re: Liking HPSIM 5.2 to SQL troubles
Nelson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 11:55 PM
тАО03-17-2008 11:55 PM
Re: Liking HPSIM 5.2 to SQL troubles
Username: A domain admin account
Password: Account's password
Domain: The Windows 2000 domain shorthand
Host: Name of MS SQL 2000 server
Instance name: Blank, using default instance
Port: Verified as 1433.
Error Title: Install Shell
Error description: The specified database account credentials are invalid.
As stated though, using the SQL Server Management Studio from SQL 2005 I can connect to the SQL 2000 instance using the specified account and create and delete a database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 12:17 AM
тАО03-18-2008 12:17 AM
Re: Liking HPSIM 5.2 to SQL troubles
Neither the SQL logs, nor the Windows security logs, hold any information regarding this authentication failure, or even the connection attempt.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 08:26 AM
тАО03-18-2008 08:26 AM
Re: Liking HPSIM 5.2 to SQL troubles
I personally have SQL 2000 installed on the same box as SIM, but that should not matter.
Nelson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 08:28 AM
тАО03-18-2008 08:28 AM
Re: Liking HPSIM 5.2 to SQL troubles
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 08:43 AM
тАО03-18-2008 08:43 AM
Re: Liking HPSIM 5.2 to SQL troubles
I guess call HP and see what they have to say.
Nelson