Issues Connecting SQL Server Database to Gateway for Refresh

Hi RyanFiting,

I understand you're experiencing an issue with connecting one of your SQL Server databases to the On-Premises Data Gateway for refresh in Power BI.

When I referred to "restarting the gateway," I meant stopping and starting the On-Premises Data Gateway service, not uninstalling and reinstalling it. 

• Via the On-Premises Data Gateway Application: 
• Launch the On-Premises Data Gateway application on the server. 
• Go to the Service Settings tab. 
• Select Restart. 

For detailed instructions, you can refer to Microsoft’s official documentation: 

Restart an on-premises data gateway | Microsoft Learn 

1. Please open SQL Server Management Studio (SSMS) and examine the SQL Server error logs (ERRORLOG). Check for any failed login attempts related to the problematic database. If the account is blocked or expired, re-enable it. 
2. Log into the problematic database via SSMS using the exact credentials configured in the gateway. If the login fails, ensure that the account has the necessary permissions (db_datareader or higher) on the specific database. 
3. Ensuring there are no network or firewall restrictions obstructing the connection. 
4. Please review the gateway logs for further error details. You can access these logs through the gateway installation directory or the gateway application. 

Please go through the below link for additional information:   

Troubleshoot the on-premises data gateway | Microsoft Learn 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.  

Thankyou.