Gateway Connection - basic authentication

Hi hughv99 
In addition reply to GilbertQ please cross verify the blow steps:

Check SQL Server User Permissions.

Confirm that the user jjone has the necessary "db_owner" or at least "db_datareader" permissions on the SQL database.

Run the following query on SQL Server to verify permissions:

***************************************************************
SELECT dp.name AS UserName,
dp.type_desc AS UserType,
p.permission_name,
p.state_desc
FROM sys.database_principals dp
JOIN sys.database_permissions p
ON dp.principal_id = p.grantee_principal_id
WHERE dp.name = 'jjone';

***************************************************************

Check the On-Premises Data Gateway Configuration:

• Make sure the gateway is properly installed and running.
• Open the On-Premises Data Gateway app, go to Service Settings, and verify:
  • The gateway is running.You are using the correct region in Power BI Service.
  • The account used to run the gateway has the correct permissions to access SQL Server.

If none of these steps resolve the issue, try using "SQL Profiler" to capture login attempts and analyze what credentials are being passed to the SQL Server.

If the above information helps you, please give us a Kudos and marked the reply a Accept as Solution.

Thanks,
Cheri Srikanth