<div>
<div class="content wysiwyg-content">
Greetings,<br />
<br />
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.<br />
<br />
This is SQL 2014<br />
<br />
Any suggestion?<br />
<br />
Thank you,<br />
JohnD
</div>
</div>


Greetings,

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,
JohnD

SQL Server DBO access (sa)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.