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