setup /testdbpgrade fails

[dinci5]

Hi there,

 

I need some help performing the testDBupgrade step before proceding with the actual upgrade.

I followed this procedure: https://www.systemcenterdudes.com/sccm-installation-testdbupgrade/

 

Current environment is: SCCM 2012 R2 SP1

I'm using the 1606 baseline installation media.
The SQL Server is the exact same version as the production server.
CMD is started with elevated rights.
SQL is not a named instance. (I first tried to do the test on a named instance, but that failed)

I'm receiving below error:

INFO: Executing SQL Server command: <IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('sys.availability_group_listener_ip_addresses') ) ~ SELECT count(*) FROM sys.availability_group_listener_ip_addresses ~ WHERE ip_address IN(SELECT local_net_address FROM sys.dm_exec_connections WHERE session_id = @@SPID) ~ELSE ~ SELECT 0> $$<Configuration Manager Setup><01-16-2017 14:25:54.745-60><thread=1552 (0x610)>
ERROR: Failed to execute query: IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('sys.availability_group_listener_ip_addresses') ) ~ SELECT count(*) FROM sys.availability_group_listener_ip_addresses ~ WHERE ip_address IN(SELECT local_net_address FROM sys.dm_exec_connections WHERE session_id = @@SPID) ~ELSE ~ SELECT 0 $$<Configuration Manager Setup><01-16-2017 14:25:54.745-60><thread=1552 (0x610)>
ERROR: Failed to detect whether always on is enabled or not. $$<Configuration Manager Setup><01-16-2017 14:25:54.746-60><thread=1552 (0x610)>
ERROR: Failed to connect to SQL Server testLabServer.DOMAIN.com to detemine if it is always on enabled, or failed to run the query. $$<Configuration Manager Setup><01-16-2017 14:25:54.746-60><thread=1552 (0x610)>
<01-16-2017 14:25:54> Failed to create process of SetupWpf.exe. return value 1

 

 

Attached you can find the complete log file.

 

ConfigMgrSetup.log

[T1mnl]

Check:

 

https://blogs.technet.microsoft.com/configurationmgr/2017/01/10/support-tip-running-testdbupgrade-does-not-complete-and-logs-failed-to-create-process-of-setupwpf-exe-error/

[dinci5]

Check:

 

https://blogs.technet.microsoft.com/configurationmgr/2017/01/10/support-tip-running-testdbupgrade-does-not-complete-and-logs-failed-to-create-process-of-setupwpf-exe-error/

 

Already checked that site.

It's not applicable for me.

 

Thanks

[dinci5]

FYI..
On my test server I was not a sysadmin.
The db_owner permission is not enough for the testdbupgrade.

You need to be a sysadmin.

problem solved