Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
- How do I find hidden files taking up space?
- How to find all tables with primary key SQL Server
- How to find UDT on SQL Server columns?
- Find LOB tables with no PRIMARY KEY
- Trace flag 902 in SQL Server and Error 574
- How to find SQL Filtered Indexes
- Find SQL Server LOB Columns
Drop sysadmin with ALTER SERVER ROLE and DROP MEMBER
24 December,2014 by Tom Collins
Question: How can I delete the “sysadmin” server elevated role from a SQL Server login?
Answer: There are two standard methods to drop a sql server login from the sysadmin server role.
Method 1: Execute T-SQL.
Using the following code as a template. Apply the SQL Server Login and execute the code against the SQL Server
ALTER SERVER ROLE [sysadmin] DROP MEMBER [My Domain\My SQL Server Login] GO
Method 2: Use the SSMS GUI
To delete the alter the SQL Server login privileges.
Read More on SQL Server Security
ALTER AUTHORIZATION sql to change owner of a database
How to create a SQL Server Security Audit
Powershell sql server security audit
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |