MSSQL Error 5402

Question

Hello everybody,&nbsp;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.&nbsp;Iam getting the error&nbsp;18:32:20.937 [4796.9544] &lt;2&gt; 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 313118:32:20.937 [4796.9544] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 479618:32:20.937 [4796.9544] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:21.608 [4796.9544] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4796.0.0116117.183220" -pjobid 313118:32:24.140 [4796.8352] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:24.656 [4796.9544] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:24.656 [4796.9544] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4796.0.0116117.183220" -pjobid 3131&gt;18:32:24.656 [4796.9544] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:24.656 [4796.9544] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:24.656 [4796.9544] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:24.656 [4796.9544] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:25.890 [13576.14812] &lt;2&gt; 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 313218:32:25.890 [13576.14812] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 1357618:32:25.890 [13576.14812] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:26.375 [13576.14812] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13576.0.0116117.183225" -pjobid 313218:32:26.484 [13576.12968] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:27.390 [13576.14812] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:27.390 [13576.14812] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13576.0.0116117.183225" -pjobid 3132&gt;18:32:27.390 [13576.14812] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:27.390 [13576.14812] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:27.390 [13576.14812] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:27.390 [13576.14812] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:31.125 [9368.14772] &lt;2&gt; 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 313318:32:31.125 [9368.14772] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 936818:32:31.125 [9368.14772] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:31.703 [9368.14772] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.9368.0.0116117.183231" -pjobid 313318:32:31.938 [9368.1500] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:32.719 [9368.14772] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:32.719 [9368.14772] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.9368.0.0116117.183231" -pjobid 3133&gt;18:32:32.719 [9368.14772] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:32.719 [9368.14772] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:32.719 [9368.14772] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:32.719 [9368.14772] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:36.297 [6472.2444] &lt;2&gt; 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 313418:32:36.297 [6472.2444] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 647218:32:36.297 [6472.2444] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:36.766 [6472.2444] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.6472.0.0116117.183236" -pjobid 313418:32:36.938 [6472.14060] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:37.782 [6472.2444] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:37.782 [6472.2444] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.6472.0.0116117.183236" -pjobid 3134&gt;18:32:37.782 [6472.2444] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:37.782 [6472.2444] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:37.782 [6472.2444] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:37.782 [6472.2444] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:41.501 [832.8200] &lt;2&gt; 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 313518:32:41.501 [832.8200] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 83218:32:41.501 [832.8200] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:42.142 [832.8200] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.832.0.0116117.183241" -pjobid 313518:32:42.236 [832.9276] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:43.157 [832.8200] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:43.157 [832.8200] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.832.0.0116117.183241" -pjobid 3135&gt;18:32:43.157 [832.8200] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:43.157 [832.8200] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:43.157 [832.8200] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:43.157 [832.8200] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:46.767 [13896.8952] &lt;2&gt; 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 313618:32:46.767 [13896.8952] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 1389618:32:46.767 [13896.8952] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:47.408 [13896.8952] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13896.0.0116117.183246" -pjobid 313618:32:47.502 [13896.6532] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:48.424 [13896.8952] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:48.424 [13896.8952] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.13896.0.0116117.183246" -pjobid 3136&gt;18:32:48.424 [13896.8952] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:48.424 [13896.8952] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:48.424 [13896.8952] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:48.424 [13896.8952] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:52.049 [4128.13372] &lt;2&gt; 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 313718:32:52.049 [4128.13372] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 412818:32:52.065 [4128.13372] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:52.643 [4128.13372] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4128.0.0116117.183252" -pjobid 313718:32:52.705 [4128.14528] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:32:53.659 [4128.13372] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:32:53.659 [4128.13372] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4128.0.0116117.183252" -pjobid 3137&gt;18:32:53.659 [4128.13372] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:32:53.659 [4128.13372] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:32:53.659 [4128.13372] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:53.659 [4128.13372] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:32:57.378 [4088.9240] &lt;2&gt; 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 313818:32:57.378 [4088.9240] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - BACKUP START 408818:32:57.378 [4088.9240] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received18:32:57.706 [4088.9240] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - Processing "C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4088.0.0116117.183257" -pjobid 313818:33:00.159 [4088.7412] &lt;2&gt; debuglog: &lt;16&gt; 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 131418:33:00.753 [4088.9240] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - failed to validate OS credentials18:33:00.753 [4088.9240] &lt;2&gt; debuglog: &lt;16&gt; bphdb: failed executing command &lt;"C:\Program Files\Veritas\NetBackup\bin\dbbackex.exe" -np -s mxveritas -ipf "input.4088.0.0116117.183257" -pjobid 3138&gt;18:33:00.753 [4088.9240] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - exit status: &lt;5402&gt;18:33:00.753 [4088.9240] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - Error code: 540218:33:00.753 [4088.9240] &lt;2&gt; debuglog: &lt;16&gt; bphdb: ERR - bphdb exit status = 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials18:33:00.753 [4088.9240] &lt;2&gt; debuglog: &lt;4&gt; bphdb: INF - EXIT STATUS 5402: OS Authentication error - Could not connect to the database. Please check the OS credentials&nbsp;&nbsp;

marianne · Answer

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

marianne · Answer

Does the SQL user also have local admin rights?

adalberto_blanc · Answer

Hello Marianne.The user has local admin rights on the SQL server, Also I had read this thechnote&nbsp;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.&nbsp;Best regards

marianne · Answer

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

Forum Discussion

MSSQL Error 5402

4 Replies

Related Content

Restore MSSQL error

Oracle backups fail with status code: 5402

MSSQL Restore error

mssql with transactions logs be truncated

MSSQL backup