When i try to connect a linked server, i´ll get this error message :
TITLE: Microsoft SQL Server Management Studio
The linked server has been created but failed a connection test. Do you want to keep the linked server?
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Named Pipes Provider: Could not open a connection to SQL Server . OLE DB provider "SQLNCLI10" for linked server "10.237.69.11" returned message "Login timeout expired". OLE DB provider "SQLNCLI10" for linked server "10.237.69.11" 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.". (Microsoft SQL Server, Error: 5)
I have tried resolve by steps described in here :
But still no change, I have set TCP/IP protocol enabled in SQL conf. manager for both servers. I have tried to ping first PC from the second and it worked. I have set the Incoming TCP rules for 1433 port in firewall for both servers. I have set the incoming UDP rules for 1434 port in firewall for both servers. ( I did not set the same rules for Outcome ) -- could it be the problem ?
Remote connections on both servers are enabled,
I want to connect MS SQL 2008 with MS SQL 2014 could it be problem with different versions ?