This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
I am trying to execute a simple query against a SQL server database in my C# application. I have tried using the System.Data.SqlClient driver and the latest Microsoft.Data.SqlClient and get the same error. Query: Select * From person there are only 620 records. When the same query is used in SSMS I get results with no problems, but as soon as the query is executed in my application I get the Error "A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)". If I limit my record count using Top(470) I will get results, if I go more than that I get the failure and I do not know why. the Server version is 15.0.4138.2 and I am using SQL server authentication.
The first thing I would do is to look in the SQL Server errorlog to see there are any messages that co-incides in time with this error.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
HI @Lee Taylor , Welcome to Microsoft Q&A,
Try increasing the connection timeout, sometimes the server may take longer to process the request. You can set the connection timeout in the connection string, for example:
string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;Connect Timeout=60;";
Here Connect Timeout=60 sets the connection timeout to 60 seconds, you can increase or decrease this value as needed.
The issue was related to one of the settings on the connection string.
I went from
Server=<myserver>,1433;Initial Catalog=<myDatabase>;Persist Security Info=False;User ID=<MyId>;Password=<Password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=True;Packet Size=32767
To:
Server=tcp:<myserver>;Initial Catalog=<myDatabase>;User ID=<MyId>;Password=<Password>;Packet Size=32767;TrustServerCertificate=True;
And Problem Solved, somehow.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 6%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
This is the part that solved it for me:
Encrypt=True;TrustServerCertificate=True