Bcp problem - Login time out - SQL Server 2005

I can not get bcp to work on my local machine for SQL Server 2005. I get the following error:
SQLState = 08001, NativeError = 2
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
SQLState = HYT00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
SQLState = 08001, NativeError = 2
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 tried to both use a trusted connection and provide a username/password combination.

I have changed the following settings so far:
- Enable remote connections
- Enable named pipes
- Start the SQL Server browser service
LVL 10
NeoTeqAsked:
Who is Participating?
 
imitchieConnect With a Mentor Commented:
have you followed the steps in

http://support.microsoft.com/kb/914277
0
 
James MurrellProduct SpecialistCommented:
Is the server is running in mixed mode

Is  the server is configured to accept both local and remote connection


0
 
NeoTeqAuthor Commented:
>> Is the server is running in mixed mode
Yes, it is.

>> Is  the server is configured to accept both local and remote connection
Yes, but using named pipes only (no TCP/IP).
0
 
NeoTeqAuthor Commented:
Yeah, done those already, but no effect.
0
 
imitchieCommented:
have you made sure the network adapter is configured for NETBIOS? (required for named pipes)
0
All Courses

From novice to tech pro — start learning today.