[HELP]Database Ranking

[Wezzy_Dev]

HOw to fix this error






2014/06/17 11:21:09
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]VIA Provider: The specified module could not be found.


2014/06/17 11:21:09
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "Login timeout expired".
2014/06/17 11:21:09
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has 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.".

[banktakung]

linked the ranking DBF

[CrackTex]

[- Major]

Easy Way #

[Wezzy_Dev]

Originally Posted by Armageddon'

Easy Way #

nothing happen sir =(

ScreenShot:

[CrackTex]

Originally Posted by Wezzy_Dev

nothing happen sir =(

ScreenShot:

Make it on the Sourceway.. this will works 100%

[xTwiLightx]

Originally Posted by Wezzy_Dev

nothing happen sir =(

ScreenShot:

Drop the old linked server
->

EXEC master.dbo.sp_dropserver @server=N'RANKING', @droplogins='droplogins'
GO

If you still have issues, use my guide - should work fine then.

[Wezzy_Dev]

Originally Posted by xTwiLightx

Drop the old linked server
->

EXEC master.dbo.sp_dropserver @server=N'RANKING', @droplogins='droplogins'
GO

If you still have issues, use my guide - should work fine then.

last time i use your guide but same problem =( i hope this one sir it helps thanks for helping.