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
No comments:
Post a Comment