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 & Registered Servers Display
- BUILTINUsers (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