07-09-04 08:10 PM
You will not be able establish a trusted connection between the workgroup
and the domain because the credentials for the user cannot be verified. You
will have to use SQL (sa) authentication.
"darin dimitrov" <darin_dimitrov@hotmail.com> wrote in message
news:2b32e7c2.0407060658.6ca8fe80@posting.google.com...
> Hello,
>
> I am new to SQL Server and I have a question about connecting to
> it. Here is my scenario:
>
> MachineA (126.22.0.136): SQL Server 2000 (Win2000)
> MachineB (126.22.0.36): client (WinXp)
>
> MachineB belongs to a domain whereas MachineA is in a separate
> Workgroup. Assuming that I have total control (administrator) over
> MachineA how should I configure it so that I can establish a secure
> connection (using integrated windows authentication) from MachineB to
> MachineA? Please note that at this stage my company's policy doesn't
> allow adding MachineA to the domain nor creating a new domain for the
> SQL Server and making it trust the first domain.
>
> When I try to connect I get "Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server". Any ideas will be
> welcome if there is a solution to this. Thanks in advance.
[ Post a follow-up to this message ]
| 
