Endpoint Protection

 View Only

  • 1.  Why does the initial install of SEP 14 need SQL SA access?

    Posted Jul 17, 2017 02:26 PM

    I'm in the process of setting up my production SEPM 14 infrastructure, and when requesting a new back-end SQL DB, I received push back from our DBA's asking what "exactly" the installer was doing that required SA access.

    Before I put in a support case to ask this question, I was hoping someone in the forum could offer some insight...or point me toward a document that would have this information.

    From what our DBA told me, some vendors make configuration changes to the server that could affect other databases that share the same server. His goal is to understand what the SEPM 14 installer is doing to prevent this from happening.

    Thanks for any thoughts,

    -Mike



  • 2.  RE: Why does the initial install of SEP 14 need SQL SA access?

    Posted Jul 17, 2017 02:29 PM

    I believe this changed with SEP 14 MP2 in that it no longer needs sa.

    I saw this with 14 RTM and 14 MP1 but there was a post on here a few weeks back asking the same question and someone found that it no longer needs sa with 14 MP2. I'll try to find it.



  • 3.  RE: Why does the initial install of SEP 14 need SQL SA access?

    Posted Jul 17, 2017 02:33 PM

    Umm, well looks like it was you :)

    https://www.symantec.com/connect/forums/sep-upgrade-sql-server-sa-account#comment-11851631



  • 4.  RE: Why does the initial install of SEP 14 need SQL SA access?

    Posted Jul 17, 2017 02:34 PM

    Thanks for the reply Brian. My understanding from that post a few weeks ago was that MP2 did not need SA when upgrading from a previous version, but the initial install (a fresh copy of MP2) did.



  • 5.  RE: Why does the initial install of SEP 14 need SQL SA access?

    Posted Jul 17, 2017 02:36 PM

    I've always wondered the same and our DBAs always question it but since the install fails without it, they reluctantly give access for the install and remove as soon as it's done. Frankly, I don't know if you'll get an exact answer on here or even from outside of back line or dev support.



  • 6.  RE: Why does the initial install of SEP 14 need SQL SA access?

    Posted Jul 17, 2017 02:42 PM

    I've always wondered the same and our DBAs always question it but since the install fails without it, they reluctantly give access for the install and remove as soon as it's done. Frankly, I don't know if you'll get an exact answer on here or even from outside of back line or dev support.

    Yeah, I told the DBA the same thing, but due diligence required that I at least try. If all else fails, we can always install to a fresh instance, and then monitor the instance for a couple weeks to see if Symantec is "helping" us doing any maintenance tasks.

    As always, thanks for your input!

    Anyone else have any other information to share??