Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: local administrator

Locked out from SQL Server?

When you install SQL Server, you need to specify what account(s) or group(s) that you want to give administrative privileges. Way back when, it would be sufficient to be a local administrator on the Windows machine running the SQL Server service, but not any more.

Luckily, there’s a solution.

Continue reading Locked out from SQL Server?
Published 2013-03-24
Categorized as Intermediate, SQL Server concepts, SQL Server security Tagged -m, admin, create login, local administrator, single user mode, sp_addsrvrolmember, sqlcmd, sqlservr.exe, sysadmin
sqlsunday.com
Proudly powered by WordPress.