Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem with direct connect to a sql server

 I am able to connect via the import option no problem.  However when trying to do the DirectQuery I can access the tables in the sql server, but when choosing them I get the attached message.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , if this is a local database, make sure you are using backslash

     

    localhost\sqlserver

     

    sometime

     

    localhost/sqlserver does not work for local databases

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      It is on a separate server and I have to connect using a VPN.  I am using the IP address in the Server part of the connection login.