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.|||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...
> 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,
> >.
> >|||> 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...
> 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,
> >.
> >|||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
>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...
>> 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,
>> >.
>> >
>
>.
>|||> 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...
> 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
> >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...
> >> 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,
> >> >.
> >> >
> >
> >
> >.
> >|||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--
>> 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...
>> 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
>> >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...
>> >> 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,
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||> 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 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.)
>
>.
>|||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...
> > 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,
>
>|||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...
> 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...
> > > 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,
> >
> >
> >

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:

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:
>

Repost: Exporting Information

Hello NG
We have a production database that we have moved the tables to SQLServer and
I have been creating stored procedures to replicate some of the processes
done on the access side - the server does processing extremely faster than
access - Here is my problem I am currently pulling info from SQL SERVER to
Access once a w for wly stats I want to create a stored procedure to
process the wly stats and push them to an access table upon request - we
have multiple warehouses and I would like to have the process coded once in
sql and dump to the access table based off a warehouse variable passed to
the stored procedure - Can SQLServer from a stored procedure export a
recordset into a varible defined Access Table?
TIAFAH
RandyHi Randy,
Yes this is possible...You can do it by using a linked server. You can
find info about linked servers in SQL Server Books Online. I've given
an outline of the general steps you need to do below.
Hope this helps.
=================
1) Open Query Analyzer and log in using an account with SysAdmin
privileges (e.g. sa). Make sure you are using the "master" database.
2) Type in the following:
exec sp_addlinkedserver '<Linked Server Name>', '<MS Access Version>',
'Microsoft.Jet.OLEDB.4.0', '<Full Path To Access DB>'
<Linked Server Name> can be whatever you want it to be, you will use
this to reference the Access DB.
<MS Access Version> is something like 'Access 97' or 'Access 2003' etc
<Full Path To Access DB> is, well, yeah...
3) Execute what you entered in (2) and then clear the Query Analyzer
window of the command
4) Type in the folliwng into Query Analyzer:
sp_addlinkedsrvlogin '<Linked Server Name>', false, '<SQL Server Login
Name>', 'Admin', NULL
<SQL Server Login Name> is the SQL Server login that will access the
Access DB. Make it something like "sa" if you will be executing the
stored proc under your account.
5) Execute the command entered in (4)
OK, after doing that you can now access you MS Access DB from SQL
Server. To reference a table in Access you have to write:
<Linked Server Name>...<Table Name>
You can do Inserts and other things to this table. In your case you
would probably be wanting to Insert values into the table.
Hope that helps.