Re: Using Windows Authentication to access SQL Server from non-domain


"Stephen Schaub" <Stephen Schaub@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6FE36564-6CB4-4B8C-BC79-84A3B598CA70@xxxxxxxxxxxxxxxx
We have SQL Server 2000 installed on Windows Server 2003 SP 1. The server
is
a member of a domain.

We have developers on workstations not part of the domain who need to use
a
Trusted Connection to access a database on the server. I've read some
other
posts that suggest this is possible. The developers created a local
account
on their workstation with the username/password credentials that match
those
of a domain user. When logged in under that account on their local
workstation, I believe they should be able to establish a trusted
connection
to SQL Server using Enterprise Manager. But the authentication fails with
the
message "Logon failed for user '(null)'."

Any suggestions would be appreciated.

That's not quite right. The users should create a local account with
username and password matching a _local_ account on the server, not a domain
account.


David



.

Relevant Pages

  • Re: Trust relationship between this workstation and Primary Domain
    ... it, with a new computer ID, a new workgroup ID, but again to no avail. ... password policy, renamed admin account, automatic updates are controlled by ... * PLEASE post all messages and replies in the newsgroups ... "Workstation ...
    (microsoft.public.win2000.networking)
  • Re: Re-Post - "the trust relationship between this workstation and
    ... account is NEW to the workstation. ... needs admin group priv at workstation level. ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ...
    (microsoft.public.windows.server.active_directory)
  • Re: Re-Post - "the trust relationship between this workstation and
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... The DNS Zone for your AD Domain must be DYNAMIC, ... Client computer must use STRICTLY the INTERNAL DNS server which can ...
    (microsoft.public.windows.server.active_directory)
  • Joining NT4 to a Windows 2000 domain; secure channel prob?
    ... Trying to logon with a domain account pops up the error: ... The trust relationship between this workstation and the primary ... Searching PDC for domain MYDOMAIN ... ...
    (microsoft.public.windows.server.active_directory)
  • Re: Re-Post - "the trust relationship between this workstation and
    ... There were no logged events in either the DC or workstation. ... DC/DNS Server - DCDiag ... Attr: subschemaSubentry ... only problem is adding a new user account on the station. ...
    (microsoft.public.windows.server.active_directory)