Unable to start sqlcmd - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Unable to start sqlcmd

Author

Topic

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-30 : 06:12:47

I am getting the below error when i typed sqlcmd in my command prompt.
Looking for help..

C:\Windows\system32>sqlcmd
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
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.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-12-30 : 13:21:19

You'll need to pass what server you want to connect to:

sqlcmd -Sserver1\instance1 -E

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

sgondesi
Posting Yak Master

200 Posts

Posted - 2014-01-02 : 05:11:32

quote:
Originally posted by tkizer

You'll need to pass what server you want to connect to:

sqlcmd -Sserver1\instance1 -E

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Ya.. i came to know how to access that. sorry for not updating here. And thank you for the reply.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources