when making a account

[OzzyGT]

If it is the same error than him, and you have your windows firewall turned off it can be that you have the wrong ip or the wrong user/password in table.xml.

The last thing it could be is that your mssql server is not accepting remote connections or it's not binded to the tcp ports.

Check sqlserver configuration -> protocols for MSSQLSERVER -> TCP/IP should be enabled and in IP Adresses check that the ip you're going to use has the port 1433.

 

[Pufulici]

thank you soo much Ozzy, finally i managed to log in..the problem was in sql server config..thanks again

 

[killerkain]

i can get in server using compactau.exe i can log into game no issue but cant relog but if i dont run compactau.exe i can get to log in screen then log it times out any ideas please help

 

[aurienm]

I cant login either, heres a screenshot of everything

To view the content, you need to sign in or register

MSSQL tcpip enabled and here are the rest

To view the content, you need to sign in or register

EDIT : It was a named instance so i had to change the port to the default one, 1433. Now I can login but it timesout.

EDIT 2 : I can now login and it gets to character creation screen but the Complete button in the end doesn't do anything.

 

[xirod1]

MSSQL tcpip enabled and here are the rest

To view the content, you need to sign in or register

You set it up wrong. You have 1433 in TCP Dynamic Ports. 1433 should be in the "TCP Port" area, and the "TCP Dynamic Ports" area should be left blank.

 

[aurienm]

Oh sorry about this, I posted the same thing on 2 threads lol. All fixed now, after you helped me on the other thread.

 

[balthazar]

exec adduser 'master',0xa15b019f7ab9ba0e01482577acb76e90,'prompt','answer','truename',123123,'[email protected]',123123,'province','city',123123,'address',123123,0,'1998/01/01','qq',0xa15b019f7ab9ba0e01482577acb76e90

i used this to create master monster however any other acc i create even if i use the boi acc manager they all give me wrong password any help please...


also were are these stored procedures located ?

thanks

 

[PunkS7yle]

The ID and PW are both required to create the salt. When you create an account , pick your id, for example 'balthazar' and password 'mamamia' , combine them into 'balthazarmamamia' and md5 encrypt that string using

To view the content, you need to sign in or register

, the result is

0x01f9aa95542b9f76326dec63689cf3c6

. That's what you use for passwords on new account.

 

[balthazar]

The ID and PW are both required to create the salt. When you create an account , pick your id, for example 'balthazar' and password 'mamamia' , combine them into 'balthazarmamamia' and md5 encrypt that string using

To view the content, you need to sign in or register

, the result is

0x01f9aa95542b9f76326dec63689cf3c6

. That's what you use for passwords on new account.

[FIXED]

Thanks
the info worked a charm PunkS7yle, can create my own user details now