Restaurar login ´sa´
Deu um pau no SQL SERVER 2000, e o usuário DBO perdeu o login ´sa´. Como posso restaurá-lo?
Grato,
Christiano Rios
Grato,
Christiano Rios
Chriskaka
Curtidas 0
Respostas
Vanius
16/02/2006
Fera, tente isto no query analyser.
USE NomeBanco
sp_configure ´allow updates´,´1´
go
reconfigure with override
go
update sysusers set sid = (select sid from master..syslogins where name = ´sa´)
where name = ´dbo´
go
sp_configure ´allow updates´,´0´
go
reconfigure with override
go
USE NomeBanco
sp_configure ´allow updates´,´1´
go
reconfigure with override
go
update sysusers set sid = (select sid from master..syslogins where name = ´sa´)
where name = ´dbo´
go
sp_configure ´allow updates´,´0´
go
reconfigure with override
go
GOSTEI 0
Vanius
16/02/2006
Fera, tente isto no query analyser.
USE NomeBanco
sp_configure ´allow updates´,´1´
go
reconfigure with override
go
update sysusers set sid = (select sid from master..syslogins where name = ´sa´)
where name = ´dbo´
go
sp_configure ´allow updates´,´0´
go
reconfigure with override
go
Atenciosamente,
Vanius Girodo
USE NomeBanco
sp_configure ´allow updates´,´1´
go
reconfigure with override
go
update sysusers set sid = (select sid from master..syslogins where name = ´sa´)
where name = ´dbo´
go
sp_configure ´allow updates´,´0´
go
reconfigure with override
go
Atenciosamente,
Vanius Girodo
GOSTEI 0
Chriskaka
16/02/2006
Valeu, camarada.
Abraços,
Christiano Rios
Abraços,
Christiano Rios
GOSTEI 0