Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    285
    Provided Answers: 1

    Unanswered: SCCM 2012 SQL Server Authentication Mode

    Good day,

    Can someone please help me or direct me.

    On the SCCM 2012 requirements page for SQL Server Requirements it says the following:
    Windows Authentication Configuration Manager requires Windows authentication to validate connections to the database.

    Unfortunately I don't have full access to this server so can't change the permissions but surely this does not mean that Mixed Mode is not allowed, after all Mixed mode allows both Windows Authentication and SQL Server Authentication.

    Please can I have some input into this?

    Thank you.

  2. #2
    Join Date
    Dec 2012
    Posts
    6
    You can use sql in mixed mode, the sccm installer will give you a warning. However, I would recommend you install the sccm db on its own Sql box and use that as your reporting point also. Sccm needs local admin access to sql box,I believe.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It means that the machine running SCCM has to be able to use Windows Authentication to connect to the SQL Server. SCCM can not use SQL Authentication, but it doesn't care what other tools use to authenticate.

    Pure FWIW, but I would only use SCCM with a SQL Server that was tightly secured. For data as sensitive as SCCM handles, I would not choose a shared SQL Server that had other databases or SQL Authentication on it.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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