I am trying to register data store(PostgreSQL) where publisher's connection info is different from server connection.
When I import server connection sde file to "Add data store" tool after unchecking "Same as publisher datastore connection", it errors with a message "Unable to connect using the provided connection properties".
I have two connection files because I cannot connect to the db using server connection file via Pro.
If Pro is trying to validate the connection it won't work.
How can I work around this?
FYI, I tried Server Manager and it failed too.
Thanks for your help.