Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shekhar_dba
Starting Member
39 Posts |
 Posted - 2006-10-30 : 13:51:42
|
| Hi guru'sI m in very critical position so please help me out for this .... actually i forgot SA pwd of one of our production server. i m working with SQL SERVER 2005. Is there a way to reset or to make access of server?plz help me ....thanks shekhar |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-30 : 13:56:21
|
| Log in to the server using Windows Authentication, using a login that is an administrator for that server. Once logged in you can change the sa password. You can't recover the password though, you'd have to change it. |
 |
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-10-30 : 13:59:46
|
| Hi i m using that server through RDC (remote desktop connection) that server is handle by us as remote server, so i cant be able to login in window authentication mode. please tell me ant other way .... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-30 : 14:08:51
|
| Of course you can login as local windows administrator with RDC.Are you asking us to participate in something illegal?Peter LarssonHelsingborg, Sweden |
|
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-10-30 : 15:31:09
|
| Hi thanku u all alot .... my problem is solved with the use of windows auth mode ... as i have admin PWD.. :)thank u all once again for all ur supportthanks shekhar |
|
|
|
|
|
|
forgot PWD for SA