I am using the version of sqlcmd that comes with the Microsoft ODBC Driver 11 for Sql Server to connect to a remote 2014 instance. I can create a DSN connection using the SQL Server Native Client 11.0 just fine. Port 1433 is open and I can ping, telnet and all that good stuff. Seems to be a driver compatibility issue as I get the same error when trying to create a System DSN with the ODBC driver. Any thoughts?

Where can I get a compatible version of sqlcmd? Is there something I am missing?

  • 4
    Post the exact error message. Did you try command line utility from microsoft.com/en-us/download/details.aspx?id=36433 .
    – Kin Shah
    Jan 22 '16 at 21:36
  • 1
    Also post exactly what you're typing when trying to connect, and show what instance names are on your machine in SQL Server Configuration Manager. (And stop using DSNs. They're from the 90s.) Jan 22 '16 at 21:40
  • @AaronBertrand I was just using DSNs as a way to test to see if the connection could be made using another method besides sqlcmd. I was typing sqlcmd -E -S ServerName -d master
    – db_brad
    Jan 22 '16 at 21:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.