Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm getting this error message when I try to add a sql server db as a new data source. I can use the same credentials to login to the sql dbs via other methods. Can't find anything online about what might be going wrong. Cleared credentials from the options menu which I saw another post about but no luck at all. Please help.
Hi, @JoshM3212
Some common reasons why you encounter errors when adding a SQL Server database as a new data source include incorrect configuration settings, network connectivity issues, or issues with the SQL Server instance itself. Make sure that your database name and server name are correct.
And make sure you're using the right way to authenticate. If you are using Windows authentication, but the database configuration only accepts SQL Server authentication, you will not be able to authenticate.
Make sure that the account you're using has sufficient permissions to access the specified database.
You may need to try to resolve the issue by checking the configuration settings for the data source, making sure you have a stable network connection, and verifying that the SQL Server instance is functioning properly. Check if there are any firewalls blocking the connection to SQL Server.
Or you can clear all your permissions and turn Power BI Desktop off and then reopen it to connect to SQL Server again
The following links may be helpful to you:
Troubleshoot connectivity issues in SQL Server - SQL Server | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but none of this helped. I tried many different ways of authenticating, all failed. Wound up talking to someone from MS who got me to a point where it said it was a db SSL issue. Waiting for help from my DBAs. Don't really understand this solution but that's what they said.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
106 | |
93 | |
69 |
User | Count |
---|---|
167 | |
132 | |
130 | |
96 | |
91 |