rahul ahuja

rahul ahuja

  • NA
  • 80
  • 35.6k

BCP Utility

Jun 11 2014 10:40 AM
Hi All,
Can some one hepl me in following command to generate the file.
I have tried various combination of the command parameter but not working.

D:\Users\admin>bcp TestDB.dbo.UAC format nul-T -n -c -f format.fmt -U sa -P admin

Warning: -c overrides -n.

SQLState = 08001, NativeError = 2

Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could no

t open a connection to SQL Server [2].

SQLState = 08001, NativeError = 2

Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-

specific error has occurred while establishing a connection to SQL Server. Serve

r is not found or not accessible. Check if instance name is correct and if SQL S

erver is configured to allow remote connections. For more information see SQL Se

rver Books Online.

SQLState = S1T00, NativeError = 0

Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired