I am a novice to SQL. I am trying to setup a basic database and export it to a .csv file. I have read several articles regarding this. Some say you cant do it, some say use DTS and others BCP.
Regarding DTS, I have downloaded and installed everything in Microsoft SQL Server 2005 Express Edition Toolkit, but none of it includes DTS.
so I thought I would try bcp.
I am running this command on the server in a commandprompt.
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>bcp test.table_1 out c:\test.csv -S SQLEXPRESS -T
But I get the following error:
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a con
nection to SQL Server [53].
SQLState = HYT00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure may
be caused by the fact that under the default settings SQL Server does not allow
remote connections.
I have allowed tcpip in server config and also started the browser in Surface area connection.
I know I am probably doing something stupid, can any one help with either of above.
Thanks Terry
Start Free Trial
