Windows Authentication from a workgroup to a domain sql server
- From: "Sumon" <sumon.net@xxxxxxxxx>
- Date: 25 Mar 2007 21:06:32 -0700
Hi,
I have got a user from a diff subnet and his computer is not part of
our domain, just a workgroup. But the workgroup name is the same as
our domain name.
The user has a local account, which I have also added in our AD with
the same name and password.
Example Setup:
DOMAIN NAME: abc
SQL Part of abc domain (running as a cluster)
Client Machine Workgroup Name: abc
Not part of any domain.
Local user account name: test
Domain abc also contains a user called abc with same password.
When the user tries to connect the SQL server comes back with:
System.Data.SqlClient.SqlException: Login failed for user ''. The user
is not associated with a trusted SQL Server connection.
What am i missing here.. would this work?
Thanks
Sazzad
.
- Follow-Ups:
- Re: Windows Authentication from a workgroup to a domain sql server
- From: Russell Fields
- Re: Windows Authentication from a workgroup to a domain sql server
- Prev by Date: Security role problem
- Next by Date: Re: owned schema or role members?
- Previous by thread: Re: Setting Up SQL Security
- Next by thread: Re: Windows Authentication from a workgroup to a domain sql server
- Index(es):
Relevant Pages
|
|
