Wednesday, June 24, 2026

SCCM 2012 R2 SQL DB migration

Issue reported:

We have physical SQL box and while moved DB to virtual Box after moving getting below error. 

Failed to connect to the SQL Server, connection type: SMS ACCESS.

INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure

ERROR: SQL Connection failed. Connection: SMS ACCESS, Type: Secure

ERROR: Failed to get SQL Server connection.

Solution:

Step 1: Validate configmgrsetup.log and found this error Error: Failed to find file: D:\SCCM\SCCM 2012 R2 Preq Files\msxml6_x64.msi

Step 2: Copied the msxml6_x64.msi file to SCCM 2012 R2 Preq Files folder and certificate got auto created and the task got completed smoothly.

Reference URL for SQL Migration Once of The MVP Has update realtime solution For more details  Click Here

Happy learning!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr
Twitter: https://twitter.com/hiraniconfigmgr

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest posts