help with the installation of a procedure!

I am trying to install a procedure to appear rankings and'm not getting

PHP Code:

---

/****** Object:  StoredProcedure [dbo].[MAKE_RANKING_STR]    Script Date: 04/21/2011 16:52:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MAKE_RANKING_STR]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'


CREATE       PROC [dbo].[MAKE_RANKING_STR]
@iserverindex CHAR(2) = ''01''
AS
set nocount on
DECLARE @currDate char(10),@om_nCount INT,@of_nCount INT                
SET @currDate = CONVERT(CHAR(8),GETDATE(),112) 
                           + RIGHT(''00'' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2) 
                --           + RIGHT(''00'' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)


--R1 : ÃÖ°­±æµå
--R2 : ÃÖ´Ù½Â
--R3 : ÃÖ´ÙÆÐ
--R4 : ÃÖ´ÙÇ׺¹ÆÐ
--R5 : ÃÖ°í°á¼Ó·Â
--R6 : ÃÖ°íÀÚ±Ý
--R7 : Æò±Õ°í·¦
--R8 : ÃÖ´ëÇ÷¹ÀÌ

--SELECT * FROM RANKING.RANKING_DBF.dbo.RANKING_TBL
--DELETE RANKING.RANKING_DBF.dbo.RANKING_TBL
--R1 : ÃÖ°­±æµå

IF EXISTS(SELECT * FROM RANKING.RANKING_DBF.dbo.RANKING_TBL WHERE s_date = @currDate and serverindex = @iserverindex)
BEGIN
    DELETE RANKING.RANKING_DBF.dbo.RANKING_TBL WHERE s_date = @currDate and serverindex = @iserverindex
END

BEGIN
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R1'',s_date = @currDate,-- m_Title = ''ÃÖ°­±æµå'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
        AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority =''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_nWinPoint DESC,m_nWin DESC



--R2 : ÃÖ´Ù½Â

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R2'',s_date = @currDate,--m_Title = ''ÃÖ´Ù½Â'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
       AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_nWin DESC,CreateTime

--R3 : ÃÖ´ÙÆÐ

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,

                m_szGuild,

                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R3'',s_date = @currDate,-- m_Title = ''ÃÖ´ÙÆÐ'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
       AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_nLose DESC,m_nSurrender DESC

--R4 : ÃÖ´ÙÇ׺¹ÆÐ

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R4'',s_date = @currDate,-- m_Title = ''ÃÖ´ÙÇ׺¹ÆÐ'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
       AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_nSurrender DESC,m_nLose DESC

--R5 : ÃÖ°í°á¼Ó·Â

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R5'',s_date = @currDate,-- m_Title = ''ÃÖ°í°á¼Ó·Â'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
       AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_MaximumUnity DESC,CreateTime

--R6 : ÃÖ°íÀÚ±Ý

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R6'',s_date = @currDate,-- m_Title = ''ÃÖ°íÀÚ±Ý'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
          AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_nGuildGold DESC,CreateTime

--R7 : Æò±Õ°í·¦

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R7'',s_date = @currDate,-- m_Title = ''Æò±Õ°í·¦'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
       AND A.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_AvgLevel DESC,CreateTime

--R8 : ÃÖ´ëÇ÷¹ÀÌ

INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
        (
                Gu,    s_date,
                serverindex,
                m_dwLogo,
                m_idGuild,
                m_szGuild,
                m_szName,
                m_nWin,
                m_nLose,
                m_nSurrender,
                m_MaximumUnity,
                m_AvgLevel,
                m_nGuildGold,
                m_nWinPoint,
                m_nPlayTime,
                CreateTime
        )
SELECT TOP 20 Gu = ''R8'',s_date = @currDate,-- m_Title = ''Æò±Õ°í·¦'',
                serverindex = MAX(A.serverindex),
                m_dwLogo = MAX(A.m_dwLogo),
                B.m_idGuild,
                m_szGuild = MAX(A.m_szGuild),
                m_szName = MAX(C.m_szName),
                m_nWin = MAX(A.m_nWin),
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender),
                m_nSurrender = MAX(A.m_nSurrender),
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
                CreateTime = MAX(A.CreateTime)
    FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
  WHERE A.m_idGuild = B.m_idGuild
          AND C.serverindex = E.serverindex
        AND C.m_idPlayer =  E.m_idPlayer
       AND B.m_nMemberLv = 0
       AND B.m_idPlayer = C.m_idPlayer
        AND A.serverindex = B.serverindex
        AND B.serverindex = C.serverindex
        AND C.serverindex = @iserverindex
        AND D.m_chLoginAuthority = ''F''
        AND C.account = D.account
  GROUP BY B.m_idGuild
ORDER BY m_nPlayTime DESC,CreateTime
END
set nocount off










' 
END 


---

Quote:

---

OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "The logon timeout expired".
OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].

---

my sql is mssql express 2005 sp2.



already read the help files and says it is not possible to establish this connection with the db using express edition