Problem with SQLCMD in Single User Mode - Account is disabled

[t***@gmail.com]

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.

[Erland Sommarskog]

Post by t***@gmail.com
using command prompt as administrator
"C:\Program Files\Microsoft SQL

Server\MSSQL12.INTRAVET\MSSQL\Binn\sqlservr.exe" -sSERVERNAME -mSqlCmd

Post by t***@gmail.com
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.

[t***@gmail.com]

on the SQLCMD ?

Post by t***@gmail.com

Post by t***@gmail.com
using command prompt as administrator
"C:\Program Files\Microsoft SQL

Server\MSSQL12.INTRAVET\MSSQL\Binn\sqlservr.exe" -sSERVERNAME -mSqlCmd

Post by t***@gmail.com
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.
--
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

[Erland Sommarskog]

Post by t***@gmail.com
on the SQLCMD ?

-A is indeed an option to SQLCMD.