Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdba
Yak Posting Veteran
53 Posts |
 Posted - 2009-05-01 : 15:17:48
|
| Hi,I'm getting following errors.C:\DS\data>bcp LAB.PS.test out c:testdata.bcp -n -Usa -P<PASSWORD>SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].SQLState = HYT00, NativeError = 0Error = [Microsoft][SQL Native Client]Login timeout expiredSQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure maybe caused by the fact that under the default settings SQL Server does not allowremote connections.Please advice. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2009-05-01 : 16:22:44
|
| Work fine backup but having issue during restore.C:\DS\data>bcp testd.dbo.Table_1 in c:\ds\table_1.csv -S<SERVERNAME> -n -Utestsys -PtestsysSQLState = 42S02, NativeError = 208Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'testd.dbo.Table_1'. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
BCP error