When you restore a database with full-text catalog on a SQL Server 2005 server you will notice that the restore operation removes SQLServer2005MSFTEUser from the ACL list on the catalog folder in FTDATA.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
SQLServer2005MSFTEUser is a security group on the local server. You can manually add the ACL back to the folder using one of the following procedures.
- Option 1: Detach and reattach the database. This will reset the ACL permissions correctly
- Option 2: Manually add the pemisions using the following steps:
- Right click the catalog folder name under SQLServerInstallPath \Microsoft SQL Server\ MSSQL.X \MSSQL\FTDATA\ and choose Properties.
- In the properties window, select the Security tab
- Click Edit button.
- For the "Permissions for <Catalog Name> Folder," click the Add button.
- For the "Select Users, Computers, or Groups" Window, change the location to be the local machine name.
- For "Enter the object names to select", enter <macine name>\SQLServer2005MSFTEUser$<machine name>$MSSQLSERVER.
- Click Check Names to verify the name resolves to the correct group.
- Click OK to save the change.
- Click OK to close the "Permissions for <Catalog Name> Folder.
for other considerations.
Article ID: 2413104 - Last Review: September 20, 2010 - Revision: 2.0
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Evaluation Edition
- Microsoft SQL Server 2005 Everywhere Edition Community Technology Preview
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Workgroup Edition