X-Received: by 10.55.160.15 with SMTP id j15mr14771663qke.0.1510585913152; Mon, 13 Nov 2017 07:11:53 -0800 (PST) X-Received: by 10.31.41.81 with SMTP id p78mr893379vkp.2.1510585912926; Mon, 13 Nov 2017 07:11:52 -0800 (PST) Path: csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!p44no144345qtj.0!news-out.google.com!t48ni129qtc.1!nntp.google.com!u20no757349qtu.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: microsoft.public.sqlserver.server Date: Mon, 13 Nov 2017 07:11:52 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=24.131.62.29; posting-account=7rqviwoAAADsXPq-9iOkXvEyoNOUox6x NNTP-Posting-Host: 24.131.62.29 References: <5dc22c62-656b-4f88-a6eb-22033e6855a5@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: Problem with SQLCMD in Single User Mode - Account is disabled From: toddism@gmail.com Injection-Date: Mon, 13 Nov 2017 15:11:53 +0000 Content-Type: text/plain; charset="UTF-8" Lines: 35 Xref: csiph.com microsoft.public.sqlserver.server:18815 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