locked
I am getting error message when deploy the SCCM 2012 r2 primer stand alon site RRS feed

  • Question

  • Hi Support,

    When i install Sccm 2012 r2 then getting the error message 

    SQL error message:

    https://blogs.msdn.microsoft.com/scom_2012_upgrade_process__lessons_learned_during_my_upgrade_process/2012/07/04/configuration-manager-2012-setup-error-setup-is-unable-to-connect-to-sql-server-with-the-connection-information-provided/

    I have follow same settings but getting error message.

    Please find the below SCCM Error: 

    Required SQL Server Collation         Failed
    SQL Server sysadmin rights            Failed

    

    Thursday, November 16, 2017 9:45 AM

All replies

  • What collation is used?
    Why installing CM 2012 now. CM CB is the most current Version.

    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, November 16, 2017 12:20 PM
  • Additionally, is the account you are using a local admin on the system hosti8ng the SQL instance as well as a sysadmin in that instance?

    Also, when posting information from a log file, simply extracting a couple of words or errors is almost always useless; please also post complete, relevant, and unedited snippets of the log file.

    And, as Torsten noted, ConfigMgr 2012R2 is about 4 years old now and has been superseded by ConfigMgr Current Branch.


    Jason | https://home.configmgrftw.com | @jasonsandys

    Friday, November 17, 2017 3:58 AM
  • Hi,

    "Required SQL Server Collation         Failed"

    please make sure your SQL Server Collation is "SQL_Latin1_General_CP1_CI_AS".
    Reference: https://prajwaldesai.com/sccm-prerequisite-required-sql-server-collation/.

    SQL Server sysadmin rights            Failed

    Did you use a remote SQL Server?
    If so, you need to add the SCCM computer & user account to the SQL Server local administrators group.



    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Yuxiang Shi Friday, December 1, 2017 1:38 AM
    Friday, November 17, 2017 9:12 AM