locked
can non-sysadmin upgrade SQL server? RRS feed

  • Question

  • I wonder if non-sysadmin (SQL) can actually upgrade SQL server (database engine, SSIS and SSRS).  Can this be possible.

    Thanks much!

    Thursday, January 15, 2015 7:57 PM

Answers

  • You should have sysadmin permissions to upgrade SQL server...

    Raju Rasagounder Sr MSSQL DBA

    • Marked as answer by BrianKang Thursday, January 15, 2015 8:37 PM
    Thursday, January 15, 2015 8:33 PM

All replies

  • You should have sysadmin permissions to upgrade SQL server...

    Raju Rasagounder Sr MSSQL DBA

    • Marked as answer by BrianKang Thursday, January 15, 2015 8:37 PM
    Thursday, January 15, 2015 8:33 PM
  • got it, that's what I though.  Thanks for your answer!

    Thursday, January 15, 2015 8:38 PM
  • Well, I'm not sure if anyone interested but I was wondering about this so tested it out.  Actually, sysadmin was NOT required for upgrade.  I was able to upgrade SQL 2008 to SQL 2012 even without a SQL login.

    Just a FYI.

    Friday, January 16, 2015 9:05 PM