topic Re: SQL Server Connection - Host name in Workato Pros Discussion Board

SQL Server Connection - Host name

rcloud — Thu, 11 Mar 2021 06:13:34 GMT

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...

Re: SQL Server Connection - Host name

cwarren — Thu, 11 Mar 2021 06:24:18 GMT

If it's anything like our setup, the host is probably going to be a public IP address.

Re: SQL Server Connection - Host name

rcloud — Thu, 11 Mar 2021 06:36:40 GMT

Thanks Chris. Due to all the seperation of duties these days, I would get that from the DBA? or From someone in Networking?

Re: SQL Server Connection - Host name

cwarren — Thu, 11 Mar 2021 06:38:02 GMT

I had our network guys do it, so I think that’s your best bet.

Get Outlook for iOS

Re: SQL Server Connection - Host name

cwarren — Thu, 11 Mar 2021 06:38:34 GMT

We also had to whitelist Workato’s IPs in our firewall to get it working.

Get Outlook for iOS

Re: SQL Server Connection - Host name

rcloud — Thu, 11 Mar 2021 07:02:32 GMT

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...)

Re: SQL Server Connection - Host name

rcloud — Thu, 11 Mar 2021 07:04:41 GMT

Also, did you have them download and install the on-prem agent service?

Re: SQL Server Connection - Host name

atsuya-yamakawa — Sat, 13 Mar 2021 22:37:26 GMT

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

Re: SQL Server Connection - Host name

rcloud — Tue, 16 Mar 2021 23:13:03 GMT

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.

Re: SQL Server Connection - Host name

mreddytamma — Sun, 10 Nov 2024 06:53:03 GMT

Hi Team,
I'm trying to explore the Working with Databases in this videos SQL server connection creation process is there. But will workato provides some free sample SQL Server details to practice the activities here?