Problem with direct connect to a sql server

[Anonymous]

 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.

[amitchandak]

@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]

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.