Forum Discussion

saabbir's avatar
saabbir
Frequent Visitor
5 years ago
Solved

HTTPS PowerBI Report Server to HTTP SQL Server data source - error 401

I have just experienced a bizarre problem today. My PowerBI report server (on prem) was previously on a self cert SSL before. I have reports that runs on Imported mode from a remote SQL Server which ...
basic authentication
datasource error
HTP 401
HTTPS
PowerBI Report Server
Remote SQL Server without encryption
  • saabbir's avatar
    saabbir
    5 years ago

    Hi all,

     

    Thanks for your support and time. I have now setup another VM with exactly the same config, except the SQL server is TLS enabled. I deliberately left "Force Encryption = False". Everything is working like a charm.

    I have tested the following scenarios:

     

    1. Non-encrypted SQL + HTTP RS = Works
    2. Non-encrypted SQL + HTTPS RS = Doesn't work
    3. Encrypted SQL + HTTP RS = Didn't test
    4. Encrypted SQL + HTTPS RS = Works

     

    Few things to remember: Don't forget to add the SPNs, using FQDN is important and make sure user has at least datareader permission on SQL DBs.

     

    Hope this helps.

     

    Environment: Windows Server 2019 Enterprise, SQL Server 2017 Enterprise Core, PowerBI Report Server May 2021.

     

    Thanks

    Sabbir