SQL Server Performance

Snapshot Replication

Discussion in 'Getting Started' started by lcerni, Jul 2, 2010.

  1. lcerni New Member

    I have set up Snapshot Replication from one server to another and I believe that I have set it up correctly. However, I am getting the following error message:Error messages:Message: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
    Stack: at Microsoft.SqlServer.Replication.ServerConnectionEmulator.Connect()
    at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.EstablishPublisherConnection()
    at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
    at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
    at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 18456)
    Get help: http://help/18456
    Server ServerName, Level 14, State 1, Procedure , Line 65536
    Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. (Source: MSSQLServer, Error number: 18456)
    Get help: http://help/18456
    I have never had this type of error message. I have been researching and I am wondering if it because SQL Server was set up with the Local Account versus the Domain Account. If this is true is there any way around this? I have been told that the powers that control the servers are not willing to set up a Domain Account.
  2. MohammedU New Member

    Yes, it is the service account running under local account issue...
    If you have the option to use domain account which has the access to subscriber then you can use window authentication if not you can use the SQL Authentication...
    Check the following topic for more details...
    Managing Logins and Passwords in Replication
    http://msdn.microsoft.com/en-us/library/ms151219.aspx
  3. lcerni New Member

    If I create a SQL Server user on the Publisher must that user have sysadmin privileges? It looks like it will work if the user is set up as db_owner but I want to make sure. I don't want to give the user unnecessary privileges.
  4. satya Moderator

Share This Page