+ Post New Thread
Results 1 to 3 of 3
O/S Deployment Thread, moving sccm database to remote machine in Technical; Due to a series of misadventures i have had to move my sccm database to a remote machine (although not ...
  1. #1

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,753
    Thank Post
    1,279
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506

    moving sccm database to remote machine

    Due to a series of misadventures i have had to move my sccm database to a remote machine (although not good practice i had to simply copy the database files and attach them to the new sql server).
    I have tried to reconfigure the sccm site to use the new location but it can't access the sql db. I guess that this is a permission issue as although the user account that sccm uses has access rights for the db, the actual sql server only has local accounts configured with login rights.
    I tried giving the sccm account login rights for the sql server but that didn't work. So what account do i need to add to make this work?

    Cheers.

  2. #2

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,753
    Thank Post
    1,279
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506
    Mmm just read that the site server needs to have admin privileges over the sql machine. Will try that.

    In the meantime, anyone think of anything else i should watch out for?

  3. #3

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,709
    Thank Post
    906
    Thanked 1,322 Times in 803 Posts
    Blog Entries
    1
    Rep Power
    445
    Add the machine account for the server accessing the remote db with full rights for one.

SHARE:
+ Post New Thread

Similar Threads

  1. Moving site to another machine
    By beeswax in forum EduGeek Joomla 1.5 Package
    Replies: 3
    Last Post: 7th April 2009, 11:18 AM
  2. Moving a Sharepoint database
    By Sylv3r in forum How do you do....it?
    Replies: 11
    Last Post: 26th October 2008, 12:14 AM
  3. website running slow from remote machine
    By PEO in forum EduGeek Joomla 1.0 Package
    Replies: 5
    Last Post: 13th May 2008, 02:23 PM
  4. Moving Sleuth database to another server.
    By Kyle in forum Educational Software
    Replies: 0
    Last Post: 10th December 2007, 10:05 AM
  5. Moving the EduGeek Database
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 28
    Last Post: 20th July 2007, 08:19 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •