Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 use...
General Comment
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.