Solved

Upgrading to a WSS 3.0 site, by upgrading the WSS 2.0 database to use as content database

Posted on 2007-11-28
3
494 Views
Last Modified: 2008-02-01
I am trying to upgrade one existing WSS 2.0 site, to WSS 3.0 site, by creating a brand new site, then attach and upgrade the existing WSS 2.0 DB.  I tried running the following command: stsadm -o addcontentdb -url -databasename -databaseserver, but get the following errors below.  I configured the site not to use Search service as well.

[SPContentDatabaseSequence] [ERROR] [11/28/2007 10:34:18 AM]: Action 3.0.2.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
[SPContentDatabaseSequence] [ERROR] [11/28/2007 10:34:18 AM]: The Microsoft Search service cannot be administered under the present user account
[SPContentDatabaseSequence] [ERROR] [11/28/2007 10:34:18 AM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Any ideas?

0
Comment
Question by:ejk2007
  • 2
3 Comments
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 500 total points
ID: 20367565
the second error listed sounds like an authentication problem

try here:
http://www.mcse.ms/message1108947.html
http://benchristian.com/archives/93.html (has to do with MS CRM, but the concept behind the problem is similar)

basically, you should review your sql & sharepoint service accounts
0
 

Author Comment

by:ejk2007
ID: 20367782
The services accounts are identical.  Does anyone know how to remove the Search feature in WSS 3.0?
0
 

Author Comment

by:ejk2007
ID: 20368808
Found the problem.  Didn't have rights to the Full Text Catalog.  Deleted it, and it worked.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question