Author Topic: Remote MSSQL 2017 Database (Windows) for CMOD 10.5 (RHEL 7.7) - on Azure Cloud  (Read 1326 times)

mroutlander

  • Jr. Member
  • **
  • Posts: 33
    • View Profile
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
« Last Edit: July 27, 2020, 07:08:35 AM by mroutlander »

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
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.

IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

mroutlander

  • Jr. Member
  • **
  • Posts: 33
    • View Profile
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.