Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.server > #18813

Problem with SQLCMD in Single User Mode - Account is disabled

Newsgroups microsoft.public.sqlserver.server
Date 2017-11-13 05:51 -0800
Message-ID <5dc22c62-656b-4f88-a6eb-22033e6855a5@googlegroups.com> (permalink)
Subject Problem with SQLCMD in Single User Mode - Account is disabled
From toddism@gmail.com

Show all headers | View raw

I start the server in single user mode:

using command prompt as administrator

"C:\Program Files\Microsoft SQL Server\MSSQL12.INTRAVET\MSSQL\Binn\sqlservr.exe" -sSERVERNAME -mSqlCmd


then 

sqlcmd  -SSERVERNAME\INSTANCE -d master

What I get back is 

Login failed for user 'SERVERNAME\INSTA'. Reason: The account is disabled.


I've tried named pipes, specifying t:server:port.  No good.

Back to microsoft.public.sqlserver.server | Previous | Next — Next in thread | Find similar

Thread

Problem with SQLCMD in Single User Mode - Account is disabled toddism@gmail.com - 2017-11-13 05:51 -0800
  Re: Problem with SQLCMD in Single User Mode - Account is disabled Erland Sommarskog <esquel@sommarskog.se> - 2017-11-13 15:02 +0000
    Re: Problem with SQLCMD in Single User Mode - Account is disabled toddism@gmail.com - 2017-11-13 07:11 -0800
      Re: Problem with SQLCMD in Single User Mode - Account is disabled Erland Sommarskog <esquel@sommarskog.se> - 2017-11-13 23:03 +0100

csiph-web