Post reply

bcp connection error

  • August 12, 2015 at 11:13 am

    #310886

    I have sql server express installed on my local machine and I am trying to send data from a table out to a text file using bcp from cmd using this command:

    bcp dbMeals.dbo.tblFood OUT e:\Innovaya\food.txt -c -S -T

    But I am getting this error message:

    SQLState = 08001, NativeError = 10061

    Error = [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection co

    uld be made because the target machine actively refused it.

    SQLState = 08001, NativeError = 10061

    Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-

    specific error has occurred while establishing a connection to SQL Server. Serve

    r is not found or not accessible. Check if instance name is correct and if SQL S

    erver is configured to allow remote connections. For more information see SQL Se

    rver Books Online.

    SQLState = S1T00, NativeError = 0

    Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired

    I can connect the the instance and the browser is running. Any ideas?

    Thanks!

  • August 12, 2015 at 2:39 pm

    #1819506

    SQL Express usually installs as an instance name, and not a default instance.

    your BCP is assuming a default instance, i'd bet you have a named instance instead.

    check your servername\instancename, but i bet it's something like this instead:

    bcp dbMeals.dbo.tblFood OUT e:\Innovaya\food.txt -c -S .\SQLEXPRESS -T

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 12, 2015 at 7:49 pm

    #1819540

    Thanks Lowell! That was it, I just need to add my server name/instance name.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy