Re: Again a "Login failed for user 'null"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bala Neerumalla[MSFT] (balnee_at_online.microsoft.com)
Date: 02/28/04

  • Next message: Bala Neerumalla[MSFT]: "Re: Cannot generate SSPI context and Windows 2000 service pack 4" 
    Date: Fri, 27 Feb 2004 16:20:20 -0800

    How are you launching the snapshot agent? through command line or sql server
    agent?
    What is the exact command that you are using?
    What account is the SQL agent service running under?

    Thanks,
    Bala. 

    -- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michiel" <meme@ikkus.com> wrote in message
news:403b5fc8$0$32978$e4fe514c@dreader15.news.xs4all.nl...
> Hi,
>
> I'm trying to setup replication between 2 SQL server on 2 different sites.
>
> SQL server A is a W2k SP4 server with SQL7.0 with SQL2000 client tools
> SQL server B is a W2k SP4 server with SQL2000
>
> Servers are in mixed mode.
> Servers both have MDAC version 2.6 sp2
> Username used to login to the server is the administrator and for
connection
> to SQL is use the sa account.
>
> When I try to start a snapshot agent I get the message "Login failed for
> user 'null'. Reason: Not associated with a trusted SQL Server connection"
>
> How can I solve this problem.
>
> kind regards
> Michiel Boer
>
>
>
  • Next message: Bala Neerumalla[MSFT]: "Re: Cannot generate SSPI context and Windows 2000 service pack 4"

    Relevant Pages

    • Re: Snapshot Creation
      ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
      (microsoft.public.sqlserver.replication)
    • Re: Snapshot Creation
      ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... the snapshot agent properties with the password for the publisher? ...
      (microsoft.public.sqlserver.replication)
    • Re: Snapshot Creation
      ... The Microsoft AD account under which the Snapshot agent (and other ... I have since moved the AD account around some more between User, Power User, ... Looking for a SQL Server replication book? ... SQL Server Scheduled Job 'Replication agents checkup' ...
      (microsoft.public.sqlserver.replication)
    • Re: Transformable v. regular subscriptions
      ... I have an extra timestamp column in each of the subscriber tables, ... snapshot agent to export the NULL values for inserting into those extra ... Looking for a SQL Server replication book? ... in respect of transferring the exact copy of published data to the ...
      (microsoft.public.sqlserver.replication)
    • Re: Snapshot Creation
      ... snapshot agent properties with the password for the publisher? ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... There are red circles with white Xs in EM on Replication Monitor, ...
      (microsoft.public.sqlserver.replication)