Skip to content

setup /testdbpgrade fails

Featured Replies

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

  • Author

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.