카테고리 없음

로그인 관련

보미아빠 2011. 5. 30. 19:52

net start mssql$sql2008r2 /m"SQLCMD"
sqlcmd -S.sql2008r2 -d master
alter login sa enable
go
alter login sa with password ='1234' UNLOCK
go
exit

The Authentication mode for MS-SQL Server can be changed after installation without installing the SQL Management Studio.
  1. Open the Window Registry Editor (Start --> Run --> regedit.exe).
  2. Go to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCE NAME>\MSSQLServer where <INSTANCE NAME? is the name of the MS-SQL instance.
  3. Locate the field "LoginMode".  Change it's value to "2" to put MS-SQL into Mixed Mode Authentication.
  4. Restart the MS-SQL service.