Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 bcp utility server problem
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

10 Posts

Posted - 09/04/2011 :  03:16:24  Show Profile  Reply with Quote
I have tried to execute..

bcp "select top 7 * from gift..t_data" out "C:\Load\Text1.txt" -T -k -S NTS81B\ISQL01

I got error:

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 2
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

Now I am remotely working on a server (Lets name it as 'GA100F1'), and I have to use a SQL Server (NTS81B\ISQL01).
In query analyzer i use NTS81B\ISQL01,1433 to connect. and 'gift' is a database name in this server having table 't_data'

Does 'C:\Load\Text1.txt' this path represent location in the server in which i am remotely logged in. Or some other location ?

Can anyone provie me solution as soon as possible. I am new in SQ server.



Very Important crosS Applying yaK Herder

52326 Posts

Posted - 09/04/2011 :  03:31:55  Show Profile  Reply with Quote
the path represents the path in server GA100F1. if you want to use path in other server you can specify as a UNC path like \\servername\...

SQL Server MVP

Go to Top of Page


United Kingdom
22859 Posts

Posted - 09/04/2011 :  05:20:44  Show Profile  Reply with Quote
"SQL Server does not exist or access denied"

Sounds like there is no "trusted" / Windows Authentication permission from your PC to SQL server ?

If you have a SQL Login that you could use instead there are parameters for BCP for that purpose.
Go to Top of Page

Starting Member

10 Posts

Posted - 09/04/2011 :  10:31:40  Show Profile  Reply with Quote
Thank you both for responses.

Kristen, I have SQL Login, but it is a windows authentication based login to the SQL Server. Hence I think I have "Trusted Connection".

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000