Problem with Log in

07/28/2012 09:48 Baby_Doll#1

well i got as problem when i select a toon and wanna log in into game. it gives me an error and that are the logs.

2012-07-28 09:25:43 PS_DBAGENT__system log start (DBAgent01)

2012-07-28 09:25:57 connect game, Name=

2012-07-28 09:25:57 connect game, Name=

2012-07-28 09:27:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-07-28 09:27:18 ::LoadCharacter 1 Bish qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,4,'Shubidubila')}

2012-07-28 09:27:18 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

i already tried a fix from omega but it had no effect. ([Only registered and activated users can see links. Click Here To Register...])
it would be nice if anyone got a idea how to fix that.
regards

07/28/2012 13:55 Follow001#2

You Need UnInstall ShaiyaServer and Sql Server. and Install Again Sql Server and ShaiyaServer Files. Fix it your Problem .

07/29/2012 14:01 Baby_Doll#3

I did that already but still the same problem

07/29/2012 17:35 ..Zeus..#4

what error became u?

07/29/2012 17:50 TeddyBear94#5

Quote:

Originally Posted by ..Zeus..

what error became u?

i got the same prob and it gives error 0 and tells connection to server has been disconnected. and the loggs are posted above

07/29/2012 18:32 JohnHeatz#6

Run the sp_addlinkedserver and it should work.

sp_addlinkedserver

Code:

/* 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';

07/29/2012 19:35 TeddyBear94#7

that helped me alot but now i have the prob that my sgrafic dces me after i see the loading screen

07/29/2012 23:22 [Admin]Smile.jpg#8

If sgraphic dcs you, it's because of some .SData file. If you modified any file and imported it, then import it again, but click yes when it asks you for encryption. Some files are already encrypted, and if you encrypt them twice, you get sgraphic has stopped working error.

07/30/2012 02:09 dimaster10#9

Most likely a problem in other. Tell to me it appeared after inquiry Item?

07/30/2012 11:10 TeddyBear94#10

prob fixed thank u guys thread can be closed!