25. december 2002 - 13:20Der er
4 kommentarer og 1 løsning
Hacker-angreb..
Hejsa!
Jeg tror desværre, at jeg under et øjebliks nedbrud i min firewall er blevet angrebet af en hacker, som har lavet nogle ændringer i min server registrering, så jeg ikke længere kan connecte til min SQL-server på localhost. Hvad er min mulighed nu for at få det til at virke igen!? Jeg kan se, at alle mine databaser stadig er intakte, men jeg kan bare ikke connecte længere..
Skal jeg reinstallere SQL-server, eller er der et andet trick jeg kan bruge?
Well without knowing what the "hacker" has done its hard to say if there is an easy solution. I would suggest yoiu install SQL Server again, although there is no guaranty that it is going to help. Re-installing should NOT have concequences for your existing databases. Something else, the "hacker" may have altered other settings which may be causing the problem.
What the alleged "hacker" has done is changing the password for my local server-registration, so that I cannot connect anymore. If I instead choose to connect using Windows Authentication, I have no problems, other than my websites are using SQL-authentication to connect.
Isn't there any way, that you can assign a new password for the SQL-server instance without re-installing the whole product!?
you should beable to do this in the query analyzer. Choose the master database and then enter sp_password NULL, 'NewPassword', sa or in enterprise manager choose logins from the Security folder then double click the sa user.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
