Jump to content


adurrant

Issues with SQLCluster Reinstallation

Recommended Posts

Hello all,

 

I've ran into a few issues with SCCM 2012 R2 SP1, I have a remote 2 node SQL cluster, essentially one of the nodes failed a few months ago so it's been online for a while, during this time the SCCM DB was moved to this cluster, today the 2nd node is now online so I was expecting that SCCM was install what it needed on this server, I am however running into issues with SCCM thinking that a drive of E:\ exists in the sitecomp.log however this drive does not exist on the node, is there anyway of changing the path? or will I need to reset my SQL configuration again from the setup?

 

Sitecomp log:

 

Thread "SiteComp server polling Thread #1" id:2808 terminated normally $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.811-60><thread=2808 (0xAF8)>
The server already contains some of the required files for this component. A disk space check will not be made. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.831-60><thread=2736 (0xAB0)>
A network connection already exists to \\NAK-PG-CSQL1B\ADMIN$. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.831-60><thread=2736 (0xAB0)>
~Cannot create \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64, [error code: 67, error message: The network name cannot be found.]. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.837-60><thread=2736 (0xAB0)>
Could not copy file C:\Program Files\Microsoft Configuration Manager\bin\x64\smssqlbkup.exe to \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64\smssqlbkup.exe: Could not create directory \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64. The operating system reported error 0: The operation completed successfully.~~ $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.838-60><thread=2736 (0xAB0)>
INFO: 'NAK-PG-CSQL1B' is not a valid FQDN because the format is invalid. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.838-60><thread=2736 (0xAB0)>
A network connection already exists to \\NAK-PG-CSQL1B\ADMIN$. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.861-60><thread=2736 (0xAB0)>
Component SMS_MP_FILE_DISPATCH_MANAGER is running. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.864-60><thread=9672 (0x25C8)>
~Cannot create \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64, [error code: 67, error message: The network name cannot be found.]. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.865-60><thread=2736 (0xAB0)>
Could not copy file C:\Program Files\Microsoft Configuration Manager\bin\x64\srvboot.exe to \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64\srvboot.exe: Could not create directory \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64. The operating system reported error 0: The operation completed successfully.~~ $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.865-60><thread=2736 (0xAB0)>
INFO: 'NAK-PG-CSQL1B' is not a valid FQDN because the format is invalid. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.866-60><thread=2736 (0xAB0)>
A network connection already exists to \\NAK-PG-CSQL1B\ADMIN$. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.892-60><thread=2736 (0xAB0)>
~Cannot create \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64, [error code: 67, error message: The network name cannot be found.]. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.897-60><thread=2736 (0xAB0)>
Could not copy file C:\Program Files\Microsoft Configuration Manager\bin\x64\checkspn.exe to \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64\checkspn.exe: Could not create directory \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64. The operating system reported error 0: The operation completed successfully.~~ $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.897-60><thread=2736 (0xAB0)>
INFO: 'NAK-PG-CSQL1B' is not a valid FQDN because the format is invalid. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.898-60><thread=2736 (0xAB0)>
A network connection already exists to \\NAK-PG-CSQL1B\ADMIN$. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.918-60><thread=2736 (0xAB0)>
~Cannot create \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64, [error code: 67, error message: The network name cannot be found.]. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.923-60><thread=2736 (0xAB0)>
Could not copy file C:\Program Files\Microsoft Configuration Manager\bin\x64\vcredist_x64.exe to \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64\vcredist_x64.exe: Could not create directory \\NAK-PG-CSQL1B\E$\SMS_NAK-PG-SCCM01.NAK.CO.UK\bin\x64. The operating system reported error 0: The operation completed successfully.~~ $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.923-60><thread=2736 (0xAB0)>
INFO: 'NAK-PG-CSQL1B' is not a valid FQDN because the format is invalid. $$<SMS_SITE_COMPONENT_MANAGER><10-07-2015 10:59:00.923-60><thread=2736 (0xAB0)>
There is no E:\ Drive on NAK-PG-CSQLB
Any ideas? :)

post-17186-0-02231600-1444213527.png

Share this post


Link to post
Share on other sites

Hi Adurrant,

 

You have probably solved this by now but we just ran into the same issue here on SCCM 1602....

 

To solve this head to the Primary site server and open the registry.

 

Navigate to HKLM:\SOFTWARE\MICROSOFT\SMS\COMPONENTS\SMS_SITE_COMPONENT_MANAGER\Multisite Component Servers\"Cluster machine name"

 

There is a value with the name "Installation Directory"

Change the data of that to the correct drive letter.

Then open services on the Primary site server.

Restart the "SMS_SITE_COMPONENT_MANAGER" and watch the sitecomp.log for conformation of the fix.

 

Hope that helps someone if not yourself.

 

Cheers,

 

SCCMOG

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


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.