Path: csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Anton Shepelev <anton.txt@g{oogle}mail.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: How to backup SQL Express 13
Date: Wed, 11 May 2022 12:54:42 +0300
Organization: A noiseless patient Spider
Lines: 21
Message-ID: <20220511125442.a5e4defd96e8023137c894fe@g{oogle}mail.com>
References: <t5aqus$9v2d$1@tota-refugium.de> <XnsAE929550276E3Yazorman@127.0.0.1> <t5bg88$aehe$1@tota-refugium.de> <XnsAE92E9E405CFEYazorman@127.0.0.1> <t5d3ds$bbi0$1@tota-refugium.de> <XnsAE93629CB7D32Yazorman@127.0.0.1> <t5d5k0$bd48$1@tota-refugium.de> <XnsAE93A4F762B01Yazorman@127.0.0.1> <t5e2s3$c27b$1@tota-refugium.de> <XnsAE93E956C2678Yazorman@127.0.0.1> <t5fp3b$bvra$1@tota-refugium.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="1815761ac291dd1c09454638be352e31"; logging-data="12009"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18UtHCJ1TEU7TFXzFtguIa7Em/sn0ZOOK4="
Cancel-Lock: sha1:xhncnjvuyAzDW23RwU15+dDxaw4=
X-Newsreader: Sylpheed 3.5.0 (GTK+ 2.24.23; i686-pc-mingw32)
Xref: csiph.com comp.databases.ms-sqlserver:2139

Tim Ritberg:

> I tried this, with different account formats: domainser,
> user, user@

If you want to login as a Windows user, rather than an SQL
user, avoid both -U and -P.  This is well documented:

,----[https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility:]
| If neither the -U option or the -P option is specified,
| sqlcmd tries to connect by using Microsoft Windows
| Authentication mode. Authentication is based on the
| Windows account of the user who is running sqlcmd.
`---------------------------------------------------

It is always better to consult the documentation than to try
things at random.

-- 
()  ascii ribbon campaign - against html e-mail
/\  http://preview.tinyurl.com/qcy6mjc [archived]