Commerce Server General - Setting a trusted connection for SQL Server 2k

Author

Setting a trusted connection for SQL Server 2k

darin dimitrov

2004-07-09, 3:10 pm

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.

Israel Vega

2004-07-09, 3: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.