SQL Server 11.0.3 sa password

[Supernn]

Hi,

we have an SQL Server vs.11.0.3 but the administrator who installed the system (and who has the sa password) is dissapeared. Does anybody know if there is a tool ($) which can locate the sa password?

 

[netrider]

You don't need a tool, just edit the run_sqlservername.bat file in the install folder. Add the -PSA option somewhere in the command line. Open a command prompt and start your sql server from the command line run_sqlservername.bat
You will see a new sa password ramdomly generated.

 

[netrider]

Buddy
You don't need a tool, just edit the run_sqlservername.bat file in the install folder. Add the -PSA option somewhere in the command line. Open a command prompt and start your sql server from the command line run_sqlservername.bat
You will see a new sa password ramdomly generated.

Netrider

 

[Supernn]

I've tried this and got an error: kdconfig: unable to read primairy master device / kdconfig: read of config block failed.

 

[Supernn]

OK, I hadn't shut down the server first.
We have to administer this database, and I cannot find the password, which should be randomly generated in either the errorlog or in the dosbox itself.

 

[netrider]

Try -psa NOT in CAPITAL, you see the password in the dosbox but you need to increase the screen buffer size, else it might scroll up too fast