Very Computer

by **daniel heski** » Tue, 08 Jan 2002 02:29:32

I constantly get the "login failed for user
distributor_admin" message when trying to set up
transactional (or any other) replication from one SQL 7 to
another. It occurs already when trying to set up the
distributor.
I have tried to use a trusted connection and also tried to
use the sa account.
The weird thing is that I can do it on a test system in
the house, but not on the system that is supposed to run
it. Could it be because I have tried it once and it
failed, and I now need to reinstall the SQL server, or is
there a logical explanation for this?
thanx
daniel

by FR » Tue, 08 Jan 2002 15:42:52

Check

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q225129

Quote:> I constantly get the "login failed for user
> distributor_admin" message when trying to set up
> transactional (or any other) replication from one SQL 7 to
> another. It occurs already when trying to set up the
> distributor.
> I have tried to use a trusted connection and also tried to
> use the sa account.
> The weird thing is that I can do it on a test system in
> the house, but not on the system that is supposed to run
> it. Could it be because I have tried it once and it
> failed, and I now need to reinstall the SQL server, or is
> there a logical explanation for this?
> thanx
> daniel

by **danie** » Tue, 08 Jan 2002 23:45:56

As I stated in the previous message I have already tried
to establish a trusted connection between the distributor
and the publisher (in fact it is the same machine) and I
have tried to use the sa account. Neither seems to work.

>-----Original Message-----
>Check

>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q225129

>> I constantly get the "login failed for user
>> distributor_admin" message when trying to set up
>> transactional (or any other) replication from one SQL 7
to
>> another. It occurs already when trying to set up the
>> distributor.
>> I have tried to use a trusted connection and also tried
to
>> use the sa account.
>> The weird thing is that I can do it on a test system in
>> the house, but not on the system that is supposed to run
>> it. Could it be because I have tried it once and it
>> failed, and I now need to reinstall the SQL server, or
is
>> there a logical explanation for this?
>> thanx
>> daniel

>.

by **Mike Hote** » Thu, 10 Jan 2002 04:48:02

What account is SQL Server and the agent running under?
Is it the same on both machines? Is the password the
same? Can ping each machine by both name and IP from each
other? Can you map an admin share on each machine from
each other logged in under the account running SQL Server?

Mike
SQL Server MVP

>-----Original Message-----
>As I stated in the previous message I have already tried
>to establish a trusted connection between the distributor
>and the publisher (in fact it is the same machine) and I
>have tried to use the sa account. Neither seems to work.

>>-----Original Message-----
>>Check

>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;Q225129

>>> I constantly get the "login failed for user
>>> distributor_admin" message when trying to set up
>>> transactional (or any other) replication from one SQL
7
>to
>>> another. It occurs already when trying to set up the
>>> distributor.
>>> I have tried to use a trusted connection and also
tried
>to
>>> use the sa account.
>>> The weird thing is that I can do it on a test system in
>>> the house, but not on the system that is supposed to
run
>>> it. Could it be because I have tried it once and it
>>> failed, and I now need to reinstall the SQL server, or
>is
>>> there a logical explanation for this?
>>> thanx
>>> daniel

>>.

>.

Very Computer

Error 18456: Login failed for user distributor_admin

Error 18456: Login failed for user distributor_admin

Error 18456: Login failed for user distributor_admin

Error 18456: Login failed for user distributor_admin

Error 18456: Login failed for user distributor_admin