Windows authentication; implementing

  • I have a network of 2 PCs, named PC1 and PC2, connected thru TCP/IP.

    PC1 has Windows XP Professional and SQL server 2000 Developer Edition.

    PC2 has Windows 2000.  A Visual FoxPro 8 application is installed here.  This is a simple application that updates a table in a SQL Server database in PC1.

    My question is:

    Is it possible to use Windows authentication when connecting the application in PC2 to SQL Server in PC1?

    If the answer is yes, how can I do it?

    Note there is no Windows NT or Windows 2000 Server, so there's no domain. 

    Thanks in advance for your help,

    Xavier Castillo.

  • This was removed by the editor as SPAM

  • It has to be a trusted domain for Windows Authentication to work. Both computers must be able to authenticate logins at the same place. This also means that both computers use the same login and password for each user. (Again, that's because they authenticate in the same place - a domain controller).

    -SQLBill

  • Thanks for your explanation.  It's clear.

    Xavier Castillo.

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

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