SSMS Permission Denied, Login with Windows Authentication My SSMS(SQL Server Management Studio) version 16.4, Windows 7. First install is normal use, sometimes i reinstalling my Windows and just now i install SSMS again, and got this problem.
I cannot do anything except view.

Object Explorer &amp; Registered Servers Display




BUILTIN\Users (ServerRole: Public) > using windows authentication
sa (ServerRole: Public, Sysadmin) > SQL Server Authentication (with default password)


I cannot create any database, restore or anything that change the content of my server. Also i have try to Add new login, and i don't have permission to create new login. I run the SSMS as Administrator, but i still cannot do anything.

Anyone know how to add new logins from out of application. Maybe i can connect to Server with SQL Server Authentication that have all permission that required. Or any way to solve this permission problem.

Thanks

Attach Database -> Add



Restore Database



Try something to do


Error when add ServerRole to my BUILTIN\Users


Connection Properties if needed.
You are just a member of BUILTIN/Users when connecting to SQL Server, your USER\Administrator is not a member of sysadmin role, so you have no server permissions. Try to execute

select * 
from sys.fn_my_permissions(null, 'server');


and all you see will be CONNECT SQL + VIEW ANY DATABASE.
Of course you cannot use DAC, you are NOT sysadmin to be able to do it.

What you should do instead is launch your server in single user mode, and as you are local admin, you'll be able to log in as sysadmin.
After that you should add yourself to sysadmin role.

Here are the steps to perform: Connect to SQL Server When System Administrators Are Locked Out