Sunday, 11 May 2014

How to troubleshoot when all Login Removed No Admin Rights

No Admin right for User and sa is disable
1) sa is disable
2) Windows user [Domainname\ashish.malwal] don’t have access to create any table or database it has public role.














How to get backup sys admin right and how to give sys admin right to user?
Steps:-

1.       net stop "SQL Server (MSSQLSERVER)"
2.       net start "SQL Server (MSSQLSERVER)" /m  ---single user mode
1.       sp_addsrvrolemember [Domainname\ashish.malwal],sysadmin ----Give sys admin right existing user
2.       alter login sa enable ---enable sa  login if disable




Now check SSMS and try to create table:-




No comments:

Post a Comment