Restaurar login ´sa´
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
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
Clique aqui para fazer login e interagir na Comunidade :)