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
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.