Fórum Restaurar login ´sa´ #33597
16/02/2006
0
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
Curtir tópico
+ 0
Responder
Posts
23/02/2006
Vanius
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
Responder
Gostei + 0
23/02/2006
Vanius
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
Responder
Gostei + 0
23/02/2006
Chriskaka
Valeu, camarada.
Abraços,
Christiano Rios
Abraços,
Christiano Rios
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)