SQL Server: bcp utility: login fails
Posted
by Patrick
on Stack Overflow
See other posts from Stack Overflow
or by Patrick
Published on 2010-05-10T14:10:01Z
Indexed on
2010/05/10
14:14 UTC
Read the original article
Hit count: 251
Filed under:
sql-server
Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>bcp "SELECT TOP 1000 * FROM SOData.dbo.E
xperts" queryout c:\customer3.txt -n -t -UAdministrator -P -SDNAWINDEV
SQLState = 28000, NativeError = 18456
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for u
ser 'Administrator'.
or.. without -P flag
C:\Documents and Settings\Administrator>bcp "SELECT TOP 1000 * FROM SOData.dbo.E
xperts" queryout c:\customer3.txt -n -t -UAdministrator -P -SDNAWINDEV
SQLState = 28000, NativeError = 18456
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for u
ser 'Administrator'.
or, without -P flag, and typing the password.. is the same
C:\Documents and Settings\Administrator>bcp "SELECT TOP 1000 * FROM SOData.dbo.E
xperts" queryout c:\customer3.txt -n -t -UAdministrator -SDNAWINDEV
Password:
SQLState = 28000, NativeError = 18456
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for u
ser 'Administrator'.
© Stack Overflow or respective owner
