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,
If you log onto the server with a different system admin user, or a
local/domain windows administrator, you can use master..sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:53e001c48a07$3ad358b0$a301280a@.phx.gbl...
> 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,
|||anonymous@.discussions.microsoft.com wrote:
> 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,
You need to connect using another admin account and then reset the
password on the "sa" account. If you do not have any other admin
accounts, I don't think you can reset the password. You may have to
reinstall SQL Server and restore/reattach your databases.
David G.
|||I lost my password for sa. So, I do the following, but it doesn't seem to
work.
1) I login to SQL Server thru the query analyzer using Windows
Authentication.
2) sp_password NULL, 'password', 'sa'
3) It indicates with "Password changed"
4) I log out from the query analyzer.
5) I try login to SQL Server thru query analyzer using SQL Server
authentication.
6) It indicates with a login error, and it says "Reason: Not associated
with a trusted SQL Server connection.
Does anyone shine some light?
Thanks.
J
"Aaron [SQL Server MVP]" wrote:
> If you log onto the server with a different system admin user, or a
> local/domain windows administrator, you can use master..sp_password.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:53e001c48a07$3ad358b0$a301280a@.phx.gbl...
>
>
|||Already answered in another thread...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"thejackofall" <thejackofall@.discussions.microsoft.com> wrote in message
news:05AFF2D7-8F2A-4D75-9A0F-83DFB40E17CF@.microsoft.com...[vbcol=seagreen]
> I lost my password for sa. So, I do the following, but it doesn't seem to
> work.
> 1) I login to SQL Server thru the query analyzer using Windows
> Authentication.
> 2) sp_password NULL, 'password', 'sa'
> 3) It indicates with "Password changed"
> 4) I log out from the query analyzer.
> 5) I try login to SQL Server thru query analyzer using SQL Server
> authentication.
> 6) It indicates with a login error, and it says "Reason: Not associated
> with a trusted SQL Server connection.
> Does anyone shine some light?
> Thanks.
> J
> "Aaron [SQL Server MVP]" wrote:
Showing posts with label amnot. Show all posts
Showing posts with label amnot. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
reset sa password
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,If you log onto the server with a different system admin user, or a
local/domain windows administrator, you can use master..sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:53e001c48a07$3ad358b0$a301280a@.phx.gbl...
> 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,|||anonymous@.discussions.microsoft.com wrote:
> 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,
You need to connect using another admin account and then reset the
password on the "sa" account. If you do not have any other admin
accounts, I don't think you can reset the password. You may have to
reinstall SQL Server and restore/reattach your databases.
David G.|||I lost my password for sa. So, I do the following, but it doesn't seem to
work.
1) I login to SQL Server thru the query analyzer using Windows
Authentication.
2) sp_password NULL, 'password', 'sa'
3) It indicates with "Password changed"
4) I log out from the query analyzer.
5) I try login to SQL Server thru query analyzer using SQL Server
authentication.
6) It indicates with a login error, and it says "Reason: Not associated
with a trusted SQL Server connection.
Does anyone shine some light?
Thanks.
J
"Aaron [SQL Server MVP]" wrote:
> If you log onto the server with a different system admin user, or a
> local/domain windows administrator, you can use master..sp_password.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:53e001c48a07$3ad358b0$a301280a@.phx.gbl...
>
>|||Already answered in another thread...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"thejackofall" <thejackofall@.discussions.microsoft.com> wrote in message
news:05AFF2D7-8F2A-4D75-9A0F-83DFB40E17CF@.microsoft.com...[vbcol=seagreen]
> I lost my password for sa. So, I do the following, but it doesn't seem to
> work.
> 1) I login to SQL Server thru the query analyzer using Windows
> Authentication.
> 2) sp_password NULL, 'password', 'sa'
> 3) It indicates with "Password changed"
> 4) I log out from the query analyzer.
> 5) I try login to SQL Server thru query analyzer using SQL Server
> authentication.
> 6) It indicates with a login error, and it says "Reason: Not associated
> with a trusted SQL Server connection.
> Does anyone shine some light?
> Thanks.
> J
> "Aaron [SQL Server MVP]" wrote:
>
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,If you log onto the server with a different system admin user, or a
local/domain windows administrator, you can use master..sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:53e001c48a07$3ad358b0$a301280a@.phx.gbl...
> 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,|||anonymous@.discussions.microsoft.com wrote:
> 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,
You need to connect using another admin account and then reset the
password on the "sa" account. If you do not have any other admin
accounts, I don't think you can reset the password. You may have to
reinstall SQL Server and restore/reattach your databases.
David G.|||I lost my password for sa. So, I do the following, but it doesn't seem to
work.
1) I login to SQL Server thru the query analyzer using Windows
Authentication.
2) sp_password NULL, 'password', 'sa'
3) It indicates with "Password changed"
4) I log out from the query analyzer.
5) I try login to SQL Server thru query analyzer using SQL Server
authentication.
6) It indicates with a login error, and it says "Reason: Not associated
with a trusted SQL Server connection.
Does anyone shine some light?
Thanks.
J
"Aaron [SQL Server MVP]" wrote:
> If you log onto the server with a different system admin user, or a
> local/domain windows administrator, you can use master..sp_password.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:53e001c48a07$3ad358b0$a301280a@.phx.gbl...
>
>|||Already answered in another thread...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"thejackofall" <thejackofall@.discussions.microsoft.com> wrote in message
news:05AFF2D7-8F2A-4D75-9A0F-83DFB40E17CF@.microsoft.com...[vbcol=seagreen]
> I lost my password for sa. So, I do the following, but it doesn't seem to
> work.
> 1) I login to SQL Server thru the query analyzer using Windows
> Authentication.
> 2) sp_password NULL, 'password', 'sa'
> 3) It indicates with "Password changed"
> 4) I log out from the query analyzer.
> 5) I try login to SQL Server thru query analyzer using SQL Server
> authentication.
> 6) It indicates with a login error, and it says "Reason: Not associated
> with a trusted SQL Server connection.
> Does anyone shine some light?
> Thanks.
> J
> "Aaron [SQL Server MVP]" wrote:
>
Subscribe to:
Posts (Atom)