How to set sa login in MSSQL server

၀င္းဒုိးအသစ္တင္တုိင္း အဲဒါကုိ Run ရတာက အလုပ္တစ္ခုလုိပါပဲ။ ဒီေန႔ window အသစ္တင္လုိက္ပါတယ္ ။ IIS server တင္ခ်င္လုိ႔ အသစ္လုပ္လုိက္ရတာ ။ ျပီးေတာ့ visual studio 2008 ကုိ တင္လုိက္ပါတယ္။ တစ္ေန ကုိကုန္ေရာပဲ။ MSSQL တင္တုိင္း အဲဒီ login name ေျပာင္းရတာက ရႈပ္ပါတယ္။ အခုနည္းေလးအတုိင္းသာလုပ္လုိက္ပါ ။ အရမ္းျမန္တယ္ ။

1.Open the SQL Server express management studio
2.Connect to SQL Server using windows authentication
3.Right click the server name and choose properties
4.Go to security tab. Change server authentication to “SQL Server and Windows Authentication mode”
5.Click OK and restart SQL Server
6.Go to SQL Server studio management express
7.Expand the server and choose security and expand logins
8.Right click on SA, from properties modify the password and confirm password

This changed pass should work.

more info
http://ashrafur.wordpress.com/2008/01/04/set-sa-password-using-sql-server-management-studio/