Re: Window Authentication on P2P network

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

Date: Wed, 24 Aug 2005 14:34:04 -0700

So I would create a user like "PC1\TempUser" and match the password?
would I be able to do this "PC1\Administrators"? I would assume no since I
would not be able to match the password.

"Jasper Smith" wrote:

> In your situation it would probably be simpler to just use SQL
> Authentication however in a workgroup scenario, you can create a local user
> on the SQL Server that matches the local user on the standalone PC (username
> and password must match) and this will allow the standalone PC user to
> coonect to SQL using Windows authentication
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Ken" <Ken@discussions.microsoft.com> wrote in message
> news:A2894CDB-9BD9-47E9-91ED-94EB8BA18B92@microsoft.com...
> >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: Window Authentication on P2P network
    ... Jasper Smith (SQL Server MVP) ... >> on the SQL Server that matches the local user on the standalone PC ... >>> My question is this I understand and have used Windows Authentication ...
    (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: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)