Tag Archives: SharePoint2010

Microsoft, SBS 2011, Service Pack 1, Service Pack 1, SharePoint, SharePoint 2010, SharePoint Foundation 2010, Small Business Server 2011, Windows

[RESOLVED] Companyweb SharePoint 2010 Page will not load – Small Business Server 2011

01/03/2012 Stuart Davey

Lets start by taking a look under “c:\Users” if you find multiple TEMP.DOMAINNAME.XXX folders then read on.

You may see the following two events logged together in the Application Event Log on the SBS 2011 Server and both reference the DOMAINNAME\spwebapp

Log Name: Application

Source: User Profile Service

Event ID: 1500

Lvel: Error

Windows cannot log you on because your profile cannot be loaded. Check that you are connected to the network, and that your network is functioning correctly.

DETAIL – The system cannot find the file specified.

and

Log Name: Application

Source: User Profile Service

Event ID: 1501

Lvel: Error

Windows cannot create a temporary profile directory. This problem may be caused by insufficient security rights.

DETAIL – The system cannot find the file specified.

You may also see the following event logged in the System Event Log on the SBS 2011 Server

Log Name: System

Source: WAS

Event ID: 5022

Lvel: Warning

The Windows Process Activation Service failed to create a worker process for the application pool ‘SBS Sharepoint AppPool’. The data field contains the error number.

If you are seeing the above errors then you need to cut and paste all the TEMP.DOMAINNAME.XXX folders from “c:\Users” into a “new folder” on your desktop for example (you should not need these temp profiles again but it’s best to keep them to one side). Once you no longer have any of these folders in the “C:\users” directory we need to launch “Internet Information Services (IIS) Manager” from Administrative Tools and then expand the server and click on “Application Pools”. Once in “Application Pools” you need to stop the three highlighted Pools “SBS Sharepoint AppPool”, “SharePoint Central Administration v4” and “SharePoint Web Services Root”. Once all three are stopped wait about 10-20 seconds and then start these three stopped Pools.

Now that you have followed all these steps launch your web browser and try to navigate to http://companyweb and your SharePoint site should load correctly. Please note that the Companyweb SharePoint site might take 20-30 seconds to load the first time whilst the profile is re-created, after this it should be nice and fast.

How to find the version, edition, Service Pack and Cumulative Update Version of Microsoft SQL Server and its associated components

09/12/2011 Stuart Davey Leave a comment

If you want to find out the version and edition of Microsoft SQL Server then please take a look at Microsoft KB 321185 http://support.microsoft.com/kb/321185

This will show you how to find versions for SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012

SQL Server 2005

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 2 http://support.microsoft.com/kb/937137

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 3 http://support.microsoft.com/kb/960598

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 4 http://support.microsoft.com/kb/2485757

SQL Server 2008

Microsoft SQL Server 2008 Cumulative Updates that have been released since SQL Server 2008 – RTM http://support.microsoft.com/kb/956909

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 1 http://support.microsoft.com/kb/970365

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 2 http://support.microsoft.com/kb/2402659

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 3 http://support.microsoft.com/kb/2629969

SQL Server 2008 R2

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released since SQL Server 2008 R2 – RTM http://support.microsoft.com/kb/981356

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 1 http://support.microsoft.com/kb/2567616

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 2 http://support.microsoft.com/kb/2730301

SQL Server 2012

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – RTM http://support.microsoft.com/kb/2692828

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – Service Pack 1

http://support.microsoft.com/kb/2772858

Microsoft, Powershell, SBS 2011, SharePoint, SharePoint 2010, SharePoint Foundation 2010, Small Business Server 2011, Windows, Windows Server 2008 R2

Microsoft SharePoint 2010 and Microsoft SharePoint Foundation 2010 – Running PSConfig to Update SharePoint Database after installing Service Packs and Hotfixes

28/10/2011 Stuart Davey

If you read my last post you will already know how to check if Microsoft SharePoint 2010 and Microsoft SharePoint Foundation 2010 needs to have PSConfig run to complete the last step of patching SharePoint 2010.

You will need to open an elevated “Command Prompt”, this can be done by “right clicking” on the “Command Prompt” shortcut (Start Menu, Accessories) and then selecting “Run as administrator”.

Once in the command prompt you need to change to the directory containing PSCONFIG, you can do this by copying and pasting the line below in to the command prompt and then pressing “Enter”

cd C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN

You should now find yourself in the correct directory and can copy and paste in the PSCONFIG command below into the “Command Prompt” window and hit “Enter”.

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

This command will require around 5-10 minutes to complete, be patient and do not try to quit the command whilst it is running even if the percentage counter does not appear to be going up for a while. Once it’s complete I would suggest rebooting the server to ensure the changes take effect.

Please note that this command will stop the SharePoint Site from working whilst the upgrade is running and is also likely to temporarily stop Terminal Services Gateway and some other IIS sites from being served up to users.

I would strongly suggest performing this task out of business hours or scheduling in a 60 minute slot during the day where users can logout of any server based applications, web sites or services. I’d also not recommend trying to initialise the command whilst connected to the server using Remote Web Access/Workplace, this is only really applicable for SBS 2011 users. Best to be physically infront of the server, use an IP KVM or establish a VPN connection and then RDP to the servers internal address or hostname using the “Microsoft Remote Desktop Client”.

Microsoft, Powershell, SBS 2011, SharePoint, SharePoint 2010, SharePoint Foundation 2010, Small Business Server 2011, Uncategorized, Windows, Windows Server 2008 R2

Microsoft SharePoint 2010 and Microsoft SharePoint Foundation 2010 – Powershell Script to identify if PSConfig Update is Required after installing Service Packs and Hotfixes

28/10/2011 Stuart Davey Leave a comment

Installing Hotfixes/Service Packs for Microsoft SharePoint 2010 and Microsoft SharePoint Foundation 2010 is a two step process now. First you should install the service pack or hotfix and then you need to verify if PSConfig needs to be run. PSConfig normally always needs to be run as this updates the actual SharePoint databases.

Not completing the PSConfig command where required can cause SharePoint search failures and Sharepoint backups may stop working correctly on the server.

To simplify the process of identifying which SharePoint servers require the PSConfig update I have put together a Powershell script that will return a simple answer to the question of do I need to run PSConfig or not. The example below also includes “Exit 0” and “Exit 1” in the script, this is only really required for GFI Max Remote Management users. The Exit codes tell the GFI max Remote Management software to either pass or fail the script check so that a red cross appears on the server monitoring dashboard to alert administrators that action is required on that server.

If you do not use GFI Max Remote Management or you only want the script to report the need for a PSConfig upgrade then simply remove the lines with “Exit 0” and “Exit 1” on and then you can just save this is a Powershell script on your server desktop and run it manually.

Add-PSSnapin Microsoft.SharePoint.PowerShell

$NEEDSUPGRADE = (get-spserver $env:computername).NeedsUpgrade

If ($NEEDSUPGRADE | Where {$_ -eq “True”})

{

Write-Host “SharePoint Upgrade Required”

Exit 1

}

Else

{

Write-Host “No Upgrade Required”

Exit 0

}

My next post will tell you how to run the PSConfig command to update your SharePoint 2010 database if required.

Aid In IT

Tag Archives: SharePoint2010

IT – Software and Hardware Support Resources