December 1, 2016 at 6:07 am
I'm having a problem updating one of our instances with a cumulative update. Error is below. The first thing I find is this link from MS saying it's a permission issue with the setup account. Now as far as I can tell, both my account and the service account have all the necessary permissions. But I'm still getting the error.
Which makes me wonder... What is the setup account? Is it the account I'm logged into the server as? Is it the service account? Or is there another account I'm overlooking?
Error details:
§ Error installing SQL Server Management Services
The Installer has insufficient privileges to modify this file: D:\Program Files\Microsoft SQL Server\110\Tools\Binn\bcp.exe.
Error code: 1321
Log file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20161130_234324\ROADSD1\sql_ssms_Cpu64_1.log
December 1, 2016 at 11:29 am
I broached this issue to my coworkers. Turns out the system account owned all the folders in question, not allowing us to make changes to them via the install package, even though we were all local admin on the server. We had to take ownership of the folders in order to properly run the CU.
Something hinky happened to the permissions on that server several months ago. We're thinking about going back, revoking all the share / drive perms, then re-adding them one at a time and testing to ensure we get them set up correctly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply