This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
This is a process I use whenever I get an "Access Denied" message. One example of this is when I do not have access to SQL Server directly, only administrative rights to the actual server.
3) Execute the following command
PsExec.exe -s -i -d CMD.exe
4) From within this new command prompt, everything you open will open as the SYSTEM account.
Viewing NT Secrets
Open Regedit.exe and you will be able to see content of HKEY_LOCAL_MACHINE\SECURITY
Opening SQL Server Management Studio as SYSTEM
Open SQL Management Studio and you will be able to log on with SYSTEM
You will be able to browse to any folder that only allows SYSTEM account
Running something like TreeSize as SYSTEM will actually give you a better view and understanding of what is using space because you will get less access denials
Using this process, (or one similar) will allow you to start processes as the SYSTEM account allowing you to access parts of files system, registry and application not accessible with normal Administrative rights.
Please do not forget to press the "Thumb's Up" button if this article was helpful and valuable for EE members.
It also provides me with positive feedback. Thank you!