[HELP] Some error

2013/ 4/25 02:28:02 OP: 656227580, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2013/ 4/25 02:28:45 CDbManager::UpdateGuildRanking¿¡¼­ (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ




2013/04/25 02:28:18
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2013/04/25 02:28:18
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "RANKING" returned message "Login timeout expired".
2013/04/25 02:28:18
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "RANKING" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".

Quote:

---

Originally Posted by EliteSoulKeeper

2013/ 4/25 02:28:02 OP: 656227580, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2013/ 4/25 02:28:45 CDbManager::UpdateGuildRanking¿¡¼­ (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ




2013/04/25 02:28:18
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2013/04/25 02:28:18
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "RANKING" returned message "Login timeout expired".
2013/04/25 02:28:18
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "RANKING" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".

---

did you check your ODBC ?? maybe you have something wrong there

Nope its not the ODBC there is no link at the RANKING_DBF database.

Almost 90% of the server do have this error.
Its an easy fix. Just use your mind!

it's because some people just execute the all in one query. They never check or edit the datasrc when creating the lilnked servers.

I did run this query

Code:

---

EXEC master.dbo.sp_dropserver RANKING

/****** Object:  LinkedServer [RANKING]    Script Date: 12/25/2011 00:13:43 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'DEINPC\SQLEXPRESS', @catalog=N'RANKING_DBF'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'RANKING',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation compatible', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'data access', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'dist', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'pub', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc out', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'sub', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'connect timeout', @optvalue=N'0'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation name', @optvalue=null
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'lazy schema validation', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'query timeout', @optvalue=N'0'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'use remote collation', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO

---

did not work

Any other solutions

RANKING.RANKING_DBF.dbo.RANKING_STR

Open your source and search for that string. Then alter it so it looks like this

RANKING_DBF.dbo.RANKING_STR

/****** Object: LinkedServer [RANKING] Script Date: 12/25/2011 00:13:43 ******/
EXEC master.dbo.sp_addlinkedserver @Server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'DEINPC\SQLEXPRESS', @catalog=N'RANKING_DBF'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsr

is that DEINPC\SQLEXPRESS right?