Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 2413104 - Last Review: September 20, 2010 - Revision: 2.0
Restoring Full-text Catalog in SQL Server 2005 removes SQLServer2005MSFTEUser ACL
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.
Steps to reproduce:
- In SQL 2005, Create a New catalog on a database.
- Go to FTDATA folder and view properties of the new catalog folder. You will see that we granted permissions to both SQLServer2005MSFTEUser and SQLServer2005MSSQLUser.
- Create a full-text index.
- Backup the database.
- Delete the database.
- Restore the database.
- View the permissions on the catalog folder in FTDATA.
Result: The SQLServer2005MSFTEUser account is NOT listed. Just SQLServer2005MSSQLUser
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
APPLIES TO
- 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
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate