å¯ä»¥ã
使ç¨SQLè¯å¥ä¿®æ¹SQL Server 2005ä¸saç¨æ·çå¯ç æä½æ¥éª¤ï¼
1ãé¦éï¼ä½¿ç¨Windows身份éªè¯çæ¹å¼å¯å¨âSQL Server Management Studioâ
2ãå ¶æ¬¡ï¼å¨âæå¡å¨å±æ§âçªå£ä¸éæ©âSQL Server å Windows 身份éªè¯æ¨¡å¼â项ï¼ç¶åï¼åæ¶â强å¶å®æ½å¯ç çç¥â项ã
3ãæåå¨âæ°å»ºæ¥è¯¢âä¸æ§è¡ä¸é¢ç代ç ä¹ä¸ï¼
代ç ä¸ï¼
ALTER LOGIN sa ENABLE; GO ALTER LOGIN sa WITH PASSWORD = 'password'; GO
代ç äºï¼
ALTER LOGIN sa WITH PASSWORD = N'æ°å¯ç ' -- å¯ä»¥è¿æ ·ä½¿ç¨ï¼WITH PASSWORD = N'123456' OLD_PASSWORD = N'æ§å¯ç '
代ç ä¸ï¼
alter login [sa] with password=N'NewPassword' --å¯ä»¥ä¸ç¨æä¾æ§å¯ç --alter login [sa] with password=N'123456'