{"id":2193,"date":"2016-09-13T16:42:31","date_gmt":"2016-09-13T16:42:31","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=2193"},"modified":"2018-09-05T04:10:27","modified_gmt":"2018-09-05T04:10:27","slug":"reset-sql-server-sa-password-with-account-without-sufficient-privileges","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/fixes\/reset-sql-server-sa-password-with-account-without-sufficient-privileges","title":{"rendered":"Reset SQL Server SA password with account without sufficient privileges"},"content":{"rendered":"

One Way without Restart Service<\/h2>

I\u2019ve come across a great way of resetting a SQL server \u201csa\u201d password if you don\u2019t have it, don\u2019t have an account with sufficient privileges to reset it via SSMS, and most importantly, don\u2019t have to stop the SQL services so processing can continue.\"fkgqx81huis863c-medium1\"<\/p>

All you will need is psexec \u00a0(in the sysinternals \u00a0toolkit) available here \u00e0 https:\/\/technet.microsoft.com\/en-us\/sysinternals\/pxexec.aspx<\/a><\/p>

Once the tools are extracted to a directory on the server:<\/p>

Psexec.exe \u2013s \u2013i \u201c{full path to the ssms.exe\u201d}<\/strong><\/p>

This will start the SQL Management Studio as the NTSERVICE\\SYSTEM account \u2026 enter the name of the SQL Server (or localhost) and then you\u2019re in \u2026 reset the sa password in there<\/p>

 <\/p>

Another way<\/h2>

 <\/p>

  1. Stop SQL Server Service<\/li>
  2. Start is with\u00a0
    net start MSSQLSERVER \/m\"SQLCMD\"<\/code><\/pre><\/li>
  3. sqlcmd -SServerName\\InstanceName<\/code><\/pre><\/li>
  4. CREATE LOGIN RecoveryAcct WITH PASSWORD=\u2019TempPass1\u2019
    GO
    <\/code><\/pre><\/li>
  5. SP_ADDSRVROLEMEMBER RecoveryAcct,SYSADMIN<\/code>
    GO<\/pre>
    <\/code><\/pre>This was on Microsoft SQL Server 2008 (SP2) – 10.0.4067.0 (X64). 
    \u00a0<\/pre><\/li><\/ol>","protected":false},"excerpt":{"rendered":"
    One Way without Restart ServiceI\u2019ve come across a great way of resetting a SQL server \u201csa\u201d password if you don\u2019t have it, don\u2019t have an account with […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[1595,673,1593,1591,1592,1594],"class_list":["post-2193","post","type-post","status-publish","format-standard","hentry","category-fixes","tag-ntservicesystem","tag-permissions","tag-psxec","tag-reset-sql-password","tag-sa","tag-system"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t