reset sa password

If you can not connect via sa and you have removed
the 'builtin\administrators' account, you are going to be
out-of-luck.
It seems that you have to re-install and get your db's
back from backups.
hth
DeeJay
>--Original Message--
>Hi,
>Is there is a method to reset the 'sa' password? I have a
>server that moved between few different domains and I am
>not sure which domain accounts have access to it. And We
>do not know the 'sa' password.
>I thought there was a registry key that could be removed
>to reset the password? Is that possible?
>Thanks,
>.
>
Well, you should be able to shut SQL Server down gracefully from the
Services control panel applet, so you might only have to re-attach your
existing MDF/LDF files after you reinstall.
http://www.aspfaq.com/
(Reverse address to reply.)
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:c99901c48a0b$49ccfa20$a601280a@.phx.gbl...[vbcol=seagreen]
> If you can not connect via sa and you have removed
> the 'builtin\administrators' account, you are going to be
> out-of-luck.
> It seems that you have to re-install and get your db's
> back from backups.
> hth
> DeeJay
|||> It seems that you have to re-install and get your db's
> back from backups.
Or rebuildm.exe, which is essentially a reinstall without the file-copy phase... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message news:c99901c48a0b$49ccfa20$a601280a@.phx.gbl...[vbcol=seagreen]
> If you can not connect via sa and you have removed
> the 'builtin\administrators' account, you are going to be
> out-of-luck.
> It seems that you have to re-install and get your db's
> back from backups.
> hth
> DeeJay
|||I thought the db's have to detached to be re-attached?
Also, attaching the db's is not going to help resolve
the 'sa' password. But it will keep downtime to minimum,
if he/she is able to attach the db's.
DeeJay
>--Original Message--
>Well, you should be able to shut SQL Server down
gracefully from the
>Services control panel applet, so you might only have to
re-attach your[vbcol=seagreen]
>existing MDF/LDF files after you reinstall.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
>news:c99901c48a0b$49ccfa20$a601280a@.phx.gbl...
be[vbcol=seagreen]
have a[vbcol=seagreen]
am[vbcol=seagreen]
We[vbcol=seagreen]
removed
>
>.
>
|||> I thought the db's have to detached to be re-attached?
In many cases, attaching work even if you didn't detach first. But you are right in saying that this is *not*
something to count on.

> Also, attaching the db's is not going to help resolve
> the 'sa' password.
It depends on which database we are talking about.
Sa is a login, stored in master.
You can rebuild the master database.
You now have a known password for sa.
And just attach the user databases.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message news:c90f01c48a20$9de73b60$a401280a@.phx.gbl...[vbcol=seagreen]
> I thought the db's have to detached to be re-attached?
> Also, attaching the db's is not going to help resolve
> the 'sa' password. But it will keep downtime to minimum,
> if he/she is able to attach the db's.
> DeeJay
> gracefully from the
> re-attach your
> be
> have a
> am
> We
> removed
|||That's true. I assumed we are talking about user databases
because its generally not a good idea to detach and attach
the system databases to a different server, is it?
Also, I was not sure what rebuilding the master db do the
sa login. Once the master db is rebuilt, what is the
password for 'sa'? blank? or initial password used during
sw installation?
DeeJay
>--Original Message--
>In many cases, attaching work even if you didn't detach
first. But you are right in saying that this is *not*
>something to count on.
>
>It depends on which database we are talking about.
>Sa is a login, stored in master.
>You can rebuild the master database.
>You now have a known password for sa.
>And just attach the user databases.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:c90f01c48a20$9de73b60$a401280a@.phx.gbl...[vbcol=seagreen]
to[vbcol=seagreen]
to[vbcol=seagreen]
db's[vbcol=seagreen]
I[vbcol=seagreen]
And
>
>.
>
|||> I thought the db's have to detached to be re-attached?
I'm pretty sure that if SQL Server is allowed to be shut down successfully,
that the files will be detached successfully. No guarantee, of course, but
it has worked in all cases where I tried it.

> Also, attaching the db's is not going to help resolve
> the 'sa' password.
No, and that's not why I mentioned it. I was only commenting on the
"re-install and get your db's back from backups" comment.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Sounds Good!

>--Original Message--
>I'm pretty sure that if SQL Server is allowed to be shut
down successfully,
>that the files will be detached successfully. No
guarantee, of course, but
>it has worked in all cases where I tried it.
>
>No, and that's not why I mentioned it. I was only
commenting on the
>"re-install and get your db's back from backups" comment.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>
sql