asked
BCP Error..need Help
When using below BCP on drive D: bcp "TESTDB.dbo.TESTTABLE" out "[TESTTB].[dbo].[TESTTABLE].dat" -q -c -CRAW -t " " -r " " -U -P -S SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver] [Shared Memory]SQL Server does not exist or access denied. SQLState = 01000, NativeError = 2 Warning = [Microsoft][ODBC SQL Server Driver] [Shared Memory]ConnectionOpen (Connect()). Help me out..
You are trying to connect to a server using shared memory - is this protocol active on the machine? Is the username and password valid? You can test these by trying to open a connection to the machine in SSMS and specifying the username/password and protocol. This will show if the protocol is working or not. You can then also check that the username and password is correct: ![alt text][1] ![alt text][2] It may be also worth you checking the protocol is really set to "enabled". To check network connections for the sql server go to Start -> SQL Server 2k? -> Configuration Tools -> SQL Server Configuration Manager - You can then see which protocols are active for the instance: ![alt text][3] [1]: /upfiles/Capture1.PNG [2]: /upfiles/Capture_2.PNG [3]: /upfiles/netconfig.PNG
Great answer. In fact, too good. You don't leave any crumbs.
I think I said something similar to @WilliamD last night, bless 'im...
+1 - for a great answer made awesome with images and colouring-in and highlighting. Epic!!!
Just noticed you have cracked 6k karma too. Nice one, thanks for being around and helping :D
Add the sqllogin as a database user in TESTDB and give it SELECT permissions. You will get this error if the user has a login but no access to the db. Also make sure your server is set up for mixed mode (SQL Server and Windows Authentication). If you are using sqlexpress or are in a clustered environment be sure to add the appropriate server\\instance_name
