Solved

Bcp problem - Login time out - SQL Server 2005

Posted on 2007-11-29
5
2,693 Views
Last Modified: 2008-02-01
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
Comment
Question by:NeoTeq
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 20372336
Is the server is running in mixed mode

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


0
 
LVL 10

Author Comment

by:NeoTeq
ID: 20372343
>> 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
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20372381
have you followed the steps in

http://support.microsoft.com/kb/914277
0
 
LVL 10

Author Comment

by:NeoTeq
ID: 20372517
Yeah, done those already, but no effect.
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20372900
have you made sure the network adapter is configured for NETBIOS? (required for named pipes)
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question