Trusted Connection failing

[C. Winckler]

Hi All

When trying to register a server on a remote (trusted) domain, i get the
following error:
Unable to Connect to Server (Reason: Login failed- User:
CCRDBA_Administrator Reason: Not defined as a valid user of a trusted SQL
Server connection). Register Anyway?

My local domain is CCRDBA.
I am logged onto the local server as the NT User Administrator, and it
seems that it automatically wants to use the remote SQL login/username of
CCRDBA_Administrator. So i thought i would be smart and create a user
called CCRDBA_Administrator on the remote machine, but that does not work.
Has anyone done this using trusted connections?

We can register using standard security, but the problem is that we need
a trusted connection in order to set up replication between these two domains.

Any ideas /hints from someone who has done this would be appreciated.

Regards

--
Cor

The Data Base Approach cc _______ Cor Winckler
PO Box 5165, Helderberg |\ | Internet: c...@dba.co.za
7135 Somerset West | >=====| Tel: 0(+27) 21 557 5404
South Africa |/______| Fax: 0(+27) 21 881 3318

[Bill Lester]

>When trying to register a server on a remote (trusted) domain, i get the
>following error:
>Unable to Connect to Server (Reason: Login failed- User:
>CCRDBA_Administrator Reason: Not defined as a valid user of a trusted SQL
>Server connection). Register Anyway?

Use sp_grantlogin to give NT groups rights to the specific SQLServer.

-Bill Lester
Bi...@udp.com