shawn.pederson Posted January 9, 2013 Report post Posted January 9, 2013 We have our SCCM environment primarily running on one server with the SQL DB living remotely. Infrastructure guys want to move the database box from one physical device to another (with the same name). I will be referring to this documentand this one. I am curious as too the permissions required to run the sms_site_sql_backup service . I know the computer account needs to be a local administrator to install it as a site server. But I am curious as to whether it needs to remain a local administrator for any future jobs after placing it's hooks. So in summary, I understand the SCCM server wants to be a local administrator for the install of a remote database site. But I am wondering if that access can be reduced after the database site server is setup? Anyone think of any "got chas" with migrating to a different physical server with the same name? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted January 10, 2013 Report post Posted January 10, 2013 CM07 server must be administrator on the remote server always, otherwise your backup will not work. This is one of the reason why I NEVER recommend remote SQL. 1 Quote Share this post Link to post Share on other sites More sharing options...
shawn.pederson Posted January 10, 2013 Report post Posted January 10, 2013 I just actually tested it before I read your reply. No dice, it need that access. Thanks Garth. Quote Share this post Link to post Share on other sites More sharing options...
