Skip to main content
Database Administrators

Return to Answer

Updated link; improved formatting
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

Based on the comments, you'veYou've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.

That post explains how to impersonate the NT AUTHORITY\SYSTEMNT AUTHORITY\SYSTEM login using PsExec PsExec (or creating a Windows Scheduled Task running under the SYSTEMSYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.

Based on the comments, you've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

That post explains how to impersonate the NT AUTHORITY\SYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.

You've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.

See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.

That post explains how to impersonate the NT AUTHORITY\SYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.

Source Link
Brent Ozar
Brent Ozar
  • 43.2k
  • 47
  • 226
  • 382

Based on the comments, you've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

That post explains how to impersonate the NT AUTHORITY\SYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.