14,494 questions
Connection Issue of SQL server when running bcp command from windows bat file.
![](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(265.6, 83%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWZ%3C/text%3E%3C/svg%3E)
Winnie zhang
106
Reputation points
We have a bat file which contains several bcp and SQLCMD commands to bulk insert the data for the tables and execute some SQL files.
However, the connection is not stable for some environments. And the error happened randomly. And it may resolved when re-execute the commands.
The error is :
“Connection established is forcefully closed by remote host”.
I saw the link https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-exist-connection-closed
However, this could not resolve the error. Please kindly suggest.
SQL Server Other
{count} votes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-08-21T21:23:23.6266667+00:00 Check the SQL Server errorlog for messages that coincide with these connection errors.
-
![](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)
Anonymous2023-08-30T09:17:23.44+00:00 Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
-
Winnie zhang 106 Reputation points
2023-08-31T01:09:23.5466667+00:00 We are still investigating
-
Winnie zhang 106 Reputation points
2023-09-01T06:18:12.19+00:00 I checked the SQL server error log
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2023-09-01T21:08:24.75+00:00 And the database name you have masked out is the database that BCP or SQLCMD tried to connect to? And that is an existing database?
Since you seemed to be getting a transient error that disappears on next attempt, this is not the error message I would expect to see in the errorlog for that situation. Not there have to be anything in the errorlog, as this could be a network problem.
-
Winnie zhang 106 Reputation points
2023-09-04T00:44:02.8533333+00:00 Yep The database is there. And below is the log files information for the session
Below screenshot is the sql server log. There is no special for network issue.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2023-09-04T20:12:34.05+00:00 Those messages about setting database options are a little surprising, but I guess the script you are running includes the ALTER DATABASE commands to set these options. (Which should not be needed.)
I'm afraid that I don't have any other idea than this may be a network issue.
Sign in to comment
Sign in to answer