[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


TSQL from SQL 2008 to SQL 2005 fails

Posted on 2009-12-21
Medium Priority
Last Modified: 2012-05-08
I am trying to copy some records from SQL 2008 to 2005.

I have named-pipes and TCPIP setup on both servers.

Getting this error doing a table Insert from 2008 to 2005:

OLE DB provider "SQLNCLI" for linked server "demod01" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "demod01" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Question by:Tom Sage
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 501 total points
ID: 26097134
did you allow the remote connections on the sql 2005 box?
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 501 total points
ID: 26097203

Author Comment

by:Tom Sage
ID: 26097557
Turned on Browser on 2008.

Still getting this error:

Named Pipes Provider: Could not open a connection to SQL Server [5].
OLE DB provider "SQLNCLI" for linked server "demod01" returned message "Invalid connection string attribute".
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.


Assisted Solution

spikelly earned 498 total points
ID: 26097682
You should turn it on the SQL Server 2005 not the 2008 since your copying from 2008 to 2005.

Author Comment

by:Tom Sage
ID: 26097713
I am running the query on 2005.


Author Closing Comment

by:Tom Sage
ID: 31668582
I am going to assign points even though I cannot get it to work.  

This is the kind of problem that gives microsoft a bad name.  Copying from one server to another should not be ridden by so many possible errors and problems.

Thank you for your time.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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…
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…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

867 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