Sunday, February 26, 2012

error using bcp util?

from BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/c0af54f5-ca4a-4995-a3a4-0ce39c30ec38.htm

I'm trying to run this sample

bcp AdventureWorks.Sales.Currency format nul -T -c -x -f Currency.xmlSQLState = 28000, NativeError = 18456
Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'AD-ENT\loeca01'.
SQLState = 08S01, NativeError = 4
Error = [Microsoft][SQL Native Client]Shared Memory Provider: The system cannot open the file.SQLState = 08S01, NativeError = 4
Error = [Microsoft][SQL Native Client]Communication link failure
SQLState = 42000, NativeError = 4060
Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database requested in login 'AdventureWorks'. Login fails.
I don't have any issue accessing the database from management studio and I have enabled all the protocols.what's up do I need to setup some other permissions someplace in the file system or something?How many instances of SQL Server 2000 and 2005 do you have on your machine|||

bcp AdventureWorks.Sales.Currency format nul -T -c -x -f Currency.xml -S RCSDMN1B5120B7Q\SQL_2005

worked....

|||If you don't specify a server it will try and connect to your default instance which is not the one with adventureworks on it thus the error.

No comments:

Post a Comment