Hi,
I am facing an issue while connecting to SQL Server. It was working fine but after restarting the SQL server , i am getting the below error. Please help.
Below are the Failure Log
08/13/2021 15:43 Starting job "XXX DB Backup-30Mins " - “Full”. Server “TEST-SERVER”. Account “SYSTEM@WORKGROUP”. App v.“12.5.13”.
08/13/2021 15:43 Connecting to: Unknown. .\SQLEXPRESS.
08/13/2021 15:43 Job execution error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) > An existing connection was forcibly closed by the remote host
08/13/2021 15:43 Job "XXX DB Backup-30Mins " finished with “1” errors.
08/13/2021 15:43 Sending job log to XXX.xxxx@gmail.com.
Success Log
08/12/2021 23:50 Starting scheduled job "XXX_DB Backup-30Mins " - “Full”. Server “TEST-SERVER”. Account “user@XXX-SERVER”. App v.“12.5.13”.
08/12/2021 23:50 Connecting to: SQL RTM Express Edition (64-bit). .\SQLEXPRESS.
08/12/2021 23:50 Running SQL script before backup.
08/12/2021 23:50 SQL script has finished successfully.
08/12/2021 23:50 The temporary folder “E:\ Application\DB Backups\SQLBackupFTP Temp FOlder\Pranas.NET\SBF\b339981b-6253-4c96-a0fa-7435b0a4de8b\backup” has “462.27GB” free space.
08/12/2021 23:50 Backing up “.\SQLEXPRESS” SQL Server databases.
08/12/2021 23:50 Backing up “XXX_DB” with “Full” backup type.
08/12/2021 23:50 Database “XXX_DB” successfully backed up to “E:\TEST Application\DB Backups\SQLBackupFTP Temp FOlder\Pranas.NET\SBF\b339981b-6253-4c96-a0fa-7435b0a4de8b\backup\XXX_DB202108121950.bak : 15.476MB”.
08/12/2021 23:50 Compressing “E:\TEST Application\DB Backups\SQLBackupFTP Temp FOlder\Pranas.NET\SBF\b339981b-6253-4c96-a0fa-7435b0a4de8b\backup\XXX_DB202108121950.bak” file with Internal archiver. Encryption: “Off”.
08/12/2021 23:50 Backup of “XXX_DB” successfully compressed to “(XXX_DB202108121950.zip : 2.225MB)”.
08/12/2021 23:50 Connecting to “Folder” destination “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 Reading folder information by path: “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 The current destination folder is “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 Sending backup of “XXX_DB” to “Folder” destination “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 Uploading local “XXX_DB202108121950.zip” to remote “XXX_DB202108121950.zip” in folder “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 Uploaded 100.00 % (average speed = 371.98 MB/s).
08/12/2021 23:50 Verifying remote file “XXX_DB202108121950.zip” with local one “XXX_DB202108121950.zip”.
08/12/2021 23:50 Cleaning up backups of "XXX_DB DB Backup-30Mins " job.
08/12/2021 23:50 Cleaning up backups of “XXX_DB” database at “Folder” destination “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 Cleaning up “E:\TEST Application\DB Backups\SQLBackupFTP” folder.
08/12/2021 23:50 Deleting old backup of “XXX_DB”. Backup type: “Full”. Backup time: “08/10/2021 19:05:04”. Files: ““XXX_DB202108101905.zip””.
08/12/2021 23:50 XXX_DB202108101905.zip not found on the destination.
08/12/2021 23:50 Cleanup of “XXX_DB” completed.
08/12/2021 23:50 Running SQL script after backup.
08/12/2021 23:50 SQL script has finished successfully.
08/12/2021 23:50 Disconnecting from “Folder” destination “E:\TEST Application\DB Backups\SQLBackupFTP”.
08/12/2021 23:50 Job "XXX_DB DB Backup-30Mins " finished.
The difference which i can see in the both log is first and second line.I can see the account as "“user@XXX-SERVER” in success log but failed log it showing as “SYSTEM@WORKGROUP”.
Please help me on this issue.