Insight Manager 7.6 Remote SQL Setup Questions

[Unlisted]

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

[n0kia]

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.