Forum Discussion
error estabilishing a connection to SQL Server
Hi everyone,
Could you please tell me why the error mesage means when I try to import a data from SQL database?
Many thanks,
Renata
Hi RenataOGardner ,
Please refer to the steps in https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15 to troubleshoot connection issue to sql server.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
2 Replies
RenataOGardner , Are you able to connect with the SQL server using Sql server management studio?
If not then check the connection details.
If yes. Check which credential you are using window or database?
make sure you use the same in power bi. When it ask credential, check on the left which one you are giving windows or DB.
You can provide credential again by using clear permission
Hi RenataOGardner ,
Please refer to the steps in https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15 to troubleshoot connection issue to sql server.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
