Forum Discussion
Unable to connect to SQL Server
Hi,
I am using the Desktop version. I am unable to connect to a Microsoft SQL Server. I do not get any error message. It just keeps spinning and spinning and never connects. Sometimes I get to the the second screen where it says to use windows credentials but then that just keeps loading. I am able to connect to this SQL sever with Tableau and Qlik but am having trouble with Power BI.
Any suggestions?
- Anonymous9 years ago
On your login screen for database engine click on 'Options'
Then click on "connection properties" tab and uncheck "Encrypt connection".
Hope this helps.
- Hi there
I would discuss this with your DBA to see if they enable connections without it being encrypted.
And then from there when m you connect you can change the connection properties to not use encryption
8 Replies
- GilbertQSuper User
Hi sstar118
Can you confirm that you have got the correct drivers installed to connect to SQL Server for Power BI?
I stand to be corrected but I do recall having to install SQL Server Management Studio.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms