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 ...
27th August 2010, 05:16 PM #1
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?
IDG Tech News
27th August 2010, 05:25 PM #2
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?
27th August 2010, 05:57 PM #3
Add the machine account for the server accessing the remote db with full rights for one.
By beeswax in forum EduGeek Joomla 1.5 Package
Last Post: 7th April 2009, 11:18 AM
By Sylv3r in forum How do you do....it?
Last Post: 26th October 2008, 12:14 AM
By PEO in forum EduGeek Joomla 1.0 Package
Last Post: 13th May 2008, 02:23 PM
By Kyle in forum Educational Software
Last Post: 10th December 2007, 10:05 AM
By Ric_ in forum General EduGeek News/Announcements
Last Post: 20th July 2007, 08:19 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)