Share via

An invalid tabular data stream (TDS) collation was encountered (Not linked Server)

Christopher Burke 96 Reputation points
2021-03-03T22:36:28.72+00:00

We just upgraded one of our sites for SQL Server 2019 and since then our software cannot write to any of the blob fields in the database.

We get the following error: "An invalid tabular data stream (TDS) collation was encountered."

We have reinstalled the SQL Server 2019 instance, we have even created a brand new database instance and attempted to write to a blob in an empty table. The problem persists.

The problem does not exist on the dev and test SQL Developer editions, however the live site is running SQL Express.

There are no linked servers involved, just a database and a client trying to write to a blob field.

We have verified that the database collation and server collation are Latin1_General_CI_AS and no other collation overrides are made in our software.

We are at a loss and our client has been offline now for over a day.

Any hints would be appreciated.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,872 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,288 questions
0 comments
Accepted answer
  1. Christopher Burke 96 Reputation points
    2021-03-04T08:35:38.99+00:00

    Answer is an obscure beta setting in Windows affecting client access to the database. If this setting is checked, chaos ensues.

    XDXJUPt.png

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.