all groups > sql server (alternate) > march 2004 >
You're in the

sql server (alternate)

group:

Can't Access SQL Server


Can't Access SQL Server Neil Ginsberg
3/14/2004 5:25:20 AM
sql server (alternate): Help! I've been hacked! I'm running SQL 7 Desktop (MSDE) and started getting
these messages at startup that servudaemon.exe was going to be shut down.
Then, at one point, I keep getting prompted by Norton Firewall that
serve-u.exe is trying to access the Internet. It suggested I deny it, which
I did; but I kept getting prompted every minute or so, so finally I told
Norton Firewall to always deny it.

Then, some minutes later, I close an Access 2000 mdb file I had opened which
uses SQL Server as a back end (through linked tables), and I was told that
connection to SQL Server had been lost. I tried reconnecting, but couldn't.
So I went into Enterprise Manager, and was told: "A connection could not be
established to D23 - Login failed for user 'sa'.."

So I went into Registration Properties, and saw that there was a password
there. I previously didn't have a password for 'sa' (which I know is stupid,
and now see the result of it). But there's a password now, and I can't
change it. So whatever hacked into my system set my 'sa' password.

Just to be sure that my settings in Norton Firewall weren't affecting
anything, I disconnected from the Internet and then disabled Norton Personal
Firewall. The results were the same.

So is there any way to restore my system?

Thanks for any assistance.

Neil

Re: Can't Access SQL Server oj
3/14/2004 5:37:45 AM
1. Keep your internet connection disabled.
2. Start up sqlserver service.
3. From command prompt, type the following to change the password for 'sa':
osql -E -Q"exec sp_password null,'Your_new_Pass','sa'"


--
-oj
http://www.rac4sql.net


[quoted text, click to view]

Re: Can't Access SQL Server Neil Ginsberg
3/14/2004 6:53:59 AM
Thanks! Worked great.

[quoted text, click to view]

AddThis Social Bookmark Button