Multi-instance of SCCM2002 AlwaysOn database produces SQL configuration manager certificate problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1715439%22%20slang%3D%22zh-CN%22%3EMulti-instance%20of%20SCCM2002%20AlwaysOn%20database%20produces%20SQL%20configuration%20manager%20certificate%20problem.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715439%22%20slang%3D%22zh-CN%22%3E%3CP%3EMigrate%20the%20main%20site%20and%20the%20management%20center%20site%20to%20the%20Alwayson%20multi-instance%20database%20server%2C%20%3CBR%20%2F%3E%20Once%20a%20member%20of%20the%20database%20server%20is%20restarted%2C%20the%20SQL%20configuration%20certificate%20generated%20in%20the%20first%20SCCM%20migration%20will%20always%20become%20%3CBR%20%2F%3E%20invalid.%20Note%20that%20is%20fine%20fine%20without%20restarting%20the%20database%20members.%3C%2FP%3E%3CP%3EAs%20a%20result%2C%20you%20can't%20log%20in%20and%20connect%20to%20SQL%2C%20why%20that%20you%20can%20connect%20to%20the%20local%20security%20organization%2C%20and%20then%20clear%20the%20certificate%20in%20the%20SQL%20configuration%20management%20tool%20or.%20Select%20the%20last%20migrated%20SQL%20configuration%20certificate%20and%20restart%20the%20SQL%20service%2C%20you%20can%20log%20in%20to%20the%20SQL%20management%20tool%2C%20although%20SQL%20can%20log%20in.%20The%20SCCM%20console%20still%20can%20be%20logged%20in.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDoes%20the%20Alwayson%20environment%20not%20support%20multi-instance%20databases%20to%20host%20multi-site%20database%20environments%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22al.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222347iDA19229496B18F53%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22al.png%22%20alt%3D%22al.png.%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22al2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222348iA0016F026695DC68%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22al2.png%22%20alt%3D%22al2.png.%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CAS%20al3.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222349iFD111FD0EA84C18C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22CAS%20al3.png%22%20alt%3D%22CAS%20al3.png.%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22al%E4%B8%8D%E9%94%99%E6%97%A5%E6%97%A5%E5%BF%97.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222350i387EF5D510444A25%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22al%E4%B8%8D%E9%94%99%E6%97%A5%E6%97%A5%E5%BF%97.png%22%20alt%3D%22al%20good%20day%20log.png.%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22%E6%B8%85%E9%99%A4.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222351iC16995B59D0659AD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22%E6%B8%85%E9%99%A4.png%22%20alt%3D%22Clear.png.%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22666.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222357i919A8CED5355C5FE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22666.png%22%20alt%3D%22666.png.%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22888.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222358i5F2B806625BB93EC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22888.png%22%20alt%3D%22888.png.%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1715439%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EAlwayon.%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECM%202002.%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESccm.%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Migrate the main site and the management center site to the Alwayson multi-instance database server,
Once a member of the database server is restarted, the SQL configuration certificate generated in the first SCCM migration will always become invalid.
Note that everything is fine without restarting the database members.

As a result, you can't log in and connect to SQL, prompting that you cannot connect to the local security organization, and then clear the certificate in the SQL configuration management tool or select the last migrated SQL configuration certificate and restart the SQL service, you can log in to the SQL management tool, although SQL can log in. The SCCM console still cannot be logged in


Does the Alwayson environment not support multi-instance databases to host multi-site database environments?

 

 

al.pngal2.pngCAS al3.pngal不错日日志.png清除.png666.png888.png

0 Replies