Ranking.dbo Problem help!

[kellybang]

hello ragezoners currently having problem with this...

any ideas on how to fix this?

2012/03/01 18:57:47
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

[MentaL]

[Softbank]

query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

Any fix for this guys? I also have the same. :/

[kellybang]

still no reply? :(

[Jomex]

If you don't have source just leave it because you won't do anything with it.

[kellybang]

every time i create guild it vanishes when i restart my servers >_< soo i think this error has something to do with the guild... hmmm

[Jomex]

every time i create guild it vanishes when i restart my servers >_< soo i think this error has something to do with the guild... hmmm

Nah it's just database Server(Transserver) which gets rankings of guilds from MSSQL.

[caja]

The server name for the linked server is wrong.

[ShadowDragon]

every time i create guild it vanishes when i restart my servers >_< soo i think this error has something to do with the guild... hmmm

Your guilds disappear because of a different problem. After logging in and finding your guild gone, did you ever restart only the world server? If you did, did the guilds come back?

If you can answer yes to both of those questions, then you're simply opening the server programs in the wrong order.

[kellybang]

Your guilds disappear because of a different problem. After logging in and finding your guild gone, did you ever restart only the world server? If you did, did the guilds come back?

If you can answer yes to both of those questions, then you're simply opening the server programs in the wrong order.

thats my sequence of my server sir..

actually it disappear when i shutdown the server then when i turn on it back the guild name above my name vanishes but in the DB it says i still have Guild.. i still need to /dg so that i can create a new one even though i dont have a guild anymore ingame =)) hmmmm

[ShadowDragon]

Hm, you are opening them in the right order. Well then, you might be opening then too fast. Only other thing I can think of. After opening database server, wait 15-20 seconds before continuing with the others.

[Deviant]

Hm, you are opening them in the right order. Well then, you might be opening then too fast. Only other thing I can think of. After opening database server, wait 15-20 seconds before continuing with the others.

agree with this.

[Jomex]

Hmmm I have different order O_o

[Intelligence]

I have different order either.

Try Account, Database, Core, Certifer, Login, Cache and World.

[ShadowDragon]

I have different order either.

Try Account, Database, Core, Certifer, Login, Cache and World.

Like everyone else, I'm starting to be really annoyed by your comments. Have you ever had a server running with many players that had an issue of guilds disappearing? Or do you have any clue about the question in the first post? If you can't say yes to either of my 2 questions, then you really shouldn't have said anything.

[kellybang]

i really appreciate your comments and suggestion guys.

Intelligence sequence made the guild bug fixed but i still get the query error i posted above...

@ShadowDragon42 my friend also said that this kind of sequence is not good for many players.. it might cause problem... what will i do to make the sequence right? like the one i posted above..


i really appreciate the helps.. :D

[Jomex]

Intelligence sequence made the guild bug fixed but i still get the query error i posted above...

If you do not have source of your files just ignore it told ya fixing it is too complicated to fix an error which does absolutely nothing.