Microsoft – SQL Server – SQLCmd – Error – Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly.

Trying to connect to a MS SQL Server Instance using sqlcmd.exe and got the error message below:

Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly.

Of course, Googled and discovered that it is probably a Windows Path issue (manifested by the system picking up a wrong \ mismatched dll).

Errors such as this is common in cases where multiple SQL Server Binaries are loaded on the system.

As a work-around:

  1. Review and correct your path
  2. Transverse to the folder that contains the version of the sqlcmd that you want and run sqlcmd from that folder

To fix:

  1. Un-installed previous Microsoft SQL Server Client

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s