Home > SharePoint Problems/Issues > Update Database Schema on SharePoint Server and SQL Server Database

Update Database Schema on SharePoint Server and SQL Server Database

I’ve ran into this problem numerous of times, and this usually happens when there are new IAVA’s or security patches installed onto the SharePoint server to address vulnerabilities.  After applying these IAVAs or patchs and rebooting the  SharePoint server your portal site might error out with this message: 

Unable to Connect To Configuration Database.

If you check your event logs you might run across this error: 

“The Schema Version 3.0.149.0 of the database is not consistant with the expected database schema version 3.0.151.0.  Connections to this database from the server have been blocked to avoid data loss, upgrade the web front end or the content database to ensure that these versions match.”

—– To fix this problem on the web front end (Sharepoint Server): 

1.  Start -> run -> cmd

2.  At the command prompt browse to:

C:\Program Files\common files\web server extensions\12\bin

3.  Once at the C:\Program Files\common Files\Microsoft Shared\web server extensions\12\bin

directory run this command:

psconfig -cmd upgrade -inplace b2b -wait force

4.  This will upgrade the database schema on the Sharepoint server with the SQL server.

5.  Attempt to browse the portal again.  This should fix the inconsistant database schema issues.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: