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®ards,
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
X
1 Comments
Oscar munoz romero
24-07-2019 03:31 amThanks, you did in the nail. I found that error and then i found my files and copy them.