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 th...
Need Help
  • 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.

  • GilbertQ's avatar
    GilbertQ
    9 years ago
    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
sstar118's avatar
sstar118
New Member
9 years ago
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 
  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi sstar118

     

    When connecting do you use the FQDN or the Server name?

    • sstar118's avatar
      sstar118
      New Member
      9 years ago

      Hi GilbertQ

       

      I connect using the server name. I am not sure what the FQDN is.

      • sstar118's avatar
        sstar118
        New Member
        9 years ago

        Hi GilbertQ

         

        I let it connect for about 20 minutes and then got a message that it needed to be an encrypted connection, once I hit okay I was able to connect. Is there anyway to kick it off an an ecrypted connection so that it does not take so long to connect in the future.

         

        Thanks!