Hi all, i have WSS 3.0 installed on Windows Server 2008, the database is running on Windows Server 2003 with SQL Server 2005 then i upgrade the SQL server to Windows Server 2008 using SQL Server 2008. i move the database using the steps mentioned in this link: http://pointofshare.blogspot.com/2009/08/moving-sharepoint-database-to-another.html but when i run stsadm -o renameserver -oldservername <myoldsqlserver> -newservername <mynewsqlserver> i received this error: An update conflict has occured, and you must retry this action. The object SPServer name=mynewsqlserver Parent=SPFarm Name=SharePoint_Config is being updated by domain \username , in the stsadm process, on machine mySharePointserver. View the tracing log for more information about the conflict. but, when i check on the Central Adminstration Page, my sql server already changed to the new server. it's juts that, the top level site (ie. http://mySharePointServer:1234) can't be accessed. but, the site beneath it were able to be accessed (ie. http://mySharePointServer:1234/sales, http://mySharePointServer:1234/finance, etc) the error returned when i'm accessing the top level is: An error occurred during the processing of . Could not load file or assembly 'RSWebParts, Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. anybody know why i received this message? thanks!AddinGanteng

An update conflict has occured, and you must retry this action. The object SPServer name=mynewsqlserver Parent=SPFarm Name=SharePoint_Config is being updated by domain \username , in the stsadm process, on machine mySharePointserver. View the tracing log for more information about the conflict. This is usually solved by clearing the Cache ini as specified here : http://support.microsoft.com/kb/939308/en-us The second error suggests that Reporting services solution is not installed on this server or the feature is incorrectly deployed. Check the Reporting Services installation on the Sharepoint and SQL Victor

Hi, thanks for the reply. I've performed the steps mentioned. change the cache.ini file to 1, but after restarting Windows SharePoint Timer Service, i still got 1 on the cache.ini file, it's not the value that was saved before i changed it. any other procedures to perform? Thanks!!!AddinGanteng

Hi, You need to installthe Reporting services webParts that you were using with SQL 2005 Copy the RSWebParts.cab to a folder on the SharePoint server. The .cab is installed with Reporting Services. By default, it is located in the C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint folder. You can copy it to any folder on the SharePoint server, and then delete it later after you install the Web Parts. On the computer that has the installation of the SharePoint product or technology, open a Command Prompt window and navigate to the folder that has the Stsadm.exe tool. The path will vary depending on which version of Windows SharePoint Services you are running or if you running SharePoint Foundation 2010. For example, if you are using Windows SharePoint Services 3.0, the path is C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN. Run Stsadm.exe on the .cab, using the following syntax: STSADM.EXE -o addwppack -filename "C:\ Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall -Ivan Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.

Hi, thanks! i've tried the steps, below is the error message i received each time i run the syntax c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa dm.exe -o addwppack -filename "C:\Program Files\Common Files\Microsoft Shared\We b Server Extensions\12\BIN\RSWebParts.cab" -globalinstall The specified Web Part Package is already installed. To reinstall the package, u se the -force parameter. c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa dm.exe -o addwppack -filename "C:\Program Files\Common Files\Microsoft Shared\We b Server Extensions\12\BIN\RSWebParts.cab" -globalinstall -force You cannot deploy this solution on this type of server computer as it is configu red. This solution must be installed on a server of type: front-end Web server. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN\RSWe bParts.cab: The Web Part deployment failed. any ideas what to do next? thanks!AddinGanteng

Hi, Try to clear your local server file system cache. For more information, please refer to: http://support.microsoft.com/kb/939308/en-us Hope it is helpful!Seven