September 24, 2008 at 12:01 pm
Hello,
Yesterday my computer became infected with the vundo virus, I've just removed it but I'm unable to connect to the local server. I was able to do it before but right now I can't.
Any ideas?
Thanks
September 24, 2008 at 12:09 pm
September 24, 2008 at 12:12 pm
I can't connect through the SQL Server Management Studio Express, I tried "sqlcmd -S(local)\SQLEXPRESS" and got nothing. How can I check if the port is open?
Thanks
September 24, 2008 at 12:30 pm
netstat can be useful when looking at the ports. Start|Run|cmd Enter. netstat -a Look for your SQL Server port to be listening.
You can check to see if the service is running via the SQL Configuration Manager or via the Services section of computer management.
September 24, 2008 at 12:38 pm
Hello,
The port isn't listening. How can I check the services list?
Thanks
September 24, 2008 at 12:42 pm
I found the services list and SQL Server (SQLEXPRESS) is listed, I try to start the service but I get an error, "the system can't find the specified path " or something like that.
September 24, 2008 at 12:49 pm
What was in your sql express database? You might check your programs files\MS SQL Server directories for your databases, move them to a safe location on your disks, and then just do a re-install of sql express. Depending on which version of the Trojan was installed on your machine other things could be hosed as well. Might be safer to just re-image the entire thing once you save your data to somewhere else.
-Luke.
September 24, 2008 at 12:54 pm
I had the DB for an application that I'm developing but it had no data, only the tables with their keys and stuff. Should I just copy the SQL Server Database Primary File os something else? Thanks
September 24, 2008 at 12:59 pm
Most likely there should be a mdf and ldf for the db that you were developing. They're probably located in C:\Program Files\Microsoft SQL Server\MSSQL\Data and they would be named something like your database name by default. i.e. if your database was named mybase the files would most likely be mybase.mdf and mybase.ldf.
-Luke.
September 24, 2008 at 1:02 pm
I have 2 files that match... one has the name of the DB and the other one is the _log file, are those 2 the ones that you are talking about? Thanks
September 24, 2008 at 1:11 pm
September 24, 2008 at 1:13 pm
Great, I'll give it a try and post back on the results.
Thanks!
September 24, 2008 at 3:29 pm
I'm unable to remove SQL Server... I restarted my PC, tried again and nothing.
September 24, 2008 at 3:50 pm
I tried uninstalling it and it didn't work, the uninstaller freezes when it is gathering the necessary information. I tried installing over it and didn't work either.
Do you think that 'll have to reinstall WinXP to get it back to normal?
Thanks
September 26, 2008 at 9:19 am
It's possible. For me it all comes down to planning. I have an image of my laptop and backup my files to a networked drive. If something goes wrong on my machine I'll play with it for about 30 minutes. If I don't have it fixed by that point, I just re-image the entire thing. In 15 minutes I have a fresh machine with all of my programs setup the way I like them. Something I learned to do early on in my IT career while doing help desk work. Spend 15 minutes on it and if you can't figure it out in 15 more minutes they'll be back up and running.
If you do opt for the reinstall just make sure you backup all of your documents, code, etc. and make sure that you scan them for viruses etc before you copy them back to your machine once it's reloaded.
-Luke.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply