Jump to content


Recommended Posts

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

 

 

 

Share this post


Link to post
Share on other sites


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...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...