Lost sa Password

[belthurgp]

Can somebody help me figuring out how to get my data back ?

 

[Riku]

Read following page:

http://www.pinnaclepublishing.com/sq/SQMag.nsf/0/92D49771A5DD03D78525694C00620C93?opendocument

F: Riku Tuominen
riku.tuominen@benchmarking.fi

 

[Riku]

I found this on Internet also.

Forgot or lost your sa password? Don't worry, there is a way out

Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password:

sp_password @new = 'will_never_forget_again', @loginame = 'sa' F: Riku Tuominen
riku.tuominen@benchmarking.fi

 

[Riku]

If that does not work try this!

http://www.isug.com/Sybase_FAQ/ASE/section1.1.html#1.1.14

F: Riku Tuominen
riku.tuominen@benchmarking.fi

 

[tlbroadbent]

Riku,

Do you realize that you are replying to a two year-old post? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Riku]

No
I thougt less that a month.
That was funny .

Well maybe someone having same problem find this thread.

F: Riku Tuominen
riku.tuominen@benchmarking.fi

 

[forecasting]

Riku,

I enjoyed the tip... and all the laughs you provided!

 

[Riku]

Thanks forecasting!
Now I know where to find the resolution if I some day forget my SQL server sa password.
F: Riku Tuominen
riku.tuominen@benchmarking.fi