July 20, 2006 at 12:46 pm
Hello,
When running the command: BCP Test.dbo.table1 out test.txt -S myServer -T -c on a different machine than myServer, the command runs fine. However, running it on myServer generates the following error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 10061
Warning = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
If I change the servername to -S (local) it works just fine, but I need it to work for -S myServer.
Any Solutions? Thanks.
July 20, 2006 at 1:55 pm
you are not leaving an space after the -S, are you? try: -SmyServer
* Noel
July 20, 2006 at 2:12 pm
Yes I was, but it still works even with the space. I think I resolved the issue. It looks like it was an aliasing problem on the server.
Thanks.
July 21, 2006 at 12:51 pm
Whether or not there is a space after the command flags has nothing to do with it. I'd check into your Windows Security and Authentication on the Server since you are using the -T flag, trusted connection - i.e. using your Windows Login as Authentication.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply