SQL 2005

[superklamus]

hey everyone plz can some one tell me how to change password of SQL 2005,
because my server of shaiya got hack 2 times they connect to my SQl dont know how off course everyone knows the password is Shaiya123 how can i change. well i Change it but when go put server up dont go fail:/ some one help me plz

[STIV123]

First, I would suggest using SQL 2012, or 2008. It's your choice really just suggesting.

2nd. Download This :

Click on that, it will run a query. Change the User and Pass there.

( Just to add, password can fail in changing, so if it do, try changing just the user thing )

but also after u do this u need to change INI Files and Server Patch Config.

Good Luck

[superklamus]

So but what better to use 2012 or 2008?

[STIV123]

You can either use them, all i've got told that 2005 isn't the best. Again, I got told, not proving. So i'm just following what i got told by people better then me.

Yet, i'm using 2012 One and i have no troubles with it, it works perfect.

[superklamus]

ONE MORE Question if you dont my how can i get the links off SQL 2012 :/? plz can you post ther thank you

[JohnHeatz]

Simply do the google search for it, the very first link will be it from microsoft directly you can get the MSSQLEXPR and then you can get the Management Studio for it

[STIV123]

Sure, i just putted it on upload. I will EDIT the post when it's done. Be sure to check

(Uploading cause i don't know where i got it before, hehe.)

Here's the link of 2012 Express Edition With Managament Tools. I'm using this one my self, works perfect.

[JohnHeatz]

Here is the link for you to download SQL 2008R2 with the management tools:

[superklamus]

Plz add me on skype very please name-valterpintassilgo or Uber-TIGG3Rhappy

[STIV123]

Okay, I will add you. But Don't expect from me to do 'All the work for you' I will just be helping you understand things, cause if i do it for u, u wont learn.

[superklamus]

hey i need 32 bits SQL 2012 not 64 ^^

[STIV123]

-> Go there... Then you'll see a

"search at microsoft.com"

Type there SQL u want, and it will give you results =) and then just simply DL it.

[Phantomangel042]

Originally Posted by superklamus

because my server of shaiya got hack 2 times they connect to my SQl dont know how

Did they delete your Char and Users_Master tables? That seems to be going around. No one seems to know how exactly the "crackers" are getting through- I did change my SQL logins between the first attack and the second, and my tables got deleted again anyway. Does anyone have any idea as to the root cause of these attacks (deletions, assuming the same thing happened to you as to so many others) so we can shut them down before they happen??

[Bаne]

First off 2008 is the best for multiple reasons, 2005 is outdated and provides low security, and 2012 is still new and has some holes in it.

Second, close the MSSQL port, there is no real reason for it to be open.

[Phantomangel042]

Originally Posted by Bаne

Second, close the MSSQL port, there is no real reason for it to be open.

Port is closed, in my case at least. Any other ideas? *Sorry to hijack the thread, but it is semi-on-topic since the OP had the same issue*