Answered by:
sysadmin rights for a computer account

Question
-
Hi,
I am using SCCM 2012 R2
I am installing a secondary site which site server uses a previously installed SQL Server. (http://technet.microsoft.com/en-us/library/gg712320.aspx#BKMK_InstallSecondarySite)
I need the procedure for the following:
- The computer account of the parent primary site must have sysadmin rights on the instance of SQL Server on the secondary site server computer.
There is no computer objects at New Login in SQL:
- The Local System account of the secondary site server computer must have sysadmin rights on the instance of SQL Server on the secondary site server computer.
There is no local system at New Login in SQL:
Thanks in advance!
Tuesday, October 14, 2014 12:47 AM
Answers
-
Execute a SQL Query for this
CREATE LOGIN [MyDomain\MyComputer$] FROM WINDOWS;
This will create the SQL account. Then give this account Sysadmin rights.
Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson
- Proposed as answer by Joyce L Wednesday, October 15, 2014 1:13 AM
- Marked as answer by SCCMadmin09 Wednesday, October 15, 2014 9:54 PM
Tuesday, October 14, 2014 6:33 AM -
You can use also "nt authority\system" when using the GUI.
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Joyce L Wednesday, October 15, 2014 1:13 AM
- Marked as answer by SCCMadmin09 Wednesday, October 15, 2014 9:54 PM
Tuesday, October 14, 2014 7:35 AM
All replies
-
Execute a SQL Query for this
CREATE LOGIN [MyDomain\MyComputer$] FROM WINDOWS;
This will create the SQL account. Then give this account Sysadmin rights.
Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson
- Proposed as answer by Joyce L Wednesday, October 15, 2014 1:13 AM
- Marked as answer by SCCMadmin09 Wednesday, October 15, 2014 9:54 PM
Tuesday, October 14, 2014 6:33 AM -
You can use also "nt authority\system" when using the GUI.
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Joyce L Wednesday, October 15, 2014 1:13 AM
- Marked as answer by SCCMadmin09 Wednesday, October 15, 2014 9:54 PM
Tuesday, October 14, 2014 7:35 AM -
Thanks Torsten for your valuable help.Wednesday, October 15, 2014 9:53 PM
-
Thanks Gerry for your valuable help.Wednesday, October 15, 2014 9:54 PM