Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Enable user in sql server

I have disabled SA user and renamed it to 'sysadmin' but now i am seeing 'sysadmin' as disable user and want to enable it.I tried log in using windows authentication but not its giving me permission error while enabling 'sysadmin'.

like image 513
Pritam Avatar asked Oct 02 '22 10:10

Pritam


1 Answers

You can not enable or disable users, but can enable login related to that user.

Alter login sysadmin enable
like image 152
Amir Keshavarz Avatar answered Oct 12 '22 11:10

Amir Keshavarz