Skip Ribbon Commands
Skip to main content

Markus' Blog

Mar 14
"Database is in compatibility range and upgrade is recommended" for BDCServiceDatabase after March 2013 Upgrade

After applying the March 2013 Update for SharePoint 2013 (, the BDC Databases in your farm might be in a state where they need upgrade. You can review the current database status in Central Admin | Upgrade & Migration | Review database status.


This state is ok, as long as it doesn't last too long. But at one day you need to upgrade the Database. The upgrade is no problem for SPContentDatabases, just use Upgrade-SPContentDatabase.

It is a little bit different for various Service Applications, especially for BDC. To get your BDC Databases to the latest state you can use the following PowerShell Commands:

(Get-SPDatabase | ?{$_.type -eq "Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}).Provision()

After this, your BDC-Databases should be up to date again.


If you get an error when trying to access the BCS Service Application from Central Admin, make sure that the application pool account has "SPDataAccess" on the BCS Database:



Thanks so much for this information.  This has been a problem since I did the upgrade.  How exactly did you find out about this sequence?  I've been looking all over?
4/9/2013 4:29 PM
That's an MCM secret ;-)  Just kidding - had the problem in an environment. Although the official documentation says - "Prepares a Microsoft SQL Server database for use with Microsoft SharePoint Foundation. If the database does not exist it will be created. If the database exists prior to calling the method, it will be provisioned with the SharePoint schema." - it seems to do an upgrade as well...
4/9/2013 5:08 PM
Very nice.  I linked to this posting from a TechNet thread about this topic.  Others were having the same problem.
4/9/2013 7:42 PM
4/18/2013 6:14 PM
This completely hosed my environment - beware
4/22/2013 10:05 PM
Do you have any further details about the problems? Did you check the permissions as stated in the end of my post?
4/22/2013 11:00 PM
Thank you, that was a bit complex :-)
4/23/2013 9:56 AM
Thank you so much Markus!

Great find! Your solution already speeds through various sites and Blogs (though, not all mention your Name...sadly).

8/6/2013 2:24 PM
Same issue - same fix. Thanks very much
9/16/2013 4:04 AM
Thanks! Same issue after March 2013 Public Updated installed and SharePoint Configuration Wizard had run.
11/1/2013 11:06 AM
1/9/2014 12:18 AM
This didn't work. The powershell command ran and i did an iis reset and restarted the timer service to be sure, but still not change the BDC_Service_Database is still showing as running in compatibility range.
4/1/2014 10:01 AM
Awesome! Thanks!
5/8/2014 2:17 PM
I just ran into this exact issue with the second release of SharePoint 2013 SP1.  My BCS database was the only one not upgraded so I did exactly what you outlined here for the March CU and everything is working now.  Very weird...
5/8/2014 5:57 PM
Agreed, hours of psconfig.exe re-runs did nothing (as it was recommended in the health analyzer) wasted hours!!  This did exactly what i needed it to do!!  Question, does this work similarly in the event i have other Service DB's that need upgraded?
6/4/2014 3:48 PM
Thank you!! I've been trying to upgrade that db all day and finally found your solution!
7/21/2014 10:49 PM
Thanks, after a nigh of upgrading with a lot of database upgrade erros this was the last one. Now I can get some sleep :)
7/24/2014 9:44 AM
You saved me..
7/24/2014 4:41 PM
Thank you very much. No issues what so ever.
7/25/2014 1:22 AM
Worked like a charm! Thanks for offering.
8/1/2014 8:25 PM
Your write up is concise, exactly outlines the problem and the solution. It also works exactly as presented. Thank you.
8/2/2014 2:29 PM
9/4/2014 4:01 PM
9/5/2014 8:51 PM
9/10/2014 3:52 PM
The BDC issue was my problem.  Thanks so much for your help!
9/12/2014 5:36 PM
Would I do this for all the DBs that need upgraded?
10/19/2014 8:07 PM
Thanks. This post helped with my upgrade!
10/26/2014 10:54 PM
Thanks - very helpful!
11/17/2014 5:53 PM
Thank you. Fixed mine too..
12/5/2014 2:52 PM
Thanks mate, much easier to parse than the official documentation.
12/24/2014 7:54 PM
1 - 30Next


There are no comments for this post.