Does anyone know how to fix this?

03/10/2011 07:47 Xx.LaMin.xX#1
hey guys i got problem >.<

Code:
2011-03-09 11:01:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'PS_USERDB01' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)

2011-03-09 11:01:11 ::SaveCharacter 236 test ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(236,1, 0,5, 14,12,9,8,7,15, 250,85,195, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}
Code:
2011-03-09 11:16:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)

2011-03-09 11:16:02 SaveBuyPointItem 239 Sadie qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(115,239,1500,'PK_shaiy0001','2011-03-09 11:16:02',1)}

2011-03-09 12:04:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411
and I cant find Usp Save User BuyPointItems_Payletter.. does anyone have it? if yes pls can you give me? thx alot =)

i got these error after i used Bane's Linked server query >.<

and this is my save char info:
Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_Info_E]    Script Date: 03/09/2011 23:50:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO








/****** Object:  Stored Procedure dbo.usp_Save_Char_Info_E    Script Date: 2008-6-7 18:31:57 ******/

/****** Object:  Stored Procedure dbo.usp_Save_Char_Info_E    Script Date: 2008/3/15 下午 05:25:52 ******/




ALTER Proc [dbo].[usp_Save_Char_Info_E]

@CharID int,
@Level int,
@StatPoint smallint,
@SkillPoint smallint,
@Str smallint,
@Dex smallint,
@Rec smallint,
@Int smallint,
@Wis smallint,
@Luc smallint,
@Hp smallint,
@Mp smallint,
@Sp smallint,
@Map smallint,
@Dir smallint,
@Exp int,
@Money int,
@Posx real,
@Posy real,
@Posz real,
@Hg int,
@Vg int,
@Cg int,
@Og int,
@Ig int,
@K1 int = null,
@K2 int = null,
@K3 int = null,
@K4 int = null,
@KillLevel tinyint,
@DeadLevel tinyint

AS

SET NOCOUNT ON

DECLARE @ServerID int
DECLARE @UID varchar (18)
SET @ServerID = 1

UPDATE Chars
SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint,
[Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc,
HP = @Hp, Mp = @Mp, Sp = @Sp,
Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money,
PosX = @Posx, PosY = @PosY, PosZ = @PosZ, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig, 
KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE()
WHERE CharID = @CharID
--UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID

--SELECT @Sta=LoginStatus FROM CHARS WHERE CharID = @CharID

IF( (@K1 IS NOT NULL) AND (@K2 IS NOT NULL) AND (@K3 IS NOT NULL) AND (@K4 IS NOT NULL))
BEGIN
	UPDATE Chars SET K1=@K1, K2=@K2, K3=@K3, K4=@K4 WHERE CharID=@CharID
END

--IF(@Sta=0)
--BEGIN

--END
--EXEC game.PS_UserData_IDC_T3.dbo.usp_Update_CharsPVPData_E @ServerID = @ServerID, @CharID = @CharID, @K1 = @K1, @K2 = @K2, @K3 = @K3, @K4 = @K4

IF(@@ERROR = 0 AND @@ROWCOUNT = 1)
BEGIN
--SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
--UPDATE CHARS SET LoginStatus = 0  WHERE (CharID<>@CharID) AND (UserID=@UID)
RETURN 1
END
ELSE
BEGIN
--SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
--UPDATE CHARS SET LoginStatus = 0  WHERE (CharID<>@CharID) AND (UserID=@UID)

--UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID
RETURN -1
END

SET NOCOUNT OFF
12/08/2015 13:37 ShiroMarcelo#2
you just need to configure the linked server game for RPC
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true'