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.
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
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.
Yes necessary privileges are required, see this MSDN http://msdn.microsoft.com/en-us/library/aa275745(SQL.80).aspx article for information.
