| Groups | Blog | Home |
sql server msde : Reset Forgotten MSDE Password
Hi,
Login into MSDE using trunsted connection and change the default db for the user OSQL -E -S Servername (enter) Now change the default db for the use sp_defaultdb (see books online for details) Now change the password for user using SP_password command Thanks Hari SQL Server MVP [quoted text, click to view] "Marcus" <Marcus@discussions.microsoft.com> wrote in message news:FE6B61E1-0C69-4F72-B2CA-2C3DF21DD2D7@microsoft.com... > When I run that command, I get the following error: "Cannot open user default > database. Login failed." Thanks for the help. > > "Jacco Schalkwijk" wrote: > > > If the account you login with is an administrator on the local machine, you > > can use the osql command line tool to execute the sp_password stored > > procedure: > > > > osql -E -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" > > > > That's not a spelling mistake in loginame. Apperently long, long ago when > > the sp_password procedure was created bytes were really expensive and > > someone decided to save some on that extra n. <g> > > > > -- > > Jacco Schalkwijk > > SQL Server MVP > > > > > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message > > news:47F057B4-2D41-450F-BCB0-026ADD4B2123@microsoft.com... > > >I have forgotten the SA password for my MSDE install. Can some one please > > > tell me how to reset it? Thanks. > > > > > >
If the account you login with is an administrator on the local machine, you
can use the osql command line tool to execute the sp_password stored procedure: osql -E -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" That's not a spelling mistake in loginame. Apperently long, long ago when the sp_password procedure was created bytes were really expensive and someone decided to save some on that extra n. <g> -- Jacco Schalkwijk SQL Server MVP [quoted text, click to view] "Marcus" <Marcus@discussions.microsoft.com> wrote in message news:47F057B4-2D41-450F-BCB0-026ADD4B2123@microsoft.com... >I have forgotten the SA password for my MSDE install. Can some one please > tell me how to reset it? Thanks.
I have forgotten the SA password for my MSDE install. Can some one please
When I run that command, I get the following error: "Cannot open user default
database. Login failed." Thanks for the help. [quoted text, click to view] "Jacco Schalkwijk" wrote:
> If the account you login with is an administrator on the local machine, you > can use the osql command line tool to execute the sp_password stored > procedure: > > osql -E -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" > > That's not a spelling mistake in loginame. Apperently long, long ago when > the sp_password procedure was created bytes were really expensive and > someone decided to save some on that extra n. <g> > > -- > Jacco Schalkwijk > SQL Server MVP > > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message > news:47F057B4-2D41-450F-BCB0-026ADD4B2123@microsoft.com... > >I have forgotten the SA password for my MSDE install. Can some one please > > tell me how to reset it? Thanks. > >
Specify the database explicitly:
osql -E -d master -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" -- Jacco Schalkwijk SQL Server MVP [quoted text, click to view] "Marcus" <Marcus@discussions.microsoft.com> wrote in message news:FE9E1610-F55A-4C60-B4E4-455A562850FF@microsoft.com... >I am logged into the server using an administrator account, however, when I > try to run the initial OSQL command you suggest, I get the same: "Cannot > open > user default database. Login failed." Thanks for your help. > > "Hari Prasad" wrote: > >> Hi, >> >> Login into MSDE using trunsted connection and change the default db for >> the >> user >> >> OSQL -E -S Servername (enter) >> >> Now change the default db for the use >> >> sp_defaultdb (see books online for details) >> >> Now change the password for user using SP_password command >> >> Thanks >> Hari >> SQL Server MVP >> >> "Marcus" <Marcus@discussions.microsoft.com> wrote in message >> news:FE6B61E1-0C69-4F72-B2CA-2C3DF21DD2D7@microsoft.com... >> > When I run that command, I get the following error: "Cannot open user >> default >> > database. Login failed." Thanks for the help. >> > >> > "Jacco Schalkwijk" wrote: >> > >> > > If the account you login with is an administrator on the local >> > > machine, >> you >> > > can use the osql command line tool to execute the sp_password stored >> > > procedure: >> > > >> > > osql -E -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" >> > > >> > > That's not a spelling mistake in loginame. Apperently long, long ago >> when >> > > the sp_password procedure was created bytes were really expensive and >> > > someone decided to save some on that extra n. <g> >> > > >> > > -- >> > > Jacco Schalkwijk >> > > SQL Server MVP >> > > >> > > >> > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message >> > > news:47F057B4-2D41-450F-BCB0-026ADD4B2123@microsoft.com... >> > > >I have forgotten the SA password for my MSDE install. Can some one >> please >> > > > tell me how to reset it? Thanks. >> > > >> > > >> > > >> >> >>
I am logged into the server using an administrator account, however, when I
try to run the initial OSQL command you suggest, I get the same: "Cannot open user default database. Login failed." Thanks for your help. [quoted text, click to view] "Hari Prasad" wrote:
> Hi, > > Login into MSDE using trunsted connection and change the default db for the > user > > OSQL -E -S Servername (enter) > > Now change the default db for the use > > sp_defaultdb (see books online for details) > > Now change the password for user using SP_password command > > Thanks > Hari > SQL Server MVP > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message > news:FE6B61E1-0C69-4F72-B2CA-2C3DF21DD2D7@microsoft.com... > > When I run that command, I get the following error: "Cannot open user > default > > database. Login failed." Thanks for the help. > > > > "Jacco Schalkwijk" wrote: > > > > > If the account you login with is an administrator on the local machine, > you > > > can use the osql command line tool to execute the sp_password stored > > > procedure: > > > > > > osql -E -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" > > > > > > That's not a spelling mistake in loginame. Apperently long, long ago > when > > > the sp_password procedure was created bytes were really expensive and > > > someone decided to save some on that extra n. <g> > > > > > > -- > > > Jacco Schalkwijk > > > SQL Server MVP > > > > > > > > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message > > > news:47F057B4-2D41-450F-BCB0-026ADD4B2123@microsoft.com... > > > >I have forgotten the SA password for my MSDE install. Can some one > please > > > > tell me how to reset it? Thanks. > > > > > > > > > > >
That did the trick! Thanks for everyone's help :)
[quoted text, click to view] "Jacco Schalkwijk" wrote:
> Specify the database explicitly: > > osql -E -d master -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" > > -- > Jacco Schalkwijk > SQL Server MVP > > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message > news:FE9E1610-F55A-4C60-B4E4-455A562850FF@microsoft.com... > >I am logged into the server using an administrator account, however, when I > > try to run the initial OSQL command you suggest, I get the same: "Cannot > > open > > user default database. Login failed." Thanks for your help. > > > > "Hari Prasad" wrote: > > > >> Hi, > >> > >> Login into MSDE using trunsted connection and change the default db for > >> the > >> user > >> > >> OSQL -E -S Servername (enter) > >> > >> Now change the default db for the use > >> > >> sp_defaultdb (see books online for details) > >> > >> Now change the password for user using SP_password command > >> > >> Thanks > >> Hari > >> SQL Server MVP > >> > >> "Marcus" <Marcus@discussions.microsoft.com> wrote in message > >> news:FE6B61E1-0C69-4F72-B2CA-2C3DF21DD2D7@microsoft.com... > >> > When I run that command, I get the following error: "Cannot open user > >> default > >> > database. Login failed." Thanks for the help. > >> > > >> > "Jacco Schalkwijk" wrote: > >> > > >> > > If the account you login with is an administrator on the local > >> > > machine, > >> you > >> > > can use the osql command line tool to execute the sp_password stored > >> > > procedure: > >> > > > >> > > osql -E -Q "EXEC sp_password @new='newpassword', @loginame = 'sa'" > >> > > > >> > > That's not a spelling mistake in loginame. Apperently long, long ago > >> when > >> > > the sp_password procedure was created bytes were really expensive and > >> > > someone decided to save some on that extra n. <g> > >> > > > >> > > -- > >> > > Jacco Schalkwijk > >> > > SQL Server MVP > >> > > > >> > > > >> > > "Marcus" <Marcus@discussions.microsoft.com> wrote in message > >> > > news:47F057B4-2D41-450F-BCB0-026ADD4B2123@microsoft.com... > >> > > >I have forgotten the SA password for my MSDE install. Can some one > >> please > >> > > > tell me how to reset it? Thanks. > >> > > > >> > > > >> > > > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |