Home > sql server > Transport-level errors, how do I setup SQL Server to avoid them?

Transport-level errors, how do I setup SQL Server to avoid them?

July 5Hits:3
Advertisement

I keep getting the following error (in the thousands) in production:

A transport-level error has occurred when sending the request to the server.  (provider: TCP Provider, error: 0 - An existing connection was forcibly closed      by the remote host.) 

I even have a 1 G + log file.

The customer isn't happy with the performance of the application.

I can't produce this error in Development,do so I am guessing that the 2 severs are setup differently.

Additional Information:

There is no attempt to make Development and Production servers the same.

Production:

System: Microsoft Windows Server 2003 for Small Business Server Service Pack 2   Computer: Intel(R) Xeon(R) CPU E5310 @1.60GHz 1.60 GHz, 3.00 GB of RAM Physical Address Extension 

I believe the SQL Server is the SQL 2005 bundled with SBS.

The application is a WinForm program running on user's desktop systems.

I can't get onto the Development Server, but I'm sure that it exceeds the Production stats. I know that the SQL Server is 2005 Standard.

I have also run the program against a local SQL 2005 Express and not gotten any problems (and attached copies of the files from production).

Answers

The only times I have seen this error have been when the client and server have become forcibly disconnected, either because of the SQL service restarting or the network link being down.

The only reason I can think that would cause this to be a regular problem on in production and not development (if the to environments are otherwise identical) could be that in production the client (or the DB access libraries they use) are holding connections open for longer.

With the users reporting performance issues, it could be that you are having concurrency issues causing the server to become far to busy and connections to therefore timeout. Have you done any analysis on the server's performance metrics (memory/swap usage, disk IO, CPU use, SQL server specific performance counters, ...) during times when performance it poor?

Could you provide more detail of the setup? Are the client application(s) and database server all on the same machine? What versions/editions of SQL Server are you using and what access method are you using?

Related Articles

  • Transport-level errors, how do I setup SQL Server to avoid them?July 5

    I keep getting the following error (in the thousands) in production: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) I ev

  • A transport-level error has occurred in SQL Server when running AccessDatabaseEngine Linked Server QueryJanuary 18

    I have done this a thousand times, that is, setup the AccessDatabaseEngine on Windows 7 running SQL Server 2008 R2. This time I have done somethings differently, for instance I have Office 2016 installed, not 2013, I have both VS2013 and VS2015 insta

  • A Difficult Case of "A transport-level error has occurred when receiving results from the server" SQL ServerFebruary 20

    We are building a new BizTalk cluster, with two BizTalk Application Servers and two SQL Servers. From SSMS on BizTalk AppServer #1 (and similarly from #2), we have two scenarios: Current - our infrastructure team just rebuilt 2012/R2 Windows. It cann

  • transport-level error Sql ServerOctober 26

    I am facing Following Error: please help me in finding solution: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)". --------------Solutions----

  • Receiving Multiple Transport-Level Errors Across Entire FarmNovember 23

    For the past couple of days, all of the servers in my SharePoint 2013 farm have been reporting Critical 6398 errors with the following message: The Execute method of job definition Microsoft.Office.Server.Search.Administration.QueryClassificationDict

  • Can't restore database: A transport-level error has occurred when receiving results from the serverDecember 19

    This is not a good day for me. I have a backup (master.bak) for SQL Server 2005 Express SP4 (v.9.0.500) that I want to restore to my master db instance. I am running SQL Server in single-user mode (sqlservr.exe -m), connect to the instance, then I do

  • A transport-level error has occurred when sending the request to the serverMay 3

    In our Vb.net application(userd within a local network connection inside a office), which is used from long time now some of the users get the errors only sometimes a day A transport-level error has occurred when sending the request to the server. (p

  • Why is script with " xp_cmdshell " in comment failing with a transport level error?March 19

    When executing the following batch that is part of a large script: ... GO ----------------------------------------------------------------------------------------------- -- Removed the xp_cmdshell for deleting the backup file ------------------------

  • Parallel and A transport-level errorFebruary 1

    Im facing this following problem. Im using parallel to read lines from a file (being each line an complex object inside the code) and insert them on the DB. From time to time, i get the error: "A transport-level error has occurred when receiving resu

  • Recovering from: A transport-level error has occurred when sending the request to the server in SSMSJune 24

    Every now and than I loss the connection in SSMS and get the message Msg 121, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has

  • Setup SQL Server mirroringSeptember 4

    Is it possible to setup SQL Server mirroring and run it with only 1 server right now, then later add another server later? p.s I cant afford to do mirroring right now, and don't want reconfigure the primary server all over again later on to do mirror

  • Sqoop error while importing data from sql server to HDFSJanuary 17

    Getting below error while importing data from sql server to HDFS using sqoop: [email protected]:/lib$ sqoop list-databases --connect jdbc:sqlserver://192.168.127.1:6978 --username sa --password sa 16/01/17 10:35:32 WARN tool.BaseSqoopTool: Setting

  • Error duiring configure TFS with SQL Server

    Error duiring configure TFS with SQL ServerFebruary 5

    When try to install a TFS2013Express on my vm. Got an error during the connection of SQL Server database. If connect to SQL Server directly, everything works well. Appreciate for any help! --------------Solutions------------- According to your error

  • SSRS 2014 database setup - error "Using other editions of SQL Server for report data sources-" is not supported

    SSRS 2014 database setup - error "Using other editions of SQL Server for report data sources-" is not supportedJanuary 25

    I am setting up a new SQL Server 2014 Enterprise Reporting Services instance on a Windows Server 2012 R2 server. In Reporting Services Configuration Manager, when I select the SQL Server instance where I want to setup a new report database, the error

  • Permission error during installation of Microsoft SQL Server 2008 R2

    Permission error during installation of Microsoft SQL Server 2008 R2July 22

    During setup I get several errors like the one bellow and none of the service for SQL server get installed. I did quick google search but it seems like the only solution for resolving this issue is re-installation of the whole system which is not an

  • Error 18456 error severity 14 state 5 SQL Server 2012 SCCM2012 SP1November 22

    We had a primary site for SCCM 2012 SP1 running fine. I then installed CAS for SCCM on another server. The prerequisites required me to change the collation on the existing server. I did this and ran a rebuild database command at the same time. The S

  • Error updating zoned field from SQL Server stored procedure linked server to iSeriesMay 13

    I'm trying to update a table on an iSeries (AS400) within a SQL Server stored procedure using linked server, but it is failing when trying to update a column defined as zoned. In my stored procedure the value is defined as integer, and on the iSeries

  • Error when connecting to local SQL Server database October 8

    I am trying to build an ASP.NET MVC 5 Web Application which has a MyDatabase.mdf file in the App_Data folder. I have SQL Server 2014 Express installed with a LocalDb instance. I can edit the database tables using the Server Explorer, however when I d

  • Error while configuring mirroring, Microsoft SQL Server, error : 1418October 12

    I have a SQL Server 2008 Enterprise SP1 installed on my both principle and mirror server. SQL Server and SQL Server agent service is also started by same ID having sysadmin rights. But when I am trying to establish mirroring between them, it is refle

  • Execution-Policy Error running Powershell Script in SQL Server Agent

    Execution-Policy Error running Powershell Script in SQL Server AgentDecember 31

    Running a powershell script from SQL Server Agent in 2014 using my AD account via a credential. I am getting the following error. A job step received an error at line 1 in a PowerShell script. The corresponding line is 'set-executionpolicy RemoteSign

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.994 s.