sql server 계정등록

net stop mssqlserver /Y

net start mssqlserver /m /f /T3608

start /w sqlcmd -S. -A -i "C:\auth.sql"

net stop mssqlserver /Y

net start mssqlserver

ssms

declare   @dropTartgetLogin nvarchar(1000) = N''

        , @sql nvarchar(4000) = N''

        

select @dropTartgetLogin = name from syslogins where loginname like '%\Administrator'

select @dropTartgetLogin

set @sql = N'drop login ['+ @dropTartgetLogin+']'

exec (@sql)

go

create login [mssqlsvr06\Administrator] from windows with default_database=[master]

go

exec master.dbo.sp_addsrvrolemember @loginame = N'mssqlsvr06\Administrator', @rolename = N'sysadmin'

go

alter login [mssqlsvr06\Administrator] enable

go

declare @old_srvname nvarchar(1000)

select @old_srvname = srvname from master.dbo.sysservers where srvid = 0

exec sp_dropserver @old_srvname

go

exec sp_addserver [mssqlsvr06], local

go