June 18, 2003 at 8:05 am
Please confirm that the domain user id used to start the MSSQLServer and SQLServerAgent must be a member of the Administrators local group to use log shipping. There is a statement that if using a domain user login account that is not a member of the Administrators local group, the login account must have file system permissions and must have read-write permissions on specified registry keys. Therefore, when using log shipping is it a must that the domain user login account have Administrator permissions or can giving file system permissions and read-write permissions be sufficient to use log shipping.
Thanks You,
Charlie Nichols
Edited by - cnichol4 on 06/18/2003 3:11:29 PM
Charles L. Nichols
June 20, 2003 at 7:23 am
Although I use my own version of log shipping the only real permissions you need are to be able to move the files and call the remote server(s) just do a file copy from within agent jobs using xp_cmdshell, then run sp_who on the remote server. If both these work then your log shipping should be ok.
I usually place the domain accounts for the sql servers in their own group/role and grant ntfs/share permissions to that group on both servers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply