Config_Mgr_noob Posted December 19, 2016 Report post Posted December 19, 2016 Hello, I am trying to upgrade my primary site to 1511 but running into some road blocks when performing the testdbupgrade prereq list. At first, the error is indicating Unsupported ConfigMgr Database version. But as I open the ConfigMgrSetup.log, I noticed its not able to open the database to verify the site version (which is 5.00.8239.1000). I have attached some screenshots below to show the errors. Can someone assist or guide me to a step that I might be overlooking? Thanks in advance. Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 20, 2016 Report post Posted December 20, 2016 what version is your SQL server, the version needed is listed in your last screenshot Quote Share this post Link to post Share on other sites More sharing options...
Config_Mgr_noob Posted December 20, 2016 Report post Posted December 20, 2016 Within our production SQL server, its 11.0.5388.0 and I believe I have 11.0.2100.60 on the test environment. Could this be the culprit? If so, is there a quick way to upgrade to that particular version only? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 21, 2016 Report post Posted December 21, 2016 well 11.0.5388.0 is somewhere between SQL Server 2012 SP2 and SP3 according to https://sqlserverbuilds.blogspot.se/your other version (test env) is using SQL Server 2012 RTM so you must update it to SP2 prior to doing the testdbupgrade Quote Share this post Link to post Share on other sites More sharing options...
Config_Mgr_noob Posted December 21, 2016 Report post Posted December 21, 2016 Just upgraded to the version below which matches the production SQL server except for the operating system version number and the Microsoft Data Access Components (MDAC) and still no go; exact same error message within the ConfigMgrSetup.log. Not sure if those component versions matter? Can't see what else I can try to get the test going. Any other suggestion, Anyweb? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 21, 2016 Report post Posted December 21, 2016 ok and the first message about 'login failed' are you using the same user account in both environments ? Quote Share this post Link to post Share on other sites More sharing options...
Config_Mgr_noob Posted December 23, 2016 Report post Posted December 23, 2016 Are you referring to the user account that writes to the database or the local user account on the SCCM box? Would you be able to let me know where I can confirm the account? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 23, 2016 Report post Posted December 23, 2016 it's the service (user) account you use to install SCCM and to be able to login to SQL Server Management Studio when you did the new pre-req check after updating SQL to the supported version is it still complaining about the SQL version ? Quote Share this post Link to post Share on other sites More sharing options...
Config_Mgr_noob Posted December 23, 2016 Report post Posted December 23, 2016 I've tried 2 accounts to run the test, the account I used to install SCCM initially and the account I use for the network access account SCCM uses, and still no avail. After I did the upgrade to the version above, it's still screaming the exact same error messages. I've added both accounts to the SQL server as owners, local admin to the test server and still unable to connect to the SQL server. Not sure what I'm overlooking at this point. Any other location I can look into? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted December 23, 2016 Report post Posted December 23, 2016 can you open the db mentioned using SQL Server Management Studio ? Quote Share this post Link to post Share on other sites More sharing options...
