Skip to content

SCCM 2007 - Remote Database Server - New Box

Featured Replies

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?

post-14550-0-21264600-1357751222_thumb.jpg

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.

  • Author

I just actually tested it before I read your reply. No dice, it need that access. Thanks Garth.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.