{"id":785,"date":"2012-06-22T10:34:14","date_gmt":"2012-06-22T14:34:14","guid":{"rendered":"http:\/\/www.pressleypress.com\/blog\/?p=785"},"modified":"2012-06-22T10:34:14","modified_gmt":"2012-06-22T14:34:14","slug":"reset-sa-password-using-sqlcmd","status":"publish","type":"post","link":"https:\/\/www.pressleypress.com\/blog\/?p=785","title":{"rendered":"Reset SA Password Using sqlcmd"},"content":{"rendered":"

Resetting the SA password<\/p>\n

If you need access to the database, you can reset the SA password using the following commands from a command prompt (cmd):<\/p>\n

sqlcmd \u2013S SQLSERVER\\INSTANCE<\/p>\n

Once in the interface for sqlcmd, which is represented by a 1>, type the following on separate lines:<\/p>\n

sp_password @new = \u2019newpassword\u2019, @loginame = \u2018sa\u2019
\n go
\n exit<\/p>\n

Just so you know, the @loginame procedure does have only one \u201cn\u201d.
\nUnlocking the SA user<\/p>\n

If you have tried to access the database too many times with the wrong password, the SA account may be locked out. Do the following to unlock the account from a command prompt (cmd):<\/p>\n

sqlcmd \u2013S SQLSERVER\\INSTANCE<\/p>\n

Once in the interface for sqlcmd, which is represented by a 1>, type the following on separate lines:<\/p>\n

ALTER LOGIN sa WITH PASSWORD = \u2018newpassword\u2019 UNLOCK
\n go
\n exit<\/p>\n

Full Article HERE<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Resetting the SA password If you need access to the database, you can reset the SA password using the following commands from a command prompt (cmd): sqlcmd \u2013S SQLSERVER\\INSTANCE Once in the interface for sqlcmd, …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-785","post","type-post","status-publish","format-standard","hentry","category-computers"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p32FB4-cF","jetpack-related-posts":[{"id":1720,"url":"https:\/\/www.pressleypress.com\/blog\/?p=1720","url_meta":{"origin":785,"position":0},"title":"Enable Administrator Login in Windows 11","author":"Matt","date":"February 19, 2025","format":false,"excerpt":"Did you accidentally lock your administrator login by attempting the wrong password too many times? Do you need to re-enable the account, and reset the password? Try the following : Hold SHIFT and click the power icon on the lock screen. Continue holding SHIFT and click on \"Restart\". This will\u2026","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":793,"url":"https:\/\/www.pressleypress.com\/blog\/?p=793","url_meta":{"origin":785,"position":1},"title":"SOAPUI Oracle Thin Client Format","author":"Matt","date":"October 3, 2012","format":false,"excerpt":"jdbc:oracle:thin:{schema name}\/{password}@{hostname}:1521:{instance name}","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69,"url":"https:\/\/www.pressleypress.com\/blog\/?p=69","url_meta":{"origin":785,"position":2},"title":"Microsoft – Still Doesn’t Get Security","author":"Matt","date":"February 14, 2007","format":false,"excerpt":"From the ZDNet Article: \"Joanna Rutkowska has always been a big supporter of the Windows Vista security model. Until she stumbled upon a \"very severe hole\" in the design of UAC (User Account Control) and found out \u00e2\u20ac\u201d from Microsoft officials \u00e2\u20ac\u201d that the default no-admin setting isn't even a\u2026","rel":"","context":"In "Computers"","block_context":{"text":"Computers","link":"https:\/\/www.pressleypress.com\/blog\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1333,"url":"https:\/\/www.pressleypress.com\/blog\/?p=1333","url_meta":{"origin":785,"position":3},"title":"Linking a Local Folder with Microsoft’s One Drive","author":"Matt","date":"October 21, 2018","format":false,"excerpt":"You may want to sync a folder on your computer with OneDrive that isn't one of the Windows standard C: drive folders like \"Documents\", \"Pictures\" etc. If that's the case, here's the command line for you to use to link any folder with OneDrive. mklink \/j \"