Avatar of John Darby
John Darby
Flag for United States of America

asked on 

SQL Server DBO access (sa)


I inherited a SQL Server with a DB that noone has the sa password or DBO access. I am being asked to give one of our devs access, which I did to my own level f access, but I discovered noone has the sa password nor is anyone allocated the DBO perm level. My predecessor is long gone and I don't know how to change the SA password to something new or how to elevate privs for myself or my dev.

This is SQL 2014

Any suggestion?

Thank you,
Microsoft SQL Server

Avatar of undefined
Last Comment
John Darby

8/22/2022 - Mon