Re: 'sa' password
From: Tom Moreau (tom@dont.spam.me.cips.ca)
Date: 09/06/02
- Next message: Oren: "Is it a mistake ?"
- Previous message: Praetorian Guard: "Link Server"
- In reply to: iKc: "'sa' password"
- Next in thread: K. Brian Kelley: "Re: 'sa' password"
- Reply: K. Brian Kelley: "Re: 'sa' password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Tom Moreau" <tom@dont.spam.me.cips.ca> Date: Fri, 6 Sep 2002 09:20:57 -0400
The sa password is encrypted, so if you forgot it, you won't be able to get it back. That's what security is all about. You can, however, change it to something you do know. You will have to connect through another login that belongs to the sysadmin role. If you haven't already removed the BUILTIN\Administrators group, then you can login into the server as an administrator and use Windows authentication to connect.
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql www.apress.com "iKc" <pruello@tibco.fr> wrote in message news:unVhqpYVCHA.2540@tkmsftngp09... Hi, I don't remember the password of my 'sa' user (Hopefully I still can login as BUILTIN\Admin). I only see it in binary format. Is there a way to find it? I want to keep it and I don't want to put it as NULL. Is there a way to find again my 'sa' password? Thks.
- Next message: Oren: "Is it a mistake ?"
- Previous message: Praetorian Guard: "Link Server"
- In reply to: iKc: "'sa' password"
- Next in thread: K. Brian Kelley: "Re: 'sa' password"
- Reply: K. Brian Kelley: "Re: 'sa' password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
