Trying to Connect to SQLCMD for Some Reason Im unable to CONNECT to the SQL COMMAND.

Question

Trying to Connect to SQLCMD for Some Reason Im unable to CONNECT to the SQL COMMAND.

allamsanjeev

SSC Rookie

Points: 34
More actions
April 24, 2014 at 9:06 am

#307075

I Am Using a Windows 7 operating system with SQL SERVER 2012 , trying to restore the master database.
I have put the instance in Single user mode by including -m in the startup parameters.
I have stopped the instance using NET STOP
When I Start using SQLCMD -s <Computername\instance name> -E
it Shows up Error=
Named pipes Provider could not open a connection to SQL Server [2]..
SQLCMD Error MS SQL SERVER : Login Timeout expired
SQLCMD Error MS SQL SERVER : A network related or instance -specific error has occured while establishing a connection to SQL SERVER. SERVER is not found or Not Accessible .Check if instance is correct and if SQL SERVER is configured to allow remote connections.
Please Help me with Query.
Thanks
Sanjeev

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

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

Have you navigated to the right folder before running sqlcmd? I just tested it in the wrong location and got that error message.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 2

Run Nat start in cmd and check if the instance you are connecting to is there.

😎

allamsanjeev SSC Rookie Points: 34 More actions · Answer 3

Haven't done any such step? If you can be more elobrative would be of much needed help.

Thanks

allamsanjeev SSC Rookie Points: 34 More actions · Answer 4

I have ran Net start and Stop i Runs fine on the instance

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

allamsanjeev (4/24/2014)
Haven't done any such step? If you can be more elobrative would be of much needed help.
Thanks

Open up command prompt (cmd.exe)

type: net start

and hit enter

the output should be:

These Windows services are started:

....

SQL Full-text Filter Daemon Launcher (SQL2012)

SQL Server (SQL2012)

SQL Server Analysis Services (SQL2012)

SQL Server Browser

SQL Server Integration Services 11.0

SQL Server VSS Writer

where the instance name is in parentheses, this case SQL2012, check what the instance name is in your case.

😎

allamsanjeev SSC Rookie Points: 34 More actions · Answer 6

I did try that, still the problem persists, looks like it is OS permissions issue..

Lowell SSC Guru Points: 323504 More actions · Answer 7

there's not multiple instances, right?

you know you used lower case -s and not uppercase -S? and the parameter flags are case sensitive

based on what you posted, this should be working

SQLCMD -S .\SQL2012 -E

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!