Start SQL Server Management Studio (SSMS) Or connect to SQL Server using NT Authority\ System
Recently we have faced a problem where sysadmin access for
all of our accounts were removed accidently and SA was in disabled state.
Later we have noticed that one of the possible solution to
this case is to connect SQL Server using NT Authority\System as this is default
user till SQL Server 2008 R2 who will have sysadmin access on DB instance. From
SQL Server 2012 onwards NT Authority\System user will not have sysadmin access
and this article might not help. Below are quick steps to connect SSMS using NT
Authority\System:
1. Download PS tools from below link:
2. Extract them to a folder.
3. Right click on CMD and run as administrator.
4. Navigate to folder where you have extracted zip file downloaded
part of above link.
5. Run below command to start SSMS using NT Authority\System
user
psexec -i -s SSMS
Done you should be able to access DB instance and provide
access to the users you need. Hope this helps someone as it did to me.
No comments:
Post a Comment