Where IT and IQ Collide

Support Center

Support Center » Knowledgebase » Resetting the SA Password for MSDE/SQL Desktop Engine

 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
 Add Comment
 Print Article
 PDF Version
 Email Article
 Add to Favorites

 Resetting the SA Password for MSDE/SQL Desktop Engine
Solution Follow the steps below to reset the SA password for MSDE or the microsoft SQL Server Desktop Engine. These must be run on the computer where the MSDE/SQL Server Desktop Engine is installed.

1. In the Windows command prompt type the following to connect to the SQL Server.

osql -E

2. Type the following, replacing NEW_SA_PASSWORD with the new SA password you would like to set.

sp_password NULL,NEW_SA_PASSWORD,sa
go

3. Type the following to exit osql.

exit



Article Details
Article ID: 55
Created On: 12 Jan 2010 10:52 AM

 This answer was helpful  This answer was not helpful

 User Comments Add a Comment