SQLTeam.com | Weblogs | Forums

Sa account


#1

My employer is setting up a new instance of SQL Server Enterprise for me. Can I be a sa user without Windows local admin rights to the machine?


#2

Yes. As long as SQL has security set to use both Windows and SQL then accessing SQL using sa does not depend on Windows.


#3

That's good news for me. Thanks


#4

Or just use Windows authetication and have your Windows account added to the sysadmin server role. No one should use sa!


#5

@TaraKizer, Good point.
@shankwheat
Any login can be assigned permissions that have nothing to do with the windows permissions other than windows allowing access to the database.