Post reply

bcp out - dump file to another domain

  • June 28, 2011 at 12:50 pm

    #1345427

    <<TCP Provider: No such host is known. >> try debugging why this message is coming....

    from source machine try below...

    ping to see ip is accesible

    telnet to below ports to ensure file copy ports are open...(try to manual copy file to see if it works)

    UDP 138, TCP 139, TCP 389, UDP 389, TCP 445, TCP 135

    Share your findings and result of any other troubleshooting you have done...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • June 29, 2011 at 9:29 am

    #1346004

    If there is a trust between the two domains, you should be able to grant access to the SQL service account to that resource. For troubleshooting try bcping to a local drive first, then concentrate on copying to another domain.

    A second issue is that the -U switch is for SQL Authentication. Try -E instead of U and P. Good luck!

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

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