edie209 Posted December 16, 2019 Report post Posted December 16, 2019 I am trying to recover my SCCM 1806 site. I have a full site backup but it fails restoring the database. I have rebuilt the server to the same version as before and then installed all the prerequisites including SQL and ADM wsus etc. however it fails when restoring the database. I have included the portion of the log file that is relevent(changing my site name and username) is there anything I may have got wrong is there another way of recovering? Steps I have taken are selected "recover site" recovered the site server from my backup location recovered my database from my backup location entered serial number accept terms downloaded required files select installation folder Details of SQL are pre populated path to SQL server DATA file is prepopulated path to SQL server LOG file is prepopulated At this point I am presented with the install settings, then it presents the prerequisite check and then begins the install where it fails with the errors seen on the log file attached sccmlog.txt Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 16, 2019 Report post Posted December 16, 2019 check the username/password specified in sql, that's where it's failing, see below snippet... ERROR: Failed to restore databases. $$<Configuration Manager Setup><12-13-2019 14:41:31.500+00><thread=3800 (0xED8)> *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sitename\user'. cheers niall Quote Share this post Link to post Share on other sites More sharing options...
edie209 Posted December 16, 2019 Report post Posted December 16, 2019 Thanks for the quick reply The user that it is installing with is my domain admin account, and its using Windows Authentication would I have to enter the password in SQL elsewhere ? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 16, 2019 Report post Posted December 16, 2019 look in SQL under logins, see what logins are there, add your account as SQL SysAdmin if you are not sure what to do Quote Share this post Link to post Share on other sites More sharing options...
edie209 Posted December 16, 2019 Report post Posted December 16, 2019 Thanks for that I have just gone into sql management studio and this is the permissions my account has Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 16, 2019 Report post Posted December 16, 2019 what account was used before with the database mentioned ? Quote Cannot open database "cd_ste" requested by the login. The login failed. Quote Share this post Link to post Share on other sites More sharing options...
edie209 Posted December 16, 2019 Report post Posted December 16, 2019 I have two accounts on SQL my admin account and a SCCM Admin account that was the account used, yet on the recovery it seems to use my admin account possibly because I am logged in as a domain admin not the sccm admin? Should I be logged in as the sccm admin to recover the site? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 16, 2019 Report post Posted December 16, 2019 normally you should use service accounts, but in your case, your sccm login is probably what you need, try it... Quote Share this post Link to post Share on other sites More sharing options...
edie209 Posted December 16, 2019 Report post Posted December 16, 2019 Ok I will try with that and get back to you Thank you Quote Share this post Link to post Share on other sites More sharing options...
edie209 Posted December 16, 2019 Report post Posted December 16, 2019 That has failed too, I am going to uninstall sql and go back through the steps to see if I might have missed something on the install Quote Share this post Link to post Share on other sites More sharing options...
