Forum Discussion
access denied error while connecting to SQL database
I am getting error, while connecting to SQL server via power BI.
files --> Get Data --> SQL server --> enter server name and data base name (optional) --> takes you to next screen which asks for user name and pwd for 3 different modes - windows, Database and Microsoft.
I tried all 3 of them, with my username and Pwd, but I get error - "Access Denied".
I do have access to the server. I tried connecting to backend data using SQL server management studio and I was able to connect. But when i use the same server in PowerBI, I get access denied error.
Kindly guide how to fix this error.
thanks!
@SQLServerConnctionError @accessdenied
Hi Anonymous ,
Here are some best fixes to troubleshoot:
1: Check Whether the SQL Server is running or not
2: SQL Server instance is not available or does not exist
3: Remote connection is not enabled for a SQL Server instance
4: Port is not added in the firewall exception list
5: IP address of the SQL Server Instance has blocked the Firewall
6: connect remote SQL Server using Server Name
7: Allow the instance name to measure the connection information
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , if you are able to connect to SQL server management studio on the same machine. Using the same credential you should be able login into power bi.
Just check if there is a setting at SQL server end too, this setting
V-lianl-msftCommunity Support
Hi Anonymous ,
Here are some best fixes to troubleshoot:
1: Check Whether the SQL Server is running or not
2: SQL Server instance is not available or does not exist
3: Remote connection is not enabled for a SQL Server instance
4: Port is not added in the firewall exception list
5: IP address of the SQL Server Instance has blocked the Firewall
6: connect remote SQL Server using Server Name
7: Allow the instance name to measure the connection information
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
