Solved

LINKED SERVER PROBLEM

Posted on 2010-11-12
6
556 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

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…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now