Default SA password

Question

Default SA password

asheesh pandey

Old Hand

Points: 359
More actions
August 8, 2012 at 9:55 am

#279940

Hi Guys,
Is there a default SA password in SQL server ?
if any body know then please share me.
because after installation i have to tried some password but it's not working.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Default password is blank password.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

There is no default, and a blank is not allowed in recent versions of SQL Server without someone checking a box to say they want one.

If you connect as a local administrator, you might be able to reset it. Alternatively, you can restart SQL Server in single user mode, and connect as a local administrator from the local console.

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 3

If you have a process logging in as sa, then for pre-2012 versions you'll be able to lift the sa password from the Win32 MSSQLSERVER (or your named instance) memory by using a debugger, as it's stored in plaintext.

Download the debugger of your choice, attach it to the MSSQLSERVER process, search for the Unicode string 'sa' (without quotes) and you'll find the password right next to it.

WARNING: Attaching the debugger to the service will prevent inbound connections from connecting to SQL Server and could cause issues from outages to corruption. Do this on development only!

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Lowell SSC Guru Points: 323518 More actions · Answer 4

much easier to just reset teh password, i think

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!