Disconnect after select server

06/19/2012 02:50 [ADM]Sonic.#1
Hey, im getting Disconnected after i select server and press ok. why? :P and just give me a answer please... ive been trying to search for a really long time
Heres the latest logs i got after this happend:


Quote:
2012-06-18 09:12:16 PS_DBAGENT__system log start (DBAgent01)

2012-06-18 09:12:23 connect game, Name=



2012-06-18 09:12:23 connect game, Name=



2012-06-18 09:42:18 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-06-18 09:42:18 VerifyReConnect : The Connection has been lost, SQLHDBC=801b38

2012-06-18 09:42:18 SDatabasePool::Reconnect:: success...

2012-06-18 11:20:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' 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-06-18 11:20:52 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 11:49:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' 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-06-18 11:49:31 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 11:55:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' 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-06-18 11:55:58 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 17:13:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' 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-06-18 17:13:42 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 17:17:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' 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-06-18 17:17:33 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 17:38:01 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' 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-06-18 17:38:01 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1



and second log

Quote:
2012-06-18 09:12:18 PS_LOGIN__system log start (Login01)

2012-06-18 09:15:13 <Console input> /vchkoff

2012-06-18 09:15:13 <Console output> cmd version chk off ok

2012-06-18 10:12:30 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 10:12:30 T=001:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2012-06-18 10:12:30 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(0/0)

2012-06-18 11:08:07 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-06-18 11:08:07 SDatabase::GetErrorMsg:: disconnected...

2012-06-18 11:08:07 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','0777', 3577179747173531649,'5.153.0.227', [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation., SQL STATE: 08S01, NATIVE ERROR: 11 (0xB)

2012-06-18 11:08:08 SDatabasePool::Reconnect:: success...

2012-06-18 11:12:30 cmd_auto server info log

user = 1 (0/5000)

2012-06-18 11:12:30 T=002:00:00:000, NumC=1,CMin=0,CMax=1,CAvg=0.00, CAva=2,CReq=2,CCnt=2,DCCnt=1, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=488,RBS=0,RBSC=12,SBT=502,SBS=0,SBSC=12

2012-06-18 11:12:30 SContext=3(1021/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=3(1021/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 11:27:42 <Console input> /vchkoff

2012-06-18 11:27:42 <Console output> cmd version chk off ok

2012-06-18 12:12:35 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 12:12:35 T=003:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 12:12:35 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 13:12:38 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 13:12:38 T=004:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 13:12:38 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 14:12:39 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 14:12:39 T=005:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 14:12:39 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 15:12:39 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 15:12:39 T=006:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 15:12:39 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 16:12:39 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 16:12:39 T=007:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 16:12:39 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 17:12:40 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 17:12:40 T=008:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 17:12:40 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 17:16:40 <Console input> /vhckoff

2012-06-18 17:16:40 <Console output> error cmd not found

2012-06-18 17:16:51 <Console input> /vchkoff

2012-06-18 17:16:51 <Console output> cmd version chk off ok
and third

Quote:
2012-06-18 09:12:18 PS_GAME__system log start (Game01) [KR]

2012-06-18 09:12:18 Loaded Behavior In Factory : data/ai/sorp1

2012-06-18 09:12:18 Loaded Behavior In Factory : data/ai/croco1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/croco2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Troll1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Spink1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/GoldenPig

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Sorp3

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Sorp2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Deinos

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Parridalis

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Alcarian

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Belizabeth

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Kirhiross

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrypticOne

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Haruhion

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Freezing

2012-06-18 09:12:19 RandomOption Error : ItemID=7199, byServer=3, Wis=0

2012-06-18 09:12:19 RandomOption Error : ItemID=7200, byServer=3, Wis=0

2012-06-18 09:12:20 RandomOption Error : ItemID=10214, byServer=3, Wis=0

2012-06-18 09:12:20 RandomOption Error : ItemID=10215, byServer=3, Wis=0

2012-06-18 09:12:23 connect mgr 892

2012-06-18 09:12:23 connect dbagent 896

2012-06-18 09:12:23 connect dbagent2 900

2012-06-18 09:12:23 connect gamelog 916

2012-06-18 09:12:23 Market End -----------------------

2012-06-18 09:12:24 Load Shaiya.SData 0

2012-06-18 09:15:01 <Console input> /nprotectoff

2012-06-18 09:15:01 <Console output> cmd NProtect off ok

2012-06-18 10:12:34 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 11:12:34 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 11:20:52 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=12, SC=2,SCS=1, SB=31,SBS=15

2012-06-18 11:27:30 <Console input> /nprotectoff

2012-06-18 11:27:30 <Console output> cmd NProtect off ok

2012-06-18 11:49:31 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 11:55:59 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0

2012-06-18 12:12:38 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 13:12:42 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 14:12:42 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 15:12:43 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 16:12:43 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 17:12:43 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 17:13:43 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 17:17:34 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 17:38:01 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0
Please help me :P
06/19/2012 03:01 Justas157#2
same problem to me
06/19/2012 05:28 Bаne#3
Really this is a problem people have repedidly brought to Epvpers. The fix is simple and it's litterly posted everywhere, just use the search bar.
06/19/2012 10:44 [ADM]Sonic.#4
I need an answer since i spent 1 day trying to find the fix
06/19/2012 13:29 .Shaco.#5
We did show people to how to solve problem like this, and i'm sure that there is topic. So to respect to the people who showed about how to fix, take more time and search for it. If we just give you the link it will be useless and disrespectful for the people who released and guided about it. So find it out your self instead of asking for a link.

Regards,
Shaco
06/19/2012 16:50 [ADM]Sonic.#6
I really cant find anything, pleaseee help me...
06/19/2012 18:11 Covea#7
2 Minutes Searchin':

Failed to connect to game server, after selecting server and clicking ok
May be caused by Windows Firewall blocking the client trying to connect to the server.
Can also be caused by the incorrect IP address entered in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_g ame.ini on the line that starts with GamePublicIP=
It could possibly also be from incorrect IP addresses in other .ini files.

Disconnect after selecting game server and clicking ok
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to trace what happens in this case and look for error messages in the logs. If there is an error message present in the logs try to find which SQL query that you traced with the profiler caused it.

I've ran into this specific cause of the above many times now, and it always happens to me when I set up a fresh server. Never have I seen anyone else mention it before though. I decided to add it here just in case it would be useful to someone.

Inside of PS_GameData.dbo.usp_Read_Char_Product_Item_E there is this query:

Code:
SELECT Slot,ItemID,ItemCount FROM PS_USERDB01.PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID
Since PS_USERDB01 does not exist, it causes my client to disconnect after selected the server and clicking ok.

To fix it, I remove PS_USERDB01 from the stored procedure so the query looks like this:

Code:
SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID
[Only registered and activated users can see links. Click Here To Register...]

Thanks to abrasive.
06/19/2012 18:28 [ADM]Sonic.#8
I cant find the PS_GameData.dbo.usp_Read_Char_Product_Item_E, where do i find that?
06/19/2012 18:55 Covea#9
PS_GameData -> Programmability -> Saved Procedures -> usp_Read_Char_Product_Item_E
06/19/2012 19:27 [ADM]Sonic.#10
Thank you so much! I atleast found that now, now im going to try that thing :P
06/19/2012 20:51 ShaiyaOmega#11
This particular error is caused by not having your linked servers installed.
When you run the sql files depending on who's server files you use it creates a linked server named "PS_USERDB01"
Run This to fix it.
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';