- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: HP SIM installation - Remote SQL database perm...
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
тАО11-08-2006 07:15 PM
тАО11-08-2006 07:15 PM
I am currently trying to install HP SIM 5.0 SP5 and are looking for some more information about how to do the installation with a remote SQL database.
So these are the steps I have done:
1. Manually created a database on the remote SQL server (named it HPSIM)
2. On the Database configuration page, I specified the name of the database server in the Host field
When I click next, the installation will check the database. I receive the following error: "Insufficient rights to database"
The user I specified under Database configuration is a domain admin account. I have also given this accound dbo rights to the HPSIM database.
The installation procedure regarding database is not very detailed as far as I can see, and I haven't found any information about how to do this.
Does anyone have some documentation describing this part of the installation in more details?
Instead of using this domain adin account for the installation, should I create a new user account/service account and use that one for the installation and what permissions should that user have on the SQL server and on the SQL database?
Some help is appreciated.
Thanks.
/ThomasO
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-09-2006 07:57 PM
тАО11-09-2006 07:57 PM
Re: HP SIM installation - Remote SQL database permissions
instead of using Windows authentication, did you try to use SQL authentication ? The SQL server has to be installed in "mixed" mode.
Ondra
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2006 03:09 PM
тАО11-12-2006 03:09 PM
Re: HP SIM installation - Remote SQL database permissions
The SQL server is installed in mixed mode.
However, during SIM installation, how/where can I specify to use SQL authentication (suring the installation).
I only have an option to specify username, password and domain.
Or do you mean that I should select SA as DB_OWNER on the database I created for this?
Thanks.
/ThomasO
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2006 08:09 PM
тАО11-12-2006 08:09 PM
Re: HP SIM installation - Remote SQL database permissions
please sorry my mistake, you cannot use SQL authentication for SIM5 installation.
Try to use a credentials of local administrator of the DB server (or any admin user you create). Type the host name of the DB server in the domain field in the database configuration screen.
Only docs I've found are:
http://h18013.www1.hp.com/products/servers/management/hpsim/infolibrary.html
I hope it helps,
Ondra
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2006 03:24 PM
тАО11-13-2006 03:24 PM
Re: HP SIM installation - Remote SQL database permissions
I have created the database manually and the user account I specify during the installation process is member of Domain Admins group and is also the owner of the database.
However, I still get the error "Insufficient rights to database" when trying to install SIM.
Anybody else seen this problem before?
Some help is highly appreciated.
Thanks.
/ThomasO
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2006 07:58 PM
тАО11-13-2006 07:58 PM
Re: HP SIM installation - Remote SQL database permissions
I've been supporting IM/SIM for some time and learned that in terms of the error messages the install is very inventive. Often it doesn't relate to the root cause at all.
I don't know where the core of your issue may lay. Sorry for my laical comments.
What I'd point you to have a look is:
- try to drop the database you've created and let's try if SIM install creates the database for you. At least, the 418812-001 doc doesn't talk about creating the DB manually.
- default SQL collation sequence
- installation using LOCAL user/pwd same as LOCAL admin user/pwd on the SQL box (I know you're using domain admin but this is worth trying if you're facing some authentication problems, may be DC related)
- disable firewall, if any, to ensure nothing is blocking port TCP/1433 or UDP/1434
- verify MDAC installation
- try to install to a different SQL test server you may have
What SQL version and OS on the SQL box are you using ?
Cheers,
Ondra
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2006 03:20 PM
тАО11-14-2006 03:20 PM
Re: HP SIM installation - Remote SQL database permissions
Thank you very much for your help with this. I really appreciate it.
So this is what I have done now.
- I deleted the database
- I logged on to the front-end server (Where HP SIM will be installed) with local Administrator account. This account is SQL System Administrators (Server Roles) and DBO for all databases
- See attached for information of login information
- I got the following error: "Unable to connect to the specified database. Please check the Host, Database and Port value provided"
- I created the database manually on the SQL-01 server and then I got the following error during installation: "Insufficient rights to database"
- There are no firewall on any of those servers
- MDAC version on both SIM server and SQL server is 2.8SP2
- The SQL server is running in mixed authentication mode
- Both servers are Windows 2003 Server SP1
- SQL server is SQL 2000 SP3 (8.00.760)
Any more tips on what I am doing wrong?
Thanks.
/Thomas O
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2006 07:04 AM
тАО11-15-2006 07:04 AM
SolutionIMO very dumb on HP to have the installation work this way so hopefully they will correct this in the next release.
Jason
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2006 07:55 PM
тАО11-15-2006 07:55 PM
Re: HP SIM installation - Remote SQL database permissions
Yesterday I had the exact same issue as you. Tried to google it but I only found your post with no answer to it.
Anyway, try this.
username: your domain admin account
password: pw for you admin
domain: your domain
host: the machine running your remote SQL DB
Under instance name/use this one: leave it blank
Database: master
port: whatever port you are using, default 1433.
Now I found out that the installation creates its own database on your sql. youll see it after the installation is done. so you can not specify an already created DB in SQL. And the installation will not put anything into the master DB even though you specify it above.
hope it helps.
/Zeb
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2006 05:41 PM
тАО11-16-2006 05:41 PM
Re: HP SIM installation - Remote SQL database permissions
Thank you very much for your suggestions. I finally found another posting about this as well with the same solution. See: http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1038544&admit=-682735245+1163573004849+28353475
I followed your tips and the installation was sucessful.
Thanks again for very good help.
You saved my day.
/ThomasO