Skip to content

SCCM and SQL AG

Featured Replies

Hi All,

I hope you are well,

Currently I have an issue I have unsuccessfully been battling with for a few days now.

The original plan was to have the sccm db running on a sql high availability always on group setup.

1 x primary server

1 x sup server

1 x dp server

2 x sql servers

when I tried to install SCCM initially, on the clustered sql, I was getting issues with listener admin rights / ports

Excerpt from sccm install log ---------------

CWmiRegistry::GetStr: Failed to get string value MSSQLSERVER     Configuration Manager Setup     06/03/2018 16:05:16            92 (0x005C)

Failed to retrieve SQL Server instance name[MSSQLSERVER].        Configuration Manager Setup     06/03/2018 16:05:16            92 (0x005C)

WARNING: failed to retrieve port number for XXX-SCCM-LST.ncc.local.     Configuration Manager Setup     06/03/2018 16:05:16            92 (0x005C)

WARNING: failed to retrieve port number for XXX-SCCM-LST.ncc.local.     Configuration Manager Setup     06/03/2018 16:05:16            92 (0x005C)

 

---------------- End of Excerpt

XXX-SCCM-LST = sql listener

this is a named instance on the sql (SCCM) and the sql port is 1433 /broker 4022

Why is it looking for MSSQLSERVER ?

why failing to retrieve port ?

 

So - I recently gave up and installed SCCM on a named server (not the listener) (SERVER-A - which is to be used in the HA cluster) sccm installs and works fine.

I have installed the DB on a single box, and SCCM is looking good and functioning / patched up to 1710 + hotfix.

OK - So I think I can do SCCM site maintenance, and change the DB location to the SQL Listener. But no same errors in logs again.

 

Any one got any ideas or further experience with sql availability groups and are we missing something simple.

Hope to hear back from anyone

Regards,

WAZZIE

 

 

 

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.