April 25, 2014 at 10:13 pm
when i am doing BCP out command i am getting this error
C:\Users\ADMIN>bcp master.sys.syslogins out c:\syslogins.dat -S admin-pc\admin -T
SQLState = 08001, NativeError = -1
Error = [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces:
Error Locating Server/Instance Specified [xFFFFFFFF].
SQLState = 08001, NativeError = -1
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
April 28, 2014 at 3:51 pm
As the error indicates, bcp cannot find the server in the server\instance string in the -S switch.
If the server is correct, I would wrap the string in double quoutes ("), because it is likely the DOS shell is having issues with the dash in the string
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply