Security

SQLServerCentral Article

Removing NT Administrators as Sysadmins

  • Article

By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.

1 (1)

2001-05-25

4,043 reads

Blogs

Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning

By

Join us on December 8th at 10am Pacific time for an exciting new webinar!...

Daily Coping 3 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 2 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Foreign key in the column values of another table

By teb

I have trouble in writing a SQL query. I have a data table with...

How to increase performance to load a factless date-date-interval table

By svenflock

Hi all, I am currently having performance issues by populating one of my factless...

Linked Server Error

By dhara

Hi Experts, I am getting the following error when i am trying to test...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers