[HELP]SQL server does not exist or acces denied.

[draegon71]

Ok after billions of posts on epvp forums this is why you cant start the server

Over and over this question has been asked and no one gets my point. So here is my tutorial why you can connect to the server. Or its not starting the server. Please read this. And pay attention to it.



The error message:





[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.



Ok lets break this down shall we ?

- This problem occurs during the discovery phase of the connection. The IPSec policy on the client drops packets from the server when the source IP changes.





The ultimate fix !!

Please check this list of most common errors

- Is the the mssql server installed ?

Yes

- Is it mssql ? And not mysql ?

MSSQL with Sp4

- Is the mssql server running ?

Yes

- Is the mssql password right ?

Yes
[quote]- Is the mssql username right ?[quote]
should
- did you fill in: /Cast/config.ini ?
- did you fill in: /DekaronServer/config.ini ?
- did you fill in: /Session/config.ini ?

- Did you save the file ?

Yes

- Are the db files installed ?
Yes
- Are the ip's right ?

~ Quoted from janvier123
--------------------------------------------------------------------
Ok , i using the Dekaron Difference Client .
Here is the original data/share/loginlist.csv

Group,LoginServer Index,IP,Port
0,0,78.111.71.227,7880
1,0,192.168.5.7,7880
2,0,5.113.140.247,7880

I changed it to

Group,LoginServer Index,IP,Port
0,0,[COLOR="Red127.0.0.1[/COLOR],7880
1,0,127.0.0.1,7880
2,0,127.0.0.1,7880

"127.0.0.1" Should To be replaced with my IP adress or the Hamachi IP,or with what...?

--- Here is the original data/share/channelist.csv

Group,Channel Index,IP,Port,Name
0,0,78.111.71.227,50005,Difference
1,0,192.168.5.7,50005,TEST
2,0,5.113.140.247,50005,TEST

I changed it to

Group,Channel Index,IP,Port,Name
0,0,127.0.0.1,gReENNN
1,0,127.0.0.1,TEST
2,0,127.0.0.1,TEST

Now The Cast/config.txt
- What IP should to added here?with my ip address?hamachi ip?
Now The Dekaron Server/config.txt
- What IP should to added here?with my ip address?hamachi ip?
Now The Login/config.txt
- What IP should to added here?with my ip address?hamachi ip?
Now The Messenger/config.txt
- What IP should to added here?with my ip address?hamachi ip?
Now the Session/config.txt
- What IP should to added here?with my ip address?hamachi ip?
Webserver?
- What IP should to added here?with my ip address?hamachi ip?

Thanks very much

EDITED:
I still searching in old threads,many users had this issue ^^
but i still get the error...

if someone solved this problem please tell me how !
i have MSSQL 2000 + SP4 Update,with the SN.txt too,all ips are placed good(i think)