SQL Server: bcp utility: login fails
- by Patrick
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'.