Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

LINKED SERVER PROBLEM

Posted on 2010-11-12
6
Medium Priority
?
567 Views
Last Modified: 2012-05-10
HI!

I try to link a ms 2008 to a ms 2005, but recive error:

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?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXXX".
OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXX" returned message "Unable to complete login process due to delay in opening server connection". (Microsoft SQL Server, Error: 7303)

The linked server connection from 2008 to this 2005 server goes fine...

0
Comment
Question by:myhrvold
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:Humpdy
ID: 34121163
I take it you mean you're trying to connect a linked server from 2005 to 2008 ?
seeing as you said

"The linked server connection from 2008 to this 2005 server goes fine..."

if so,
you can't create linked server from 2005 to 2008
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34121175
sorry, ignore, that,
you can do it

what's in your sql logs and event viewer ?
0
 

Author Comment

by:myhrvold
ID: 34121271
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXXX".
OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXX" returned message "Unable to complete login process due to delay in opening server connection". (Microsoft SQL Server, Error: 7303)
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:myhrvold
ID: 34121491
Hi!

If i disable the fireall on the 2008 server it is working fine.... What kind of rule should i create?
0
 

Accepted Solution

by:
myhrvold earned 0 total points
ID: 34121600
Hi!

I set the TCP port 1433 on the 2008 server open and wallah.
0
 

Author Closing Comment

by:myhrvold
ID: 34153311
I found it out myself....
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question