5

On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find it anywhere. Is there a way how to install it separately?

Unfortunately I am not local admin of the machine, so I prefer no MSI...

Found this link https://www.microsoft.com/en-us/download/confirmation.aspx?id=36433, but cannot use MSI... Perhaps copying executable files and dlls can do the trick.

After copying files SQLCMD.EXE, BATCHPARSER.DLL and SQLCMD.RLL from C:\Program Files\Microsoft SQL Server\110\Tools\Binn from another computer with SSMS installed I still get the error:

Microsoft SQL Server Native Client 11.0 : Data source name not found and no default driver specified.

running sqlcmd -S np:\\.\pipe\LOCALDB#F8040C8F\tsql\query.

5

I have figured out that during SQL Server LocalDB MSI installation the ODBC driver is not installed

So to use SQLCMD it is necessary to install Microsoft® ODBC Driver 11 for SQL Server® - it is a part of ODBC driver as per here.

When I tried to install Microsoft® Command Line Utilities 11 for SQL Server® it prompted me to install the ODBC Driver first.

Then it is possible either to copy the files SQLCMD.EXE, BATCHPARSER.DLL and SQLCMD.RLL or to install Microsoft® Command Line Utilities 11 for SQL Server®.

0

Are you installing SQL Server 2014 on a Windows installation with no previous version of SQL Server in?

Have a look at C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn

  • Does this suggestion apply to a LocalDB installation as well? – Andriy M May 25 '16 at 5:39
  • @AndriyM I do not find this answer useful because the problem is not locating SQLCMD.EXE file but installing ODBC driver which requires local admin rights. – Vojtěch Dohnal May 25 '16 at 6:11

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.