Groups > comp.databases.ms-sqlserver > #2139

Re: How to backup SQL Express 13

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> (permalink)
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

Show key headers only | View raw

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]

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-09 12:38 +0200
  Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-09 14:40 +0200
    Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-09 18:41 +0200
      Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-09 22:59 +0200
        Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-10 09:15 +0200
          Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-10 09:41 +0200
            Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-10 09:52 +0200
              Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-10 16:13 +0200
                Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-10 18:11 +0200
                Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-10 22:56 +0200
                Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 09:37 +0200
                Re: How to backup SQL Express 13 Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 12:54 +0300
                Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 12:21 +0200
                Re: How to backup SQL Express 13 Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 13:40 +0300
                Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-11 20:00 +0200
                Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 22:34 +0200
                Re: How to backup SQL Express 13 Erland Sommarskog <esquel@sommarskog.se> - 2022-05-11 22:42 +0200
                Re: How to backup SQL Express 13 Tim Ritberg <tim@server.invalid> - 2022-05-11 23:02 +0200
              Re: How to backup SQL Express 13 Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 15:28 +0300

csiph-web