Solved

LINKED SERVER PROBLEM

Posted on 2010-11-12
6
558 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
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

772 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