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

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

Re: Problem with SQLCMD in Single User Mode - Account is disabled

Show all headers | View raw

on the SQLCMD  ?

On Monday, November 13, 2017 at 10:02:28 AM UTC-5, Erland Sommarskog wrote:
> (toddism@gmail.com) writes:
> > 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.
> > 
> 
> A bit of shot in the dark, but try specifying -A to use the administrative 
> connection.
> 
> 
> -- 
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
> 
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to microsoft.public.sqlserver.server | Previous | Next — Previous in thread | 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