Forum Discussion
Solved
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 th...
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
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
- Hi,Yes I have SQL Server management studio installed and am able to access the server and database through that. Just am unable to establish a connection with power bi. As I mentioned I do not get any error it just keeps trying to connect but never does.Thanks
