SQL intelligent policy for DB on non standard port
Hi,
i've configured a new backup for db sql that is configured on non his default port. It's a two node cluster failover, and backup fail with this error:
12-gen-2024 19.47.38 - Info dbclient (pid=13684) INF - Intelligent policy initiated by server <bckprimary09>
12-gen-2024 19.47.38 - Info dbclient (pid=13684) INF - Intelligent policy <SQL-INT_WIN_2W_TEST> is valid. The input file <C:\Program Files\Veritas\NetBackup\dbext\mssql\input.7868.10680.0112124.194737> has been parsed successfully
12-gen-2024 19.47.39 - Info dbclient (pid=13684) INF - <GRFDMS100MM001> is a Failover Cluster Instance. Using virtual name <GRFDMS100MM001.domain.local>
12-gen-2024 19.48.09 - Info dbclient (pid=13684) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <-1><[Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. >.
12-gen-2024 19.48.09 - Info dbclient (pid=13684) DBMS MSG - SQL Message <-1><[Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.>
12-gen-2024 19.48.09 - Info dbclient (pid=13684) DBMS MSG - SQL Message <0><[Microsoft][SQL Server Native Client 11.0]Login timeout expired>
12-gen-2024 19.48.39 - Info dbclient (pid=13684) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <-1><[Microsoft][ODBC Driver 17 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. >.
12-gen-2024 19.48.39 - Info dbclient (pid=13684) DBMS MSG - SQL Message <-1><[Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.>
12-gen-2024 19.48.39 - Info dbclient (pid=13684) DBMS MSG - SQL Message <0><[Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired>
12-gen-2024 19.50.50 - Info dbclient (pid=13684) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <17><[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.>.
12-gen-2024 19.50.51 - Info dbclient (pid=13684) DBMS MSG - SQL Message <67><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).>
12-gen-2024 19.50.51 - Info dbclient (pid=13684) ERR - Unable to login into SQL instance <GRFDMS100MM001.griffon.local\GRFDMS100MM001> as user <sa> using standard connection.
12-gen-2024 19.50.51 - Info dbclient (pid=13684) ERR - Internal error. See the dbclient log for more information.
12-gen-2024 19.50.51 - Info dbclient (pid=13684) INF - ODBC connection setup failed
12-gen-2024 19.50.51 - Info dbclient (pid=13684) USER - This object has not been initialized
12-gen-2024 19.50.52 - Error bpbrm (pid=22538) from client grfdms100mm001: ERR - exit status: <2>
12-gen-2024 19.50.52 - Error bpbrm (pid=22538) from client grfdms100mm001: ERR - bphdb exit status = 2: none of the requested files were backed up
12-gen-2024 19.50.52 - Info bphdb (pid=7868) done. status: 2: none of the requested files were backed up
12-gen-2024 19.50.52 - end writing
none of the requested files were backed up (2)
Please someone has idea in order to resolve.
Thanks and Regards
Hi,
after many attempts, the problem was alias name on SQL connection manager.We added alias, and the backup succeded.
Regards,