Power BI Access to SQL Failing on Windows 11 via Service Accounts

[vhmp_23]

My service accounts does connect since my computer has been updated to Windows 11. I cannot connect via Power BI (Says credentials can not be authenticated) and I cannot connect via Microsoft SQL Server Management Studio (Says "Logon Failure: the user has not been granted the requested logon type at this computer"). I had zero issues ussing same credentials on windows 10 to connect

[Anonymous]

Hi @vhmp_23 ,

Ensure that the account is a work or school account, as personal Microsoft accounts may experience login problems with Power BI Desktop. Running Power BI Desktop with elevated privileges may resolve connection issues, you can try running Power BI Desktop as Administrator.

Error messages in SSMS usually indicate problems with user rights assignments or group policy settings. Please check the user rights assignments to ensure that the account in question has the "Allow log on locally" and "Login as batch job" permissions.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.