Regarding Service Pack 2 for SQL Server 2005

May 18th, 2007 by Kurt Wolf

A common bug I have run into is a security message saying that the application does not have permission to the data folder. The only way to properly identify this message is to read through the installation log file.

I have increased my chances of getting the service pack to properly install by resetting the file permissions where I keep my data. See the screenshot. The key is to replace permissions on the child objects. This is found on the properties of the data directory (or the location of your SQL system databases), sharing tab, advanced button.

security_setting.jpg


0 Responses to “Regarding Service Pack 2 for SQL Server 2005”

  1. No Comments

Leave a Response