Problem with Log in

[Baby_Doll]

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. ()
it would be nice if anyone got a idea how to fix that.
regards

[Follow001]

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

[Baby_Doll]

I did that already but still the same problem

[..Zeus..]

what error became u?

[TeddyBear94]

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

[JohnHeatz]

Run the sp_addlinkedserver and it should work.

sp_addlinkedserver

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

[TeddyBear94]

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

[[Admin]Smile.jpg]

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.

[dimaster10]

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

[TeddyBear94]

prob fixed thank u guys thread can be closed!