Re: sa account - hpw to reset a 'compromised' pw

From: Uttam Parui[MS] (uttamkp@online.microsoft.com)
Date: 10/26/02


From: uttamkp@online.microsoft.com (Uttam Parui[MS])
Date: Sat, 26 Oct 2002 13:43:23 GMT


Alan,

Try connecting to your MSDE server with a Administrator account and then
change the password for 'sa' using the sp_password stored procedure.

sp_password NULL, 'new_password_for_sa', 'sa'
go

Addtional Information
------------------------------------
HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
Utility
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q325003

Hope this helps.

Regards,

Uttam Kumar Parui
SQL Server Support Engineer, MCDBA, MCSE, MCT
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.



Relevant Pages

  • Re: Connect with alias
    ... My progam installed an instance of MSDE on their "Server" (just an XP ... connect to their MSDE Server ... connect to their MSDE Server with alias set up WITH PORT# specified ... Connect to MSDE Server with alias with DYNAMIC PORT # ...
    (microsoft.public.sqlserver.msde)
  • Re: Login Failed
    ... James Goodman "Murphy" wrote in message ... >> to access the server I am denied access. ... >> need to login as administrator in order to connect the MSDE server machine ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE on XP running, but not recognized in ODBC
    ... > I installed an MSDE instance for a user running XP with an ... > we go to pick the MSDE Server, ... Thanks, JRaub. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE 2000 SP3a on a Windows 2003 server
    ... Apperently my ports are setup correctly, but MSDE server ... 2004-02-20 15:35:12.26 server SQL server listening on ...
    (microsoft.public.sqlserver.msde)
  • Re: Visual Basic.NET????
    ... > edition Visual Studio only to permit Lian Anchih SQL Server Desktop Engine ... Microsoft Access ...
    (microsoft.public.vstudio.general)