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?
Yes. As long as SQL has security set to use both Windows and SQL then accessing SQL using sa does not depend on Windows.
That's good news for me. Thanks
Or just use Windows authetication and have your Windows account added to the sysadmin server role. No one should use sa!
@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.