November 22, 2008 at 12:37 am
Hi, i dont really understand which settings to use when doing replication and distribution, because i get the message that i have to set the settings manually, could not login and stuff, then the tables are replicated but not the data in them. Any help please?
November 22, 2008 at 12:48 am
What settings where do you not understand? When setting up the distributor? The publication? The subscription?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2008 at 1:18 am
I dont understand when to use the sql server account and when to impersonate
November 22, 2008 at 11:23 am
Where? When setting up the distributor? When setting up the publication? When setting up the subscription? There are a number of places where security gets set doing replication.
Generally the SQL service account shouldn't be used. It's not best practice. Specific windows accounts should be set up for replication and those accounts given the rights they need. There should be info on that in BoL
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply