cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

MSSQL Error 5402

Adalberto_Blanc
Level 3
Partner

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

 

 

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Does the SQL user also have local admin rights?

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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