Gateways, error I can't connect to SQL SERVER database

[Syndicate_Admin]

I've taken a thousand turns and changed the gateway settings, and I always get error

I put the server address, database, database username and password but nothing at all.

The port check tells me they're right.

Any ideas?

I sent the capture

[Anonymous]

Hi @Syndicate_Admin ,

Are you able to connect the database via SSMS?

Here's the offical troubleshooting documents for your reference.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot 

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot 

Best Regards,

Jay

[amitchandak]

@Syndicate_Admin , Are you able to access the database using SQL Server Management Studio.

in not, ask Database admin to check port setting - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-...

[Syndicate_Admin]

Forgive the question but I would have to tell the IT department, that they would open port 10.6.... that gives access to the database server?