Re: Window Authentication on P2P network
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/25/05
- Next message: Andrew Prior: "Re: Security Certificates"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: VPN or Firewall"
- In reply to: Ken Hundley: "Re: Window Authentication on P2P network"
- Next in thread: Ken Hundley: "Re: Window Authentication on P2P network"
- Reply: Ken Hundley: "Re: Window Authentication on P2P network"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 24 Aug 2005 23:08:53 +0100
It has to be an individual user and it should match the user that is signed
onto the standalone PC. I tend to use this method to connect to VM's running
on my PC as I prefer using the SQL tools on my PC rather than a full screen
VM session.
-- 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 Hundley" <KenHundley@discussions.microsoft.com> wrote in message news:D786FB16-54DC-4B5B-A197-E17ADEC48044@microsoft.com... > 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 >> >> >>
- Next message: Andrew Prior: "Re: Security Certificates"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: VPN or Firewall"
- In reply to: Ken Hundley: "Re: Window Authentication on P2P network"
- Next in thread: Ken Hundley: "Re: Window Authentication on P2P network"
- Reply: Ken Hundley: "Re: Window Authentication on P2P network"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
