Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : How to change the windows account


M
3/24/2006 8:54:40 AM

I am trying the snapshot replication.
The publication and snapshot agency in a SQL Server 2000 machine and
subscription in a SQL server 2005 machine.
I set both SQL Server' Security to Window authencation mode.
I create a test publication.
The snapshot agency failed to connect to publication:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection. (Source: MSSQLServer, Error number: 18452)
Get help: http://help/18452
Why the The windows account for Snapshot agent is 'sa' How can I change it



M
3/24/2006 4:18:49 PM

No mater how I change the
Agent Process Account
Distributor connection

When I reinitialize the subscription
I get :
The job failed. The Job was invoked by User sa


AddThis Social Bookmark Button