-
How to get access on SQL Server if you don’t have “sa” password or sysadmin access?
PROBLEM DBAs need to have sysadmin access on SQL Server to support Databases effectively. There may come situations where DBAs neither have sysadmin access nor [sa] password. In that case, DBA needs to perform below activity to get the access. RESOLUTION PREREQUISITES: 1) Administrative privileges needed on Host Server. 2) Downtime of approximately 10 minutes…