.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Can anyone share their Successful Story in Upgrading WSS 3.0 SP2 and MOSS 2007 SP2 in Production env

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :SharePoint
Hi All,

Can anyone here share your story/ detailed step in Upgrading your WSS 3.0 and SharePoint 2007 SP1 Enviroment into Service Pack 2 ?

It seems to me that SP2 for any of those products could render the current environment useless.

Any comments and thought please ?

/* Windows Infrastructure Support Engineer */

View Complete Post

More Related Resource Links

Reg Upgrading List of MOSS 2007 to InfoPath 2010

Hi, Actually right now there is Newform.aspx of the list in MOSS 2007 through which we are collecting the data from the user.Now our customer is planning to migrate the application to SharePoint 2010 so i just want to know so that can we get a easy support to implement in InfoPath 2010 compared to the list of MOSS 2007 Thanks & Regards, Sudheer

Can we have both moss 2007 and sharepoint 2010 using a share SQL cluster?

Hello, I want to consolidate some server by using both SharePoint 2007 and SharePoint 2010 to use the same SQL 2008 R2 cluster. Is there any technical reason that should prevent to have both application to share same SQL server using different sql DB? Thanks

Upgrading servers in a MOSS 2007 farm from Windows 2003 SP2 to Windows 2003 R2

Are they any particular pitfalls to watch out for here?  We have two front ends in a load balance with an index server, andtwo SQL servers forming a failover cluster.

Error upgrading MOSS 2007 publishing site to 2010 - Exception: Column 'PublishingStartDate' does n


We are in the process of testing a database attach upgrade from MOSS 2007 to SharePoint Server 2010. We are running into an issue when we attach the database with the main portal site collection which has the publishing features enabled. In the upgrade error log, we are receiving the following errors:

[powershell] [CmsImageLibrarySiteAction (] [INFO] [10/21/2010 3:40:37 PM]: SPSite Url=http://<WEBAPP>.<COMPANY>.com
[powershell] [CmsImageLibrarySiteAction (] [ERROR] [10/21/2010 3:40:37 PM]: Failed to upgrade site collection images library on site http://<WEBAPP>.<COMPANY>.com.
[powershell] [CmsImageLibrarySiteAction (] [INFO] [10/21/2010 3:40:37 PM]: SPSite Url=http://<WEBAPP>.<COMPANY>.com
[powershell] [CmsImageLibrarySiteAction (] [ERROR] [10/21/2010 3:40:37 PM]: Exception: Column 'PublishingStartDate' does not exist. It may have been deleted by another user.
[powershell] [CmsImageLibrarySiteAction (] [INFO] [10/21/2010 3:40:38 PM]: SPSite Url=http://<WEBAPP>.<COMPANY>.com
[powershell] [CmsImageLibrarySiteAction (] [ERROR] [10/21/2010 3:40:38 PM]:    at Microsoft.SharePoint.SPFieldCollection.GetField(String strName, Boolean bThrowException)
   at Microsoft.SharePoint.SPViewFieldCollection.Add(String

Error upgrading MOSS 2007 SSP database/user profiles to 2010


I am trying to use the new-spprofileserviceapplication powershell script to do a db attach/upgrade of my 2007 SSP to upgrade the user profiles.

New-SPProfileServiceApplication -applicationpool User_profile_service_app_pool -Name "User Profile Application" -Profiledbname prodsspconfig2 -Profiledbserver dbname\int

It gets a certain way and then errors out with the following error:

[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]: Action of Microsoft.Office.Server.Upgrade.ProfileDatabaseSequence failed.
[powershell] [ProfileDatabaseSequence] [INFO] [10/22/2010 12:13:56 PM]: ProfileDatabase Name=prodsspconfig2
[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]: Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ProfileTypePropertyAttributes_PropertyList". The conflict occurred in database "ProdSSPConfig2", table "dbo.PropertyList".
The statement has been terminated.
[powershell] [ProfileDatabaseSequence] [INFO] [10/22/2010 12:13:56 PM]: ProfileDatabase Name=prodsspconfig2
[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowE

Share built in reports in MOSS 2007


Wondering if there is any way that users that are not Site Admins can be given access only to the site usage reports found at (Web Portal > Site Settings > Site Collection Usage Summary)?

I'd like to provide mgmt with the ability to quickly view site stats to gain an understanding of portal usage without having to implement costly external reporting packages.  Any recommendations are greatly appreciated.  Thanks in advance.

"User cannot be found" error when creating My Site after upgrading to SP2 for MOSS 2007



Hope this is the place for sharepoint gurus?

I upgraded MOSS2007/WSS3 to SP2 and since then I have been unable to get My Site to create new sites for existing domain users.

Some of the domain users created their My Site before the SP2 upgrade and they still work. We just cannot create new My Sites for existing domain users.

Now when we try to create a My Site we get this error:

"There has been an error creating the personal site. Contact your site administrator for more information."

I checked the event logs and usually no error is recorded when this happens so sharepoint does not even give me a breadcrumb (thanks!).

However, on one occassion I did get an event message after fiddling here and there and many attempts at trying to create a My Site, hooray! See below for all the glorious details of the event message, but the basic error is:

"User cannot be found".

I have checked the My Site settings of shared services (SSP1), veiwed user profiles, all the domain users are imported. So I have no idea why when creating a My Site it fails?

I have searched many forums and although they get the same error it seems to be for different reasons so the solutions don't help my situation.

Is there somewhere in Sharepoint that these domain users need to exist? Would I be able to c

MOSS 2007 Tutorials video

This link about how create sharepoint website ,blogs,team site,document lib etc

AJAX in MOSS 2007

These days implementing AJAX in sharepoint has become a important request for share point applications.

Here i'm explaining how to create and deploy a AJnAX webpart in step by step manner

Master Pages in MOSS 2007

'MasterPages' feature in sharepoint 2007 makes the entire customization job easy.In 2003 we used to face lot of issues to get the same look and feel and the standard behaviour for overall site. In 2007, customizing the look and feel for the entire site can be done in a simple way by using 'MasterPage' feature.

Content Types in MOSS 2007

In this article I will try to describe the one of the best feature in Microsoft office Share Point 2007 called Content Types.

Content types are simply collection of contents.Each content in a Content type can have different settings.Basically it is a reusable collection of settings which you want to apply to a particular category of contents.

MOSS 2007: Automate Web App Deployment with the SharePoint API


Learn how to automate custom SharePoint application deployments, use the SharePoint API, and avoid the hassle of custom site definitions.

E. Wilansky, P. Olszewski, and R. Sneddon

MSDN Magazine May 2008

MOSS 2007 and MySite in Outlook

Looking to get the My Site feature working in Outlook 2007 when you right click someone's name in an email. I've followed this (http://support.microsoft.com/kb/968115) and I can add/remove various fields but when it comes to the My Site feature it nevers show a link to the users Sharepoint My Site. It's strange because the URL for people's My Site is in AD. It's not like I even get a error message where the My Site option should be - the field never displays...help!

Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



Primary Key In Share Point 2007/ 2010


Can I create 3 columns Primary key in a list using the MOSS 2010 or 2007

Actually My requirement  is

I collect some information by Country,State,Dist wise Temperature


1.  India-Andraprades-Hyderabad-Temp-30

2.  India-Andraprades-KarimNagar-Temp-30

here first 2 column is Same but 3rd column is different that's I required 3 column is Primary Key


Any one help me.



MOSS 2007 License and Pricing

I just need a small help related to MOSS 2007 License and Pricing.

The scenario is that we have the following number of servers and users are 750.

# moss-SQl1 - (DB server 1)
# moss-SQl2 - (Mirrored DB server 2)
# moss-app -    (Application server)
# WFE1 -  (Web front end server 1)
# WFE2 -           (Web front end server 2)
# MOSS-SQLWITNESS –   (witness server for database mirroring)

To my understanding we need to purchase:
MOSS 2007 Server Licenses -- 2 @ 4424$
Enterprise CALs           -- 750 @ 75$ + 94$ for standard CAL

and it amounts to: 2 * 4424 + (75+94) * 750 =   8848 + 126750 = 135598$.

I think this calculation has gone wrong somewhere. Could you please correct me if I assumed anything wrong here.

One more question is: If we purchage one CAL, can this be used by only one user?

Thanks, Chandralekha

Checkout/Chevk in issue in MOSS 2007 while connecting through VPN(virtual private network)


HI, I am using VPN connection . When I try modify a file and try to checkin the file in sharepoint document library it does not gets checked in. I get a message saying

"Unable to checkin the file, since File is being edited in Local Draft, please close the application or discard the checkout ".

Please do the needful....



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend