February 27, 2015 at 2:15 pm
Hi All
Earlier this year I ran Windows Updates on my server and along with those updates was the install for SP2 KB2958429-x64. The SP2 install was not successful so I tried to uninstall and it failed. Please view the attachment for the results.
Now this weekend I would like to install SP2 that I downloaded from Microsoft instead of the Windows Updates. My question is that when I look at the recently installed updates I found that SP2 says it is installed but the database engine doesn't reflect that it was installed. Has anyone run into this?
My plan this weekend is to try to uninstall the SP2 again and see what messages I get, reboot, and then try and install SP2 that I downloaded from Microsoft.
Thanks
Kathy
February 27, 2015 at 2:53 pm
The attachment shows the uninstall was successful on the database engine. It failed on the Data tool, integration services, and Data Quality Client. Do you have these items installed on your server? what does SELECT @@version return?
All three of the failing uninstalls are shared features so there is connection there but i am unsure why the uninstall is failing. You can look at the setup log for more info. should be at C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\summary.txt
March 1, 2015 at 8:23 am
The select @@version returns 'Microsoft SQL Server 2012 - 11.0.2100.60[x64]
March 2, 2015 at 6:33 am
Well I tried the install of Service Pack 2 on SQL Server 2012 again. I have a series of error messages.
Error: 2714, Severity: 16, State 5
"There is already an object named 'DatabaseMailUserRole' in the database."
Error: 2759, Severity: 16 State 0
The failed batch of t-sql statements: are attached
I did try an uninstall and the only successful result was the database engine. I'm having problems. I will continue with my research online but if any one has input I would appreciate it.
When I run select @@version the result is Microsoft SQL Server 2012 - 11.0.2100.60[x64]. It seem like the other objects are updated but the db engine is not. I can't seem to get a clean slate to begin a new install.--this is just a guess.
March 2, 2015 at 9:14 am
the script that is failing is checking whether the DatabaseMailUsersRole exists in msdb and if it does whether there are users in it. It doesnt seem to do anything if there are members in the role. Does this role exist and are there any members in it?
If it does exists you could try dropping the role and try to run the service pack again. this part of the script should recreate the role.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply