[Guide]If you screwed mssql users and logins...

[PanKJ]

Well, if thats the case, you probably get an error like this

01-07 13:20:13|[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! 127.0.0.1,9979 atum2_db_account atum callweb

So, the fix is very simple after all. Go to the both dbs->security->users and rename the users "atum" to "atumold". Then go to the security folder (i mean the one below the databases folder)->logins and delete the old atum login (if you have one). Create a new one with these settings.





ATTENTION! There is a mistake above. Do NOT choose db_owner as default schema but DBO. This should fix problems.

Dont mess with the rest of the settings. When you close mssql and reopen it you should see a new user in both dbs called "atum" and the renamed "atumold" user. Double click both "atum" users and make the properties look like this:



Now, if done correctly, you should be able to delete the "atumold" users and you can start the server (unless you have more errors.

Hoping it helps,
PanKJ

[MentaL]

[ricodex]

Thankx

[Compix]

This worked for me as well.
Thank you!

[Fornax]

I cant create new user

[PanKJ]

Go to the both dbs->security->users and rename the users "atum" to "atumold". Then go to the security folder (i mean the one below the databases folder)->logins and delete the old atum login (if you have one). Create a new one with these settings.

Can i make it simpler?

[Hope5]

I've made exactly what you've written but it won't work -.-

All other Servers are working.....

I'm working now for days on it but, you see......

[PanKJ]

What os you have? Cause i dont know much about x64 but on x86 it MUST work, cause it works for me using exactly the same settings (Win7 32bit). Are you 100% sure you followed the instructions step by step and you put exactly the same settings you see in the ss?

[Hope5]

I have also Win7 32bit ^^

And yes, I followed exactly your instructions...

[PanKJ]

Idk what to say then. Working in a pc and not working in another with the same config doesnt make sense. Ive noticed tho there are more guys with the same issue and that this doesnt work for them. If you can find a solution post it, cause i obviously cant since i never get this error :S

[lhgh20]

I cant create new user

because the atum been in sql.

[Fornax]

because the atum been in sql.

resolved

[jison]

I cant create new user

i have likes your probleme this say an error .

[PanKJ]

Thread has been updated. Check it if you have problems.

[freebook21]

So in default schema i choise DBO or set it to empty O.o,same question for setup user in dbs....

[mKeey]

default schema = dbo or db_owner