Manually update site database help

So I ran the CU4 updater and it all went fine except for a warning for perform database update.  looking at the logs it says along the lines of this: The EXECUTE permission was denied on the object fnIsPrimary,database CM_LAB, schema dbo so i figured it was a permissions error so i asked another member of my team to run the update.sql file in the sql management studio and he sent me back this screenshot of results.  My question is, is this the expected results, how can I tell the db was actually upgraded?

April 28th, 2015 5:11pm

It is not supported to do what you have done. You should contact CSS to get support on this issue.
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2015 6:12pm

What does the above indicate?  What we did was shut down the sccm server and then run this sql file.  Perhaps if the sccm server was on it wouldn't have given that screen.  Can we just run/try it again?  Our SCCM server is on a separate server from the sccm sql server.
April 29th, 2015 8:57am

As long you didn't receive an error when running the script, it should have been successful and the 0 in the first column is indicative of this. You may still want to reach out to CSS though to confirm as this separate DB update process isn't explicitly documented anywhere.
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 9:10am

Whats the best way to get ahold of CSS?
April 29th, 2015 10:24am

It is not supported to do what you have done. You should contact CSS to get support on t
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 4:35pm

So there is no way to tell if it successfully updated the database?  I wasn't the one who ran the update i just provided the guy with the file and he sent me a screenshot which i uploaded of what its output was.  I've never ran an update manually so I wasn't sure what it was supposed to look like.
April 29th, 2015 6:18pm

None of that is explicitly documented in anything publically available. You can certainly open the file and see what it updates though and perform a manual comparison.

CSS is Microsoft Customer Support Services. A quick web search will reveal the correct number for you to call.

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 6:41pm

So there is no way to tell if it successfully updated the database?  

What was displayed on the 'messages' tab?

You could also restore a copy of the pre-CUx-database to another SQL server and run the SQL script again so you can see what's happening.

April 30th, 2015 2:33am

I'm not sure what was on the messages tab. I don't think he ever looked. Say hypothetically it didn't upgrade the database. What ramifications would that have to sccm if we just kept using it until the next cu comes out? Not that I would like to do that but it would be simpler just to make sure and run the next cu update as a user who has sysadmin rights on SQL to avoid having to manually do it.
Free Windows Admin Tool Kit Click here and download it now
April 30th, 2015 8:03am

Any ideas on what ramifications would that have to sccm if we just kept using it until the next cu comes out?
May 6th, 2015 4:44pm

Don't know. If the update didn't take, then you'd be unsupported and all kinds of weird things could break.

CU5 just came out yesterday though and SP1 for R2 will be out next week (this may be referred to as SP2 in some place --- it's the same t

Free Windows Admin Tool Kit Click here and download it now
May 7th, 2015 6:50pm

Great, Ill just update to SP1 for R2 and see how that goes and make sure I am using an account that has the proper permissions.  I'm pretty sure the update took it just cant verify it.  We haven't had any issues thus far.
May 8th, 2015 9:01am

Great, Ill just update to SP1 for R2 and see how that goes and make sure I am using an account that has the proper permissions.  I'm pretty sure the update took it just cant verify it.  We haven't had any issues thus far.
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2015 1:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics