Ran a diagnostic utility called sqldiag but could not find anything related to the error. Strangly this happens was sporadically not always. it will be slower, but if it works then that points to a problem with OLE DB provider.I would try the hotfix, if it still doesn't work properly then try using Try to connect using OLEDB direclty.This solved my problem.See ya! http://caribtechsxm.com/protocol-error/protocol-error-in-tds-stream-sql-2008.php
There may be error messages posted before this with more information on why the thread has exited...SSIS Error Code DTS_E_THREADCANCELLED. I think the issue is about the ODBC Drive. Antsy permutations Counterintuitive polarizing filters Why didn't Dave Lister go home? Error code: 0x80004005. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/45156a48-afa7-4756-a1a3-80ab550e6888/protocol-error-in-tds-stream-error-a-connection-cannot-be-made-ensure-that-the-server-is-running?forum=sqlanalysisservices
VM1 is where the S2008 server that runs the processes resided. Does the code terminate? Thanks for the help. You can not post a blank message.
Like Show 0 Likes (0) Actions Re: Protocol Error in TDS Stream Jared Papador Nov 17, 2014 4:29 PM (in response to Erika Jain ) This issue is really annoying. SQL Server Developer Center Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) You cannot edit HTML code. Protocol Error In Tds Stream Sql Server 2008 R2 You cannot delete other topics.
Reply Vijetha says: June 18, 2013 at 5:56 pm I followed the Steps but error occurred again. We've restricted the ability to create new threads on these forums. The first error with "TDS" in the error steam was a network issue between both the sites.But the second error The script threw an exception: A connection cannot be made. Below are the errors we are receiving: Error 1: Internal error: The operation terminated unsuccessfully.
Microsoft SQL Server What is the Database version set to in the Datastore? Protocol Error In Tds Stream Tableau Word for making your life circumstances seem much worse than they are Jokes about Monica's haircut Nested apply function at a list What to do with my pre-teen daughter who has Reply Anon says: October 5, 2011 at 5:54 am Not only did this not work, SSIS now refuses to end the job and stays yellow until I click the stop button. Right click on "Aliases" and then select "New Alias…" 4.
What's the difference between `su -` and `su --login`? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95829 Like the replies above it is an ODBC driver issue. Protocol Error In Tds Stream Excel An OLE DB error has occurred. Protocol Error In Tds Stream Sql Server 2012 No problem.
Demonstrates the basic connection of bypassing certification set up. Check This Out You cannot post IFCode. I have seen this when the switch/nics didn't match their duplex... 0 LVL 1 Overall: Level 1 Windows Server 2008 1 Windows Server 2012 1 Message Active 5 days ago Reply Michael says: July 31, 2012 at 9:22 am This solved a problem where we were trying to connect to a source server across a firewall. Protocol Error In Tds Stream Communication Link Failure
LEARN MORE Join & Write a Comment Already a member? We are running a 32-bit application with SQL Server 2008 on Windows Server 2008 R2 (64 bit). Upgrading a Database SQL 2000 to SQL 2005 (sqlservercentral.com) Database Design Implementing Table Inheritance in SQL Server Implementing Table Interfaces DTS and SSIS Download SQL Server 2005 DTS add-in Dynamically Generate Source I've got 5 VMware servers.
You cannot post topic replies. Protocol Error In Tds Stream Linked Server Is this just a network traffic issue (I'm on a domestic 1 meg connection) or has my table got too big?I'm using SQL 2000 SP4 on Windows Server 2003 rmiao Flowing Go to Start-> All Programs-> Microsoft SQL Server 2008-> Configuration Tools -> SQL Server Configuration Manager 2.
We have reported the Protocol error to our client and very soon this issue will be sorted out by their in house DBA. There may be error messages posted before this with more information on why the thread has exited...After searching the whole day for a solution I finally stumbled accross this post by Join our community for more solutions or to ask questions. Protocol Error In Tds Stream Excel 2013 Adding the CAST eliminated the problem.
Also checked the TCP/IP and Named Pipe protocol which are set in the SQL Server Configuration Manager Our Environment: BODS 4.0 SP2 DB: SQL Server 2008 R2 Datastore connection Type: OLEDB Have you checked the event logs on both computers for networking errors at the OS levelhttp://geekswithblogs.net/darrengosbell - please mark correct answers Marked as answer by Naggy_sr Wednesday, August 05, 2009 9:23 Browse other questions tagged sql-server ssis or ask your own question. have a peek here My ETL blogLatest Blog Posts• 2014-04-17 Can Your ETL Make Your Reporting Faster?• 2014-04-04 ProKarma Acquires Mantis Technology Group• 2014-04-02 How to Create Charts in Webi (Part 2 of 2) Back
Solved [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream Posted on 2014-08-20 Windows Server 2012 VMware Windows Server 2008 1 Verified Solution 7 Comments 303 Views Last Modified: 2015-06-27 I've got Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Protocol error in TDS stream"...SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. Other than MDAC, I haven't seen any other resolution suggested for the problem.Thank you so much,Melanie Post #8585 Antares686Antares686 Posted Saturday, December 7, 2002 10:08 PM SSCrazy Eights Group: Moderators Last Not the answer you're looking for?
Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream". We upgraded to SQL2012 a couple of weeks ago and it has run perfectly since.....up until 3 days ago.