Window Authentication on P2P network

From: Ken (Ken_at_discussions.microsoft.com)
Date: 08/24/05


Date: Wed, 24 Aug 2005 13:51:07 -0700

I have read and understand the advantages of using Windows Authentication
with SQL Server.
My question is this I understand and have used Windows Authentication on a
standalone computer and on a domain. However, how do you setup and use
windows authentication on a peer-to-peer network or on a domain where
perodically there may need to be a computer accessing the server that is not
on the domain.
Is there any way to do this or do you have to use SQL authentication when
you are in a p2p environment.

Thanks,
Ken



Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Window Authentication on P2P network
    ... > on the SQL Server that matches the local user on the standalone PC (username ... > Jasper Smith (SQL Server MVP) ... >>I have read and understand the advantages of using Windows Authentication ... >> standalone computer and on a domain. ...
    (microsoft.public.sqlserver.security)
  • Re: MS SQL Server Management Studio Express - Changing User at Windows Authentication
    ... if i have 2 Computers in different domains (one with a SQL Server) and want to connect to the SQL Server with Windows authentication how can i change the login information in the "Connect to server" dialog. ... wenn ich 2 Computer in unterschiedlichen Domänen habe und mich mit diesen vom andren aus per Management Studio Express verbinden will kann ich bei der Windows Authentifizierung den Usernamen und das Passwort nicht ändern. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: MS SQL Server Management Studio Express - Changing User at Windows Authentication
    ... if i have 2 Computers in different domains (one with a SQL Server) and want to connect to the SQL Server with Windows authentication how can i change the login information in the "Connect to server" dialog. ... wenn ich 2 Computer in unterschiedlichen Domänen habe und mich mit diesen vom andren aus per Management Studio Express verbinden will kann ich bei der Windows Authentifizierung den Usernamen und das Passwort nicht ändern. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)