Server login in Game Error 1

[MrComodoDragon]

Hey..

Well when i login i click on server smooth ok , Then i get Error 1
an when i log back in again surprise it happens again..

What is Error 1 and were can i get the fix for it ?



Cheers

[Philipp_]

Originally Posted by Philipp_

I can't believe that you tried to use the search engine, because the fix you are talking about is easy to find. Here's the tutorial how to use the search engine on elitepvpers:

First, navigate to the search engine


Then type in what you are looking for and click "SEARCH"


Now you have to check the results and you are done!

It has been answered several times..
This error usually occurs if there is a mismatch between client and server files (NPCQuest.SData or Cash.SData in example) or your linked servers aren't installed. Run the following query to add linked servers:

 Spoiler

/* Add linked servers */

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
	EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
	EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';

[MrComodoDragon]

Yeh it makes no difference , I executed this query earlier with no problems
an this is just the same as the SQL installation query that you get in EP5 server files.

the error i get in my logs..



2013-01-29 16:48:19 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2013-01-29 16:48:19 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 1,3781629570671706113,104,'64'

2013-01-29 16:48:19 VerifyReConnect : The Connection has been lost, SQLHDBC=681858

[orion72956]

Sounds like your files are bugged. Suggest you get a clean set of server files and attach them instead of the ones you are currently using..