Remote MSSQL 2017 Database (Windows) for CMOD 10.5 (RHEL 7.7) - on Azure Cloud

[mroutlander]

Hi fellow techies,

I am trying to connect to an SQL Server 2017 [the chosen database for CMOD] installation on Windows Server 2016 from CMOD 10.5 [Library server] on Red Hat Enterprise Linux 7.7 box  (both on Azure cloud). Could you please help me understand:

1. If it is possible and has anyone implemented it?
2. What are the prerequisites at both ends?
3. Any kind of separate ODBC setup required on the the library server box?
4. Any other considerations?


I admit that a remote database isn't the ideal setup but we are doing it to enable MS Support (Azure, you see  :D ). IBM documentation doesn't give any clear answers including the mandatory prerequisites and configurations (ars.cfg, ars.dbfs etc.).

https://www.ibm.com/support/pages/creating-remote-microsoft-sql-server-database-ibm%C2%AE-content-manager-ondemand


Apologies if this looks like a noob question. Any help shall be really appreciated. Thanks

[Justin Derrick]

I don't think remote database configs are explicitly supported (which is why you're not seeing documentation for it), but more in the realm of 'tolerated'.

If you get it working, please share your experience & results.

-JD.

[mroutlander]

Thanks for responding, Justin. That was what we perceived as well. Anyway, we have raised a PMR with IBM and will wait for their assistance. Once we have a solution, I shall post the same here.