Modify the MSSQLServer login Method

1. For SQL2000

Enterprise Manager --> right-click your instance (that is, the one with the green icon) --> properties --> Security --> change to SQL and window mixed
OrCode:
Xp_instance_regwrite n 'HKEY _ LOCAL_MACHINE ', n' SOFTWARE \ Microsoft \ MSSQLServer', 'loginmode', n' Reg _ dword', 1
1 --- Windows Authentication Mode
2---sql and Windows authentication modes

 

II. For sql2005

Because no enterprise manager has only one studio, open it first and log on to the database --> right-click your instance (that is, the one with the green icon) --> attribute --> Security --> change to SQL and window mixed

Enable the SA account (in security settings) to set the password or cancel the forced password.