Forum Discussion

sstar118's avatar
sstar118
New Member
9 years ago
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 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?

  • Anonymous's avatar
    Anonymous
    9 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