Skip to Content

There is a compatibility range mismatch between the Web server and database ...........

For a customer I build a webpart that extends the user profile database. We migrrated this application to 2010. In 2007 the picture profile DB was stored in the sam e webapp as the application, but because 2010 stores its pictures from my site in a special picture library OOTB, we wanted to use this piclib. The webpart errored:

There is a compatibility range mismatch between the Web server and database "............._Content_My", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range.

Also I saw the folowing error:

Unknown SQL Exception 262 occurred. Additional error information from SQL Server is included below.

CREATE TABLE permission denied in database '...._Content_My'.

After starting a profile trace, I noticed a security problem: the application pool identity of the webpart pool was different from the one used in the my site content DB (which is best practice). But unfortunatly it resulted in this error. Not a very nice error, but opening the my content db for the other service account resolved my issue.