Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 306492 - Last Review: April 23, 2002 - Revision: 1.0
STS: Error Message: Unable to Prepare Tables in Database...
This article was previously published under Q306492
When you try to extend a virtual server with Sharepoint Team Services from Microsoft and you use a separate server running Microsoft SQL Server 2000 for the database, the following error message appears:
Unable to prepare tables in database "xxxx". The database may be corrupt.
This problem can occur if the SQL Server is using case sensitive collation.
To resolve this problem, use case-insensitive collation on the Web site based on SharePoint Team Services. To change the standard collation setting for your SQL Server, install a new named SQL Server instance so that you can specify a correct, case-insensitive collation during the installation. When you install the new instance, make sure that you specify the correct TCP port for communication with Sharepoint Team Services.
To transfer your databases to the new named instance, follow the guidelines in the SQL Server 2000 documentation.
Sharepoint Team Services assumes a case insensitive collation because URLs and so on, are case insensitive on Windows platforms. A SQL Server with case sensitive collation is not supported.
For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
310932Â
(http://kbalertz.com/Feedback.aspx?kbNumber=310932/EN-US/
)
FP2002: Where to Find the SharePoint Team Services Administrator's Guide
APPLIES TO
- Microsoft SharePoint Team Services
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