MSSQL Error 5402

[Adalberto_Blanc]

Hello everybody,

I would like to ask if you know about the error 5402 on the MSSQL server client. I have setted up the Netbcackup client Service with a user with SQL Rights.

Iam getting the error

18:32:20.937 [4796.9544] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613119 -jobid 3131

18:32:20.937 [4796.9544] <2> debuglog: <4> bphdb: INF - BACKUP START 4796

18:32:20.937 [4796.9544] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:21.608 [4796.9544] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4796.0.0116117.183220" -pjobid 3131

18:32:24.140 [4796.8352] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4796.0.0116117.183220" -pjobid 3131 -impersonating' error 1314

18:32:24.656 [4796.9544] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:24.656 [4796.9544] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4796.0.0116117.183220" -pjobid 3131>

18:32:24.656 [4796.9544] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:24.656 [4796.9544] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:24.656 [4796.9544] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:24.656 [4796.9544] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:25.890 [13576.14812] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613120 -jobid 3132

18:32:25.890 [13576.14812] <2> debuglog: <4> bphdb: INF - BACKUP START 13576

18:32:25.890 [13576.14812] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:26.375 [13576.14812] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13576.0.0116117.183225" -pjobid 3132

18:32:26.484 [13576.12968] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13576.0.0116117.183225" -pjobid 3132 -impersonating' error 1314

18:32:27.390 [13576.14812] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:27.390 [13576.14812] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13576.0.0116117.183225" -pjobid 3132>

18:32:27.390 [13576.14812] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:27.390 [13576.14812] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:27.390 [13576.14812] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:27.390 [13576.14812] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:31.125 [9368.14772] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613121 -jobid 3133

18:32:31.125 [9368.14772] <2> debuglog: <4> bphdb: INF - BACKUP START 9368

18:32:31.125 [9368.14772] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:31.703 [9368.14772] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.9368.0.0116117.183231" -pjobid 3133

18:32:31.938 [9368.1500] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.9368.0.0116117.183231" -pjobid 3133 -impersonating' error 1314

18:32:32.719 [9368.14772] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:32.719 [9368.14772] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.9368.0.0116117.183231" -pjobid 3133>

18:32:32.719 [9368.14772] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:32.719 [9368.14772] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:32.719 [9368.14772] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:32.719 [9368.14772] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:36.297 [6472.2444] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613122 -jobid 3134

18:32:36.297 [6472.2444] <2> debuglog: <4> bphdb: INF - BACKUP START 6472

18:32:36.297 [6472.2444] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:36.766 [6472.2444] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.6472.0.0116117.183236" -pjobid 3134

18:32:36.938 [6472.14060] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.6472.0.0116117.183236" -pjobid 3134 -impersonating' error 1314

18:32:37.782 [6472.2444] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:37.782 [6472.2444] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.6472.0.0116117.183236" -pjobid 3134>

18:32:37.782 [6472.2444] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:37.782 [6472.2444] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:37.782 [6472.2444] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:37.782 [6472.2444] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:41.501 [832.8200] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613123 -jobid 3135

18:32:41.501 [832.8200] <2> debuglog: <4> bphdb: INF - BACKUP START 832

18:32:41.501 [832.8200] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:42.142 [832.8200] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.832.0.0116117.183241" -pjobid 3135

18:32:42.236 [832.9276] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.832.0.0116117.183241" -pjobid 3135 -impersonating' error 1314

18:32:43.157 [832.8200] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:43.157 [832.8200] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.832.0.0116117.183241" -pjobid 3135>

18:32:43.157 [832.8200] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:43.157 [832.8200] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:43.157 [832.8200] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:43.157 [832.8200] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:46.767 [13896.8952] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613124 -jobid 3136

18:32:46.767 [13896.8952] <2> debuglog: <4> bphdb: INF - BACKUP START 13896

18:32:46.767 [13896.8952] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:47.408 [13896.8952] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13896.0.0116117.183246" -pjobid 3136

18:32:47.502 [13896.6532] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13896.0.0116117.183246" -pjobid 3136 -impersonating' error 1314

18:32:48.424 [13896.8952] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:48.424 [13896.8952] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13896.0.0116117.183246" -pjobid 3136>

18:32:48.424 [13896.8952] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:48.424 [13896.8952] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:48.424 [13896.8952] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:48.424 [13896.8952] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:52.049 [4128.13372] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613125 -jobid 3137

18:32:52.049 [4128.13372] <2> debuglog: <4> bphdb: INF - BACKUP START 4128

18:32:52.065 [4128.13372] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:52.643 [4128.13372] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4128.0.0116117.183252" -pjobid 3137

18:32:52.705 [4128.14528] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4128.0.0116117.183252" -pjobid 3137 -impersonating' error 1314

18:32:53.659 [4128.13372] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:32:53.659 [4128.13372] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4128.0.0116117.183252" -pjobid 3137>

18:32:53.659 [4128.13372] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:32:53.659 [4128.13372] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:32:53.659 [4128.13372] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:53.659 [4128.13372] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:32:57.378 [4088.9240] <2> logparams: -sb -rdbms sql_server -S mxveritas -to 300 -c Siglo_BINVSFESQL_BD_SQL -s Full_SQL_Diario -clnt binvsfesql -intelligent_db_opts -FULL -auto -kl 28 -b binvsfesql_1484613126 -jobid 3138

18:32:57.378 [4088.9240] <2> debuglog: <4> bphdb: INF - BACKUP START 4088

18:32:57.378 [4088.9240] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received

18:32:57.706 [4088.9240] <2> debuglog: <4> bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4088.0.0116117.183257" -pjobid 3138

18:33:00.159 [4088.7412] <2> debuglog: <16> bphdb: Unable to spawn command '"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4088.0.0116117.183257" -pjobid 3138 -impersonating' error 1314

18:33:00.753 [4088.9240] <2> debuglog: <16> bphdb: ERR - failed to validate OS credentials

18:33:00.753 [4088.9240] <2> debuglog: <16> bphdb: failed executing command <"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4088.0.0116117.183257" -pjobid 3138>

18:33:00.753 [4088.9240] <2> debuglog: <16> bphdb: ERR - exit status: <5402>

18:33:00.753 [4088.9240] <2> debuglog: <16> bphdb: ERR - Error code: 5402

18:33:00.753 [4088.9240] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

18:33:00.753 [4088.9240] <2> debuglog: <4> bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials

[Marianne]

Does the SQL user also have local admin rights?

[Marianne]

See this TN:
http://www.veritas.com/docs/000111251

[Adalberto_Blanc]

Hello Marianne.

The user has local admin rights on the SQL server, Also I had read this thechnote https://www.veritas.com/support/en_US/article.000111251 and also added the user to the local security policy.

I have not restarted the server yet becasue I am working on a production enviroment.

Are there any way to update the local security policy without restart the server?

Tankyou so much.

Best regards

[Marianne]

You need to ask your Windows admin/support team that question....