Skip to main content
SQL server backup fails with SQL 6 error
Updated over 7 months ago

This article applies to:

  • OS: Windows

  • Product edition: Phoenix

Problem description

SQL server backup may fail with an SQL 6 error after changing the default SQL server port (1433).

Cause

The default SQL server port (1433) was changed using SQL Server Configuration Manager was not updated on ODBC Data Sources.

Traceback

The following error is saved to the Phoenix-xxxxxxxx-xxxxx-xxx.log

[2018-05-18 13:48:33,210] [INFO] Error[('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect)')] while getting product info for instance [<Name of the instance>]

Resolution

  1. Open ODBC Data Sources. (This application is located in the Windows Control Panel under Administrative Tools)

  2. Open ODBC Data Sources from the Administrative Tools list of the system.

  3. Open the System DSN tab.

  4. Select Data Sources as SQL Server.

  5. Click Client configuration and clear the Dynamically determine port checkbox.
    โ€‹
    โ€‹

    ODBCDataSourceAdmin.png
  6. Enter the correct port number.

  7. Click OK and Finish.

  8. Start an SQL server backup.

Contact Druva Support if the issue does not resolve.

Did this answer your question?