Need help locating my mistake

joseph18 · 08/04/2017, 19:32

this errors pop up on dbmon then session server crashes

>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL

guesswho-.- · 08/04/2017, 20:23

Because it can't connect to the databaseeeeeee

joseph18 · 08/04/2017, 20:37

Quote:

Originally Posted by guesswho-.-

Because it can't connect to the databaseeeeeee

one more newbie question,can i login to the same pc with the server?im not using another pc to login to the server,does it matter?

also,the servers dont crash anymore

guesswho-.- · 08/04/2017, 21:31

Yes you can

joseph18 · 08/04/2017, 23:01

Quote:

Originally Posted by guesswho-.-

Yes you can

still the login wont work,always disconnecting,can u help me next time with the teamviewer?ive fixed all the versions but still no use,thanks

[DEV]Kalithar · 08/05/2017, 02:40

First try connecting to the SQL Database using the SQL Account in SSMS. If that doesn't work, then you didn't set up your SQL account properly. If that DOES work, then you may need to check your System DSN settings. Obviously guesswho can help a lot more than I can, however I'm willing to help however I can.

~~[DEV]Dekaron~~ · 08/05/2017, 07:56

Quote:

Originally Posted by lupio70

+++ try this.

lupio70 go back to your Fifa and other.

[DEV]Kalithar System DNS we use only for some connection to get information from database. And this have nothing with sesion server.

SQL Server 20xx Configuration Manager and enable TCP/IP

~~Underfisk~~ · 08/05/2017, 14:32

Also make sure to allow your IP if your trying to connect outside the host, for example if you have an SQL into another machine and you wanna connect your server-files remotly, you'll need to allow your outside IP as a rule into your firewall and also recommended create another user of sql instead of "sa"

joseph18 · 08/05/2017, 15:00

i forgot to ask,do i need to run xampp for my localhost server?because i think i forgot the xampp thing.

Quote:

Originally Posted by Underfisk

Also make sure to allow your IP if your trying to connect outside the host, for example if you have an SQL into another machine and you wanna connect your server-files remotly, you'll need to allow your outside IP as a rule into your firewall and also recommended create another user of sql instead of "sa"

im kinda lost,how would i do that?will it pop up on the server or ill do it manually?sorry im kinda new to this.

guesswho-.- · 08/05/2017, 15:18

forget what hes saying since you're trying to run a local server.
you need these 3 servers to run correctly in order to connect:
sessionserver
loginserver
dekaronserver

rest is just an addition. cast is for guilds, messenger is for party and friendlist.
if you're getting an insta-dc when logging in then it means sessionserver isnt working correctly. it's most likely a database issue but it could also be that the PORT you assigned to sessionserver is taken.
Sessionserver runs in 'server' mode, it means that other servers (they're all linked together) connect to it. only one server can run on a single port, so check that or just change the port and try again.

joseph18 · 08/05/2017, 17:22

Quote:

Originally Posted by guesswho-.-

forget what hes saying since you're trying to run a local server.
you need these 3 servers to run correctly in order to connect:
sessionserver
loginserver
dekaronserver

rest is just an addition. cast is for guilds, messenger is for party and friendlist.
if you're getting an insta-dc when logging in then it means sessionserver isnt working correctly. it's most likely a database issue but it could also be that the PORT you assigned to sessionserver is taken.
Sessionserver runs in 'server' mode, it means that other servers (they're all linked together) connect to it. only one server can run on a single port, so check that or just change the port and try again.

will try to change that,i dunno how to check who uses the port in my unit,i think i need to look at it because i got so many apps on my computer,something must been using the same port

joseph18 · 08/05/2017, 21:07

Quote:

Originally Posted by Underfisk

Also make sure to allow your IP if your trying to connect outside the host, for example if you have an SQL into another machine and you wanna connect your server-files remotly, you'll need to allow your outside IP as a rule into your firewall and also recommended create another user of sql instead of "sa"

do a3 and a9 have the same .dll files?i notice i got less .dll on my servers,does it matter?

~~Underfisk~~ · 08/05/2017, 21:33

Basically some are the same but the content inside doesn't mean that are the same but the structure of dll's seems to. But well don't compare a3 to a9 because even both was developed by diff company as you know

joseph18 · 08/05/2017, 21:59

Quote:

Originally Posted by Underfisk

Basically some are the same but the content inside doesn't mean that are the same but the structure of dll's seems to. But well don't compare a3 to a9 because even both was developed by diff company as you know

i see,i gave up for now,seems to be the problem is on loginserver config,i dunno how to fix that,i dont know how to connect port 7880,i think im gonna rest for now and see if i can do it again later,i fix all tcp/ip already.

[DEV]Kalithar · 08/06/2017, 21:16

joseph18, I'd be happy to try and help you if you'll let me. Can you send me your Discord information?