Reply to Message

View discussion in a popup

Replying to:
cdubz
Enthusiast
Enthusiast

have you tried using the fqdn of the database server, cluster name, or always on listener (if the database is cluster)?

also the jdbc command should read something like this:

jdbc:sqlserver://<hostname-or-DB_VM_IP_ADDR>;DatabaseName=saas



So try jdbc:sqlserver://yoursqlserverfqdn;DatabaseName=saas and leave out the actual port number (1433 is default for SQL anyways (since your named instance isnt the default you may have to add it in like you did originally behind the fqdn)).

One last note, i had issues with 2.7.1 IDM deploying to any sort of external SQL database. I tried a basic standalone sql 2012 box and a always on cluster sql 2012 and they both always errored out 2.7 install whether it be a fresh install or an upgrade.  2.7 worked fine on the same SQL instances.  2.8 also seems to work fine as well (im using sql 2012 always on cluster)

Reply
0 Kudos