- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: HP SIM Installation - SQL Problem
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
тАО06-27-2006 08:50 PM
тАО06-27-2006 08:50 PM
HP SIM Installation - SQL Problem
I've got as far as the database configuration page but everytime i try to connect to a SQL2000 database I've setup on a remote server I get an "insufficient permissions" error message. The account is dbowner on the database and member of the System Administrators server role.
running sql trace I can see that the account can login and is trying to run:
IF PERMISSIONS()&1=1 SELECT 1 ELSE SELECT 0
I'm not a sql expert (running a trace is about my limit) so I was wondering if someone could tell me what specific permissions the install requires in order to get it to work?
Thanks
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2006 02:15 AM
тАО07-06-2006 02:15 AM
Re: HP SIM Installation - SQL Problem
Maybe the SIM installation create its own database?
Maybe you have now a solution for this problem?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2006 08:58 AM
тАО09-19-2006 08:58 AM
Re: HP SIM Installation - SQL Problem
Thanks, Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2006 06:06 PM
тАО09-19-2006 06:06 PM
Re: HP SIM Installation - SQL Problem
A while back I had exactly the same problem when setting up my HP SIM 5 SP5 Server to run on SQL Server.
As it turns out if you accept all default database settings the installation process will NOT use master DB, it will create new DB with following name "Insight_v50_0_xxxxxxxxx" where x is a timestamp when the database was created.
As for the account used I alwasy specify same account that the HP SIM is using to start up all services. That account is also used to communicate with all clients reporting to HP SIM so I would suggest that account to be Domain Account with Administrator privileges on all member servers.
Cheers
VJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2006 06:07 PM
тАО09-19-2006 06:07 PM
Re: HP SIM Installation - SQL Problem
After the installation HP SIM uses his own DB an it own username/password.
I think the installtion need to know the master DB an SA Account to install HP SIM automaticly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-21-2006 09:26 PM
тАО09-21-2006 09:26 PM
Re: HP SIM Installation - SQL Problem
Is your SQL Server in mixed mode or SQL Authentication only? If SQL Authentication only then only SA or other acounts set up will work, if in mixed mode you can specify what account to log in with.
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-16-2009 05:16 PM
тАО02-16-2009 05:16 PM
Re: HP SIM Installation - SQL Problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-16-2009 08:23 PM
тАО02-16-2009 08:23 PM
Re: HP SIM Installation - SQL Problem
ftp://ftp.compaq.com/pub/products/servers/management/hpsim/hpsim_52_migratingNewSystem.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-16-2011 07:06 PM
тАО02-16-2011 07:06 PM