February 27, 2016 at 6:40 pm
I have been practicing my replications for the 70-462 on
https://www.microsoft.com/en-us/server-cloud/support/learning-center/virtual-labs.aspx
which is microsoft's virtual lab. Surprisingly their alwayson lab with the 4 fake computers also works for replications
I finally got merge replication to work, it's not easy. Here's my question. Everytime the wizard wanted to make a new agent or is it one of many jobs the agent does for the snapshot and the log it wants login information. I've been using contoso/labuser for all of them because it is a windows login and part of the sysadmin role on every computer. That also means the database has to be owned by contoso/labuser or the log agent wont' run sp_replcmds which I'm sure won 't be on the test because the stupid toolkit doesn't have this bit of information. Anyway, I've read everywhere that each agent or job should have its own account etc. etc. and I'm sure this is on the test. So in real life, do people make more windows accounts like contoso/someotheruser on the domain computer that gives out logins and then add that login to the user to the proper role which may be less than sysadmin and then that login is what I type in order to get the replications to work?
I don't want to say this is overly complex, but you don't see a bunch of accountants on some forum elucidating the fine points of revenue recognition under ASU 2014-09 in 2017
March 3, 2016 at 7:43 am
Yes, in real life you do use separate accounts not having sysadmin privileges. If you don't, you're at risk when your security is breached in any way. It's not even that much work. Just do it if you want to keep your admin job longer than the next person's screw-up.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply