Ranking Probs

[Dyke2k15]

Hallo liebe Epvpers

Ich hab ein Rankingprob
2015/12/12 20:51:17
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2015/12/12 20:51:17
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "RANKING" returned message "Login timeout expired".
2015/12/12 20:51:17
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 11.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.".


und wenn ich den Linked Server Fix einfügen will sagt mir meine DB "Ranking ist schon vorhanden"

Kennt einer eine Lösung ?

Greetz

[- DK]

Originally Posted by Dyke2k15

Hallo liebe Epvpers

Ich hab ein Rankingprob
2015/12/12 20:51:17
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2015/12/12 20:51:17
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "RANKING" returned message "Login timeout expired".
2015/12/12 20:51:17
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 11.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.".


und wenn ich den Linked Server Fix einfügen will sagt mir meine DB "Ranking ist schon vorhanden"

Kennt einer eine Lösung ?

Greetz

Les mal in der erste Zeile von meinem FIX

[insaneflyff]

try this code:

 Spoiler

/***** Voher Serverobjekte -> Verbingundsserver -> Ranking löschen **********/


/****** Object: LinkedServer [RANKING] Script Date: 10/31/2009 12:24:45 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'Armageddon-Pc\SQLEXPRESS', @catalog=N'RANKING_DBF'

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

[- DK]

Originally Posted by insaneflyff

try this code:

 Spoiler

/***** Voher Serverobjekte -> Verbingundsserver -> Ranking löschen **********/


/****** Object: LinkedServer [RANKING] Script Date: 10/31/2009 12:24:45 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'Armageddon-Pc\SQLEXPRESS', @catalog=N'RANKING_DBF'

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

Erst lesen dann posten, er benutzt genau diesen Fix und oben drin steht es doch auch drin .. Habe es doch extra nochmal geschrieben ..

[xTwiLightx]

Ein wenig Suchen hätte da Abhilfe schaffen können.