摘要:SQL 2005 裝 Service Pack失敗 - Error 29506
錯誤訊息
MSP Error: 29506 SQL Server Setup failed to modify security permissions on file c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user *****.
To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
啟用file audit後發現上service pack時，會存取c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data裡的所有mdf及ldf檔。即使mdf, ldf檔並沒有對應到任何online的DB，仍需將權限開放給執行service pack的帳號，service pack才會成功。(很奇怪ㄟ.....)