โ03-10-2021 10:13 PM
Does anyone have experience 'generating' the URL host name for an on-prem SQL Server instance?
I've downloaded/installed the service as well as the config/keys, but I don't understand how to get the Host name. In Workatos examples, it looks like they are using an AWS instance. Mine is on-prem in my company.
Thanks Pros...
โ03-10-2021 11:02 PM
Ah the old whitelist... I'll talk with networking about that... Thanks.
Btw, would it be possible for you show me a generic version of what the host name you're using in your connections, looks like? (no company names... no database names...)
โ03-10-2021 11:04 PM
Also, did you have them download and install the on-prem agent service?
โ03-13-2021 02:37 PM
Hi Rick Cloud , if you are willing to connect your SQL Server via on-prem agent (OPA), you would have to create a database profile inside the config.yml file. The OPA needs to be reachable to the SQL Server, that is to say they have to exist in the same network. Here's an example on how you can create a database profile.
https://docs.workato.com/on-prem/agents/profile.html#database-profile
database:
sales:
adapter: sqlserver
host: 192.168.0.100
port: 1433
database: sales
username: me
password: foobar
โ03-16-2021 04:13 PM
Atsuya, thanks for replying. I've read the doc at the link you provided, several times. Workato is still not able to connect. However, after some research using the local agent console, I believe this connection cannot work with SQLExpress.