Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2718
  • Last Modified:

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
0
NeoTeq
Asked:
NeoTeq
  • 2
  • 2
1 Solution
 
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
 
imitchieCommented:
have you followed the steps in

http://support.microsoft.com/kb/914277
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now