sql server failed to connect with sql cmd?

Question

Post reply

sql server failed to connect with sql cmd?

sumith1andonly1

SSCrazy

Points: 2250
More actions
December 6, 2012 at 3:16 am

#271571

C:\Windows\system32>sqlcmd -S AI-101
GOt error :
Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly.
?????/

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

In the list of software programs in the control panel, do you see "Microsoft SQL Server 2008 Native Client"?

If no, you need to install it using the SQL Server set-up.

If yes, try to do a repair.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sumith1andonly1 SSCrazy Points: 2250 More actions · Answer 2

hi

i using sql server r2 and the corresponding native client also installed

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Did you try to repair it?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

KoldCoffee SSCoach Points: 18971 More actions · Answer 4

Koen,

I encountered this error today and read this post. I have Microsoft SQL Server 2012 Native Client installed, but when I try to run repair from Control Panel, I get a Windows Installer dialogue box with error and instructions:

"The feature you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path to a folder containing the installation package 'sqlncli.msi' in the box below".

Where should I find this 'sqlncli.msi' ?

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

Do you have the installation media of SQL Server somewhere?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

KoldCoffee SSCoach Points: 18971 More actions · Answer 6

KoldCoffee

SSCoach

Points: 18971

May 20, 2014 at 1:12 pm

#1715095

yes

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

KoldCoffee (5/20/2014)
yes

What if you launch the set-up yourself and choose the repair option?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

KoldCoffee SSCoach Points: 18971 More actions · Answer 8

Reason I need this file is because I want to use SQLCMD to execute script.sql script that I have for creating a database with schema & data. I'm following Dave Pinal's instructions.

http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

When I try to run this command from cmd prompt I get error:

"SQL Native Client is not installed correctly"

I ran repair for my SQL Server 2012 installation and got passing results for every repair in the tool's checklist with exception of this error which I acknowledged and moved the repair to completion.

"There was an error executing Replication upgrade scripts."

I have SQL Native Client in my list of programs. Any other avenues to explore, that you can think of?