Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: How can I set up a trust based on machine name?

    I need to set up a trust between a client machine (OS = XP professional) and an SQL server (OS = Windows Server 2000 and SQL 2000) using the client's machine name as opposed to a user Id. One of the main uses of this would be for BCP's using the "-T" option. I cannot find any information on how to do this but it seems I saw it done several years ago. Can anyone give me guidance on this?

  2. #2
    Join Date
    Nov 2002
    It doesn't work that way...

    Is this a true client or a server?

    If it's a sql server box, then use the sql server service account

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts