Resolving Backup Data Dumping Error: [Microsoft][ODBC SQL Server Driver]Login Timeout Expired

Error While Dumping Backup Data on the Client Side: [Microsoft][ODBC SQL Server Driver] Login Timeout Expired

KB ID: 87
Causes:
This error is typically triggered when the system variables under environment variables lack proper path settings or have incorrect paths configured.
Solution:
To resolve this issue, follow these steps on the affected machine:
1. Right-click on "My Computer."
2. Select "Properties."
3. Choose the "Advanced" tab.
4. Click on "Environment Variables."
5. Under the "System variables" section, scroll down to find "Path," and then click on "Edit."
6. Specify the directory path pointing to the OSQL.exe file.
Example:
For SQL Server 2005, the OSQL Path is: "c:\Program Files\Microsoft SQL Server\90\Tools\binn\"
For SQL Server 2008, the OSQL Path is: "c:\Program Files\Microsoft SQL Server\100\Tools\binn\"

By ensuring the correct path settings in system variables, you can resolve the login timeout issue when dumping backup data on the client side in BDRSuite Client.

    • Related Articles

    • Error While Dumping MS SQL Backup Data in the Client

      KB ID: 115082 Error: Dumping MS SQL backup data fails at the BDRSuite client. Scenarios: The above error occurs at the BDRSuite client machine in the following scenarios: Cause 1: MS SQL database(s) configured for backup is set to offline. Solution: ...

    • Microsoft SQL Server Recovery

      Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...

    • Microsoft SQL Server Recovery

      Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...

    • Error while dumping backup data in the BDRSuite client

      KB ID: 101017 Cause: This error might arise during backup operations with the BDRSuite Backup Server when attempting to dump backup data using the BDRSuite Client. Solution: To address this matter, kindly reach out to our support team. Before doing ...

    • Adding Microsoft SQL Server for Backup

      MS SQL Server can be backed up using the BDRSuite Backup Server. You can simply add the MS SQL Host as a Data Source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add MS SQL Server. When a MS SQL Server ...