- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: Insight Manager 7.6 Remote SQL Setup Questions
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
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
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
07-27-2017 02:30 PM - last edited on 09-06-2017 04:12 PM by Warren_Admin
07-27-2017 02:30 PM - last edited on 09-06-2017 04:12 PM by Warren_Admin
Insight Manager 7.6 Remote SQL Setup Questions
Post originally by JDWEBER
Hello all
I am working on installing Insight Manager 7.6 using an Remote SQL Instance.
I have a couple of questions that I have not been able to find the answers to and was looking for a bit of help. Here is what I can tell you about our setup:
1. HP SIM - Server 2012 R2
2. SQL - Server 2012 R2 - SQL 2014
3. Logging in to SIM server as my self
4 . will use Domain Service account to make connection to SQL server during install.
5. SQL Server will be a shared SQL server
Questions, in no particular order:
1. I know that the service account requres "dbo" permissions to "Master". Does it need to keep that permission or can it be removed and given lower level permissions?
2. Does SIM require its own Instance of SQL or can SIM share the instance wtih other Databases? Our plan is to use this as a shared SQL server.
I may have more as time goes on.
Thanks in advace for any help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2017 04:14 PM
09-06-2017 04:14 PM
Re: Insight Manager 7.6 Remote SQL Setup Questions
1. I know that the service account requres "dbo" permissions to "Master". Does it need to keep that permission or can it be removed and given lower level permissions?
Once the database is created during install. you can lower it.
2. Does SIM require its own Instance of SQL or can SIM share the instance wtih other Databases? Our plan is to use this as a shared SQL server.
We recommend it's own instance but works while being in a share.