Solved

LINKED SERVER PROBLEM

Posted on 2010-11-12
6
560 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

739 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