I am seeing some unexpected malfunctioning of the sp_addsubscription procedure when I try to setup the bidirectional replication between 2 servers running SQL Server 2005:
1. When I generate the subscription through the wizards the sp_addsubscription call is issued with sync_type = 'automatic' which implies a snapshot to be taken before the replication can start. The subscription seems to be running ok in such case, just that
it waits for the initial snapshot.
2. If I try to change the sync_type to 'none' (which is the same as 'replication support only') which actually means that only data updates are being sent and no initial snapshot is required, the sp_addsubscription procedure fails with:
The process could not connect to Subscriber 'LL-FFF-DDD'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20084)
Get help: http://help/MSSQL_REPL20084
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Source: MSSQLServer, Error number: 18456)
Get help: http://help/18456
Am I missing something in this parameter configuration [change] or is a hotfix that needs to be applied?