June 23, 2011 at 7:42 am
All,
I am trying to setup replication in a VM environment with the publisher and distributor on the same 'LocalServer' with a pull subscription on a 'ReportServer'. But I am unable to run the snapshot agent successfully. I get the following error. I also got the same errror when I tried to set up as Transactional and a push.
2011-06-21 13:25:23.19 Connecting to Distributor 'LocalServer'
2011-06-21 13:25:23.93 Parameter values obtained from agent profile:
2011-06-21 13:25:23.93 ---------------------------------------------
2011-06-21 13:25:23.93 -BcpBatchSize 100000
2011-06-21 13:25:23.93 -HistoryVerboseLevel 2
2011-06-21 13:25:23.93 -LoginTimeout 15
2011-06-21 13:25:23.93 -QueryTimeout 1800
2011-06-21 13:25:23.93 ---------------------------------------------
2011-06-21 13:25:24.02 Connecting to Publisher 'LocalServer'
2011-06-21 13:25:24.30 The replication agent had encountered an exception.
2011-06-21 13:25:24.30 Source: Replication
2011-06-21 13:25:24.30 Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException
2011-06-21 13:25:24.30 Exception Message: Login failed for user 'Domain\User'.
2011-06-21 13:25:24.30 Message Code: 18456
2011-06-21 13:25:24.30
The 'Domain\User' has dbowner on the publisher db and subscriber db, distribution, and msdb. It also has full control of the snap shot share.
Any advice?
Thanks,
DK
June 23, 2011 at 9:39 am
It doesn't say "permission denied", it says "login failed".
I think it's a username/password issue. Have you double checked the credentials?
-- Gianluca Sartori
June 23, 2011 at 2:01 pm
I am sure of the username/password. I am getting this in the log: Error: 18456, Severity: 14, State: 6.
Isn't this in conjunction with using a windows account as a sql account? But I thought replication needed a Windows or Domain account because of the need to access file shares?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply