VMware Cloud Community
EddiePav
Contributor
Contributor

VDP 6.0 backup of SQL 2012 SP2 fails with "Error"

VDP 6.0

vSphere 6.0

SQL 2012 SP2 running on Windows 2012 R2

Installed and configured a single database with the 64bit SQL Agent,

Made sure the NT AUTHORITY\SYSTEM account had sysadmin role.

Run backups and it says Error.

Inside Configuration Log i see the following:

07/28/2015 18:35:37: Backup of  "sql2012-01.brsvlab.local" from job named "SQL backups" completed.

07/28/2015 18:35:37: Task execution failed.

07/28/2015 18:35:29: Error: An attempt was made to backup or restore a client and an incompatible option was specified. This is probably due to using an older client version that does not support the option.  An example is backing up a pre-4.1.0 client when server authentication is enabled or specifying and encryption method of None when server authentication is enabled.

07/28/2015 18:35:29: Backup job named "SQL backups" started.

SQL Server agent log only has the following:

****** Current MCS name 'vdp-01.brsvlab.local' ******

2015-07-28 18:36:22 avagent Info <7502>: Registration of client /clients/VDPApps/sql2012-01.brsvlab.local with MCS vdp-01.brsvlab.local:28001 successful.

2015-07-28 18:36:22 avagent Info <5928>: Registration of plugin 3023 update successful.

2015-07-28 18:36:22 avagent Info <5928>: Registration of plugin 3001 Windows successful.

2015-07-28 18:36:22 avagent Info <5928>: Registration of plugin 3006 SQL successful.

2015-07-28 18:36:22 avagent Info <5928>: Registration of plugin 3015 VSS successful.

2015-07-28 18:36:22 avagent Info <5619>: Registration of client and plugins complete.

2015-07-28 18:36:22 avagent Info <7189>: first work request delayed for 180 seconds.

2015-07-28 18:37:05 avagent Info <5962>: Wake up message received

2015-07-28 18:37:05 avagent Info <7190>: first work request delay finished.

2015-07-28 18:37:05 avagent Info <5964>: Requesting work from vdp-01.brsvlab.local

2015-07-28 18:37:05 avagent Info <5264>: Workorder received: sleep

2015-07-28 18:37:05 avagent Info <5996>: Sleeping 1602 seconds

Tags (3)
0 Kudos
2 Replies
EddiePav
Contributor
Contributor

I found a workaround by using the SQL Authentication method in the Configure advanced options panel.

0 Kudos
RolfW81
Enthusiast
Enthusiast

Have you tried the NT-Authentification again?

0 Kudos