none
What Secuirty Requirements on SQL Server does DPM 2010 have if any? RRS feed

  • Question

  • I've tried my best to find any info on what security requirement if any DPM2010 has with regards to SQL Server 2008.  Specifically does it require SQL Server Authentication Mode to be set to INTEGRATED (WIndows Security Only) or does it not mater?

     

    I ask because our DPM setp (sone by someone else) is set tINTEGRATED SECURITY only and it will not let me reset it to Mixed Mode and I do have admin priveledges.  While waiting to hear back from our DPM guy I thought I;d check here first in case he himself doesnt know. It looks like DPM was setup with its only instance of SQL Server since its using a Named instance fo SQL Server.

     

    Thanks

    Tuesday, September 21, 2010 5:09 PM

Answers

All replies

  • If DPM has been installed with a local instance, then the settings are determined by the setup.

    This is a pretty tight installation so you probably won't have the rights to change the authentication mode of that instance.

    It is not because you are an admin, that you have admin rights on the SQL server.  You can login with the dedicated DPM account, specified during setup to change SQL settings if you want, but in the end, why do you want to reset it to mixed mode?

    Just my 2 cents,

    Mike Resseler

     


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Tuesday, September 21, 2010 6:34 PM
    Moderator
  • Mike,

    Thanks for the asnwer.   Do you know if the security mode is a Requirement for DPM?  The IntegratedOnly security mode is the default for SQL Server installs but that doesn't mean the application that insatleld SQL Server for its use requires this.

     

    Why change it?  Thats our procedure.  We set the Authentication to Mixed Mode, setup or own sa like account and disable the regular sa account.

     

    Thanks

    Tuesday, September 21, 2010 7:38 PM
  • Hey,

    I'm not sure but according to this article, it need to be authenticated... http://technet.microsoft.com/en-us/library/ff399612.aspx

    Brgds,

    Mike


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    • Proposed as answer by MarcReynoldsModerator Thursday, September 23, 2010 12:28 PM
    • Marked as answer by YSLGuru Thursday, September 23, 2010 3:07 PM
    Tuesday, September 21, 2010 7:43 PM
    Moderator
  • Thanks, that item was exactly what I needed.
    Thursday, September 23, 2010 3:07 PM