I have now fixed this issue and thought I'd just list what was wrong :
The VIA message was because in desperation to connect I had enabled some VIA connections - I think client side.
I disabled all connection types for both client and server except shared memory and TCP/IP.
Still didn't work - and gave a message that the server refused connection.
I then looked at the server side TCP options and found the port number, using SQLCMD tcp:servername,portnumber I could now connect !!
Finally changed the client side TCP to use this port number and now can connect with SQLCMD and no options.
My main gripe is why didn't it all work as installed and why did I have to go through all this to get it to connect !!!
Partager