Execute sql script using sqlcmd.exe

Question

C:\>sqlcmd -S(local) -U(sa) -P(password) -i F:\sql.sql

HResult 0x3, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [3]. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in stance-specific error has occurred while establishing a connection to SQL Server . Server is not found or not accessible. Check if instance name is correct and i f SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

How I resolve this problem

stackoverflow.com/q/11472346/62576, stackoverflow.com/q/12326724/62576 — Ken White
– Ken White, Commented May 16, 2013 at 12:57

marc_s · Accepted Answer · 2013-12-26 20:41:47Z

1

Execute this query on this folder window->system32, because every sql command executes in this folder..

C:\Windows\system32>sqlcmd -S(local) -U(sa) -P(password) -i F:\sql.sql

edited Dec 26, 2013 at 20:41

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 3, 2013 at 12:00

S. S. Rawat

6,1414 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Execute sql script using sqlcmd.exe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related