topic Re: SIM on a remote SQL 2017 server in Server Management - Systems Insight Manager

SIM on a remote SQL 2017 server

Andrew_Haak — Thu, 09 Sep 2021 03:24:03 GMT

Hello,

For the moment there is a need for an other SIM 7.6 server. I want to do a clean install on a WIndows 2016 server using a remote 2017 SQl server. This is not supported, there is a hotfix that fixes this but i can only install a hoxfix on a working SIM installation (right?) I do have the lastest hotfix but the installer complaints about the non supported SQL version. Do i first have to do al local install using de local install, run the hotfix and send the SQL admin the database ? Or is there an other way to do this ?

Re: SIM on a remote SQL 2017 server

Ihaqueit — Thu, 26 Aug 2021 17:23:19 GMT

Document - HP Systems Insight Manager 7.6 Installation and Configuration Guide for Microsoft Windows | HPE Support

Checkout this, pg no 44

Re: SIM on a remote SQL 2017 server

Andrew_Haak — Mon, 30 Aug 2021 13:08:23 GMT

hello again,

I know what port's i need to open, the question is that if in run the DVD installer for SIM (used the INsight Control ISO Insight_Management_7.6_DVD_1_ZIP_December_2016_C6N31-11012) i mentioned in the pre check (Insight Management Advisor) that the SQL 2016 database is not supported, is that why if i continue the SIM install failed and on the SQL side is see a Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library error. The installer does not support the SQL but let's me continue. I can only install the hotfix for SQL 2019 support (does this also mean i can use a SQL 2017 server?) after a finished install of SIM.