SA connection problems.

• Previous message: Luis Fajardo: "SQL Server on DMZ access"
• In reply to: Jesper Sorensen: "SA connection problems."
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 23 Jun 2003 21:50:26 -0700

I managed to reset the SA password:

sp_configure 'allow update' , '1'
go
reconfigure
go
update master.dbo.sysxlogins
set password = convert(varbinary(256), pwdencrypt(null)),
xdate2 = getdate(), xstatus = xstatus & (~2048)
where name = 'sa' and srvid IS NULL
exec('use master grant all to null')
go
sp_configure 'allow update' , '0'
go
reconfigure
go

 but can anyone tell me how to get the stored procedure
sp_password back in place ??

>-----Original Message-----
>I've got problems with a SQL 7.0 server.
>
>It's most likely after a hacker attack.
>
>The SA password has been changed ( that, i have tried
>several times ) normaly i just change to Windows NT
>security, in the general tab, in the connection page and
>then change the SA password back.
>When i try this now i get an error code 2812, witch
>indicates that the stored procedure sp_password is
>missing. I have checked in the MASTER DB and the
procedure
>IS missing.
>
>Do anyone know how to resolve this problem.
>
>Thanks in advance
>
>Jesper Sorensen
>js@securezone.dk
>.
>

• Previous message: Luis Fajardo: "SQL Server on DMZ access"
• In reply to: Jesper Sorensen: "SA connection problems."
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]