https://www.tntware.com/donorhub/faqs/en/what-if-i-forget-my-sql-server-password.aspxen-USCommunityServer 2008.5 SP2 (Debug Build: 40407.4157)https://www.tntware.com/donorhub/faqs/en/what-if-i-forget-my-sql-server-password.aspxSat, 01 Jun 2019 19:51:47 GMT51c8af77-2ecd-4ae7-b5f5-4793798b888c:1Troy Wolbrinkhttps://www.tntware.com/donorhub/faqs/en/what-if-i-forget-my-sql-server-password/comments.aspxCurrent revision posted to Frequently Asked Questions by Troy Wolbrink on 6/1/2019 7:51:47 PM<br /> <h2>What if I forget my SQL Server password?</h2> <div style="font-size: 90%;">Filed under: SQL Server</div> <p><span style="text-decoration: line-through; color: red;">If</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">forget</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">password</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">there</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">s</span> <span style="text-decoration: line-through; color: red;">an</span> <span style="text-decoration: line-through; color: red;">easy</span> <span style="text-decoration: line-through; color: red;">way</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">change</span> <span style="text-decoration: line-through; color: red;">it</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">assuming</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">have</span> <span style="text-decoration: line-through; color: red;">Administrative</span> <span style="text-decoration: line-through; color: red;">privileges</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">computer</span> <span style="text-decoration: line-through; color: red;">running</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; <span style="text-decoration: line-through; color: red;">What</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">can</span> <span style="text-decoration: line-through; color: red;">do</span> <span style="text-decoration: line-through; color: red;">is</span> <span style="text-decoration: line-through; color: red;">login</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span> <span style="text-decoration: line-through; color: red;">Management</span> <span style="text-decoration: line-through; color: red;">Studio</span> <span style="text-decoration: line-through; color: red;">using</span> <span style="text-decoration: line-through; color: red;">Windows</span> <span style="text-decoration: line-through; color: red;">Authentication</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">from</span> <span style="text-decoration: line-through; color: red;">there</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">can</span> <span style="text-decoration: line-through; color: red;">change</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">password</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">something</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">can</span> <span style="text-decoration: line-through; color: red;">remember</span><p><span style="background: SpringGreen;">This</span> <span style="background: SpringGreen;">FAQ</span> <span style="background: SpringGreen;">article</span> <span style="background: SpringGreen;">has</span> <span style="background: SpringGreen;">become</span> <span style="background: SpringGreen;">obsolete</span>.</p> <p><span style="text-decoration: line-through; color: red;">If</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">Windows</span> <span style="text-decoration: line-through; color: red;">user</span> <span style="text-decoration: line-through; color: red;">account</span> &nbsp;</p> <p><span style="background: SpringGreen;">DonorHub</span> is <span style="text-decoration: line-through; color: red;">not</span> a <span style="text-decoration: line-through; color: red;">member</span> <span style="text-decoration: line-through; color: red;">of</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">Administrators</span> <span style="text-decoration: line-through; color: red;">group</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">or</span> <span style="text-decoration: line-through; color: red;">if</span> <span style="text-decoration: line-through; color: red;">you</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">re</span> <span style="text-decoration: line-through; color: red;">running</span> <span style="text-decoration: line-through; color: red;">Vista</span> <span style="text-decoration: line-through; color: red;">with</span> <span style="text-decoration: line-through; color: red;">UAC</span> <span style="text-decoration: line-through; color: red;">turned</span> <span style="text-decoration: line-through; color: red;">on</span><span style="background: SpringGreen;">fully</span> <span style="background: SpringGreen;">managed</span> <span style="background: SpringGreen;">cloud</span> <span style="background: SpringGreen;">service</span>, <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">may</span> <span style="text-decoration: line-through; color: red;">want</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">make</span> <span style="text-decoration: line-through; color: red;">sure</span> <span style="text-decoration: line-through; color: red;">you</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">re</span> <span style="text-decoration: line-through; color: red;">starting</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">program</span> <span style="text-decoration: line-through; color: red;">as</span> <span style="text-decoration: line-through; color: red;">an</span> <span style="text-decoration: line-through; color: red;">administator</span> <span style="background: SpringGreen;">hosted</span> by <span style="text-decoration: line-through; color: red;">right-clicking</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">it</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">choose</span> <span style="text-decoration: line-through; color: red;">&quot;Run</span> <span style="text-decoration: line-through; color: red;">As</span> <span style="text-decoration: line-through; color: red;">Administrator</span><span style="text-decoration: line-through; color: red;">&quot;.&nbsp;</span> <span style="text-decoration: line-through; color: red;">On</span> <span style="text-decoration: line-through; color: red;">XP</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">you</span><span style="text-decoration: line-through; color: red;">&#39;</span><span style="text-decoration: line-through; color: red;">d</span> <span style="text-decoration: line-through; color: red;">hold</span> <span style="text-decoration: line-through; color: red;">down</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">Shift</span> <span style="text-decoration: line-through; color: red;">key</span> <span style="text-decoration: line-through; color: red;">while</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">right-click</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="background: SpringGreen;">TntWare</span><span style="background: SpringGreen;">.</span></p> <p><span style="background: SpringGreen;">Let</span> <span style="background: SpringGreen;">us</span> <span style="background: SpringGreen;">know</span>&nbsp;<span style="background: SpringGreen;">if</span>&nbsp;you&#39;d <span style="text-decoration: line-through; color: red;">choose</span> <span style="text-decoration: line-through; color: red;">&quot;Run</span> <span style="text-decoration: line-through; color: red;">As</span><span style="text-decoration: line-through; color: red;">&quot;.</span></p> <p><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/6283.ssms_5F00_runas_5F00_admin.gif"><span style="text-decoration: line-through; color: red;"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/6283.ssms_5F00_runas_5F00_admin.gif" alt="" /></span></a></p> <p><span style="text-decoration: line-through; color: red;">When</span> <span style="text-decoration: line-through; color: red;">you</span> <span style="text-decoration: line-through; color: red;">login</span> <span style="text-decoration: line-through; color: red;">to</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span> <span style="text-decoration: line-through; color: red;">Management</span> <span style="text-decoration: line-through; color: red;">Studio</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">be</span> <span style="text-decoration: line-through; color: red;">sure</span> <span style="background: SpringGreen;">like</span> to <span style="text-decoration: line-through; color: red;">use</span> <span style="text-decoration: line-through; color: red;">Windows</span> <span style="text-decoration: line-through; color: red;">Authentication</span><span style="text-decoration: line-through; color: red;">.</span></p> <p><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/5488.ssms_5F00_nt_5F00_auth.gif"><span style="text-decoration: line-through; color: red;"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/5488.ssms_5F00_nt_5F00_auth.gif" alt="" /></span></a></p> <p><span style="text-decoration: line-through; color: red;">In</span> <span style="text-decoration: line-through; color: red;">SQL</span> <span style="text-decoration: line-through; color: red;">Server</span> <span style="text-decoration: line-through; color: red;">Management</span> <span style="text-decoration: line-through; color: red;">Studio</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">find</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">user</span> <span style="text-decoration: line-through; color: red;">account</span> <span style="text-decoration: line-through; color: red;">under</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">&quot;Login&quot;</span> <span style="text-decoration: line-through; color: red;">node</span><span style="text-decoration: line-through; color: red;">.</span>&nbsp; </p> <p><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/4721.ssms_5F00_logins.gif"><span style="text-decoration: line-through; color: red;"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/4721.ssms_5F00_logins.gif" alt="" /></span></a></p> <p><span style="text-decoration: line-through; color: red;">Finally</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">right-click</span> <span style="text-decoration: line-through; color: red;">on</span> <span style="text-decoration: line-through; color: red;">your</span> <span style="text-decoration: line-through; color: red;">account</span><span style="text-decoration: line-through; color: red;">,</span> <span style="text-decoration: line-through; color: red;">choose</span> <span style="text-decoration: line-through; color: red;">&quot;Properties&quot;</span> <span style="text-decoration: line-through; color: red;">and</span> <span style="text-decoration: line-through; color: red;">change</span> <span style="text-decoration: line-through; color: red;">the</span> <span style="text-decoration: line-through; color: red;">password</span><span style="text-decoration: line-through; color: red;">.</span><span style="background: SpringGreen;">learn</span> <span style="background: SpringGreen;">more</span><span style="background: SpringGreen;">:</span>&nbsp; <a href="mailto:info@tntware.com"><span style="background: SpringGreen;">info@tntware.com</span></a></p>https://www.tntware.com/donorhub/faqs/en/what-if-i-forget-my-sql-server-password/revision/1.aspxFri, 27 Feb 2009 21:10:59 GMT51c8af77-2ecd-4ae7-b5f5-4793798b888c:172Troy Wolbrinkhttps://www.tntware.com/donorhub/faqs/en/what-if-i-forget-my-sql-server-password/comments.aspxRevision 1 posted to Frequently Asked Questions by Troy Wolbrink on 2/27/2009 9:10:59 PM<br /> <p>If you forget your password, there&#39;s an easy way to change it, assuming you have Administrative privileges on the computer running SQL Server.&nbsp; What you can do is login to SQL Server Management Studio using Windows Authentication, and from there you can change your password to something you can remember.</p> <p>If your Windows user account is not a member of the Administrators group, or if you&#39;re running Vista with UAC turned on, you may want to make sure you&#39;re starting the program as an administator by right-clicking on it and choose &quot;Run As Administrator&quot;.&nbsp; On XP, you&#39;d hold down the Shift key while you right-click and you&#39;d choose &quot;Run As&quot;.</p> <p><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/6283.ssms_5F00_runas_5F00_admin.gif"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/6283.ssms_5F00_runas_5F00_admin.gif" alt="" /></a></p> <p>When you login to SQL Server Management Studio, be sure to use Windows Authentication.</p> <p><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/5488.ssms_5F00_nt_5F00_auth.gif"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/5488.ssms_5F00_nt_5F00_auth.gif" alt="" /></a></p> <p>In SQL Server Management Studio, find your user account under the &quot;Login&quot; node.&nbsp; </p> <p><a href="/tntmpd.dataserver/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/4721.ssms_5F00_logins.gif"><img border="0" src="/tntmpd.dataserver/resized-image.ashx/__size/550x0/__key/CommunityServer.Wikis.Components.Files/en/4721.ssms_5F00_logins.gif" alt="" /></a></p> <p>Finally, right-click on your account, choose &quot;Properties&quot; and change the password.</p>