Detailed Installation Step for SQL server 2008 R2 – CU8 upgrade

Detailed Installation Step for SQL server 2008 R2 – CU8 upgrade 

 

Installation Step for SQL server 2008 R2 – CU8 upgrade

NOTE: Downtime required

 If the Servers are in Failover Clusters, please follow the below steps:

[2 active nodes and 1 passive nodes]

[Active Node A, Active Node B, Passive node C]

1.    Upgrade Node C.

2.    failover one instance from Node A to Node C . Now node C is running one instance and Node A has become passive node

3.    Upgrade the node A.

4.    failover one instance from Node B to Node A . Now node A is running one instance and Node B has become passive node

5.    Upgrade the node B.

OR,

[3 active nodes and 1 passive nodes]

[Active Node A, Active Node B, Active Node C, Passive node D]

1.    Upgrade Node D.

2.    failover one instance from Node A to Node D . Now node D is running one instance and Node A has become passive node

3.    Upgrade the node A.

4.    failover one instance from Node B to Node A . Now node A is running one instance and Node B has become passive node

5.    Upgrade the node B.

6.    failover one instance from Node C to Node B . Now node B is running one instance and Node C has become passive node

7.    Upgrade the node C.

 

 

SQL CU08 upgrade steps:

 

 Step 1 :

                    File name :  SQLServer2008R2-KB2871401-x64

                double click on the binary

                              

                Click Continue.

                                                                                     

 Step 2 : Click “Next” to proceed.

                                         

                                                                                                 

 Step 3 : Check the “I accept the license terms” and hit “Next”

                                                       

Step 4: Ensure INSTANCES are selected and hit “Next”                                                                                                                                                

 Step 5: After the checking is completed, hit “Next” to proceed.                                                                                                                                    

  Step 6: Click on “Update” to continue

             

               

                         Installation in progress:                                                                                                                          

                                                                 

                             Upgrade completed:
                                                     

                             Click Close.

   Step 7 : Server will be restarted to take effect. Press “Ok” to reboot the server.

                          Note: if server not rebooted automatically, Do manual reboot.

Step 8 : After the server is rebooted. Perform the following few verifications:

Go  SQL Management Studio > Help tab > About…

                                      Versions Should be as below : 10.50.4290.0

                                                                                   

  Check in Control Panel > Programs and features > at left pane, click on “ View installed Updates” > Ensure “KB2871401” is in the list.

                                        

                                                                                                                                                 Once the Upgrade is Done Check the SharePoint Central Admin page and rest All web sites are working.               

Face book Authentication Implementation in SharePoint 2010

Now a day’s many people has a face book account. So was checking if it possible to use the same as Authentication for the SharePoint site.

I have not yet tried this at my end Due to some Limitations of our Network,However found this Step by Step Instructions very interesting and Helpful . Follow the below link to get done face book Authentication.

http://ovaismehboob.wordpress.com/2011/09/07/configuring-facebook-authentication-in-sharepoint-2010

Features and Enhancements of SharePoint 2010

   Below are the Top  SharePoint Server 2010 features.

http://vlele.wordpress.com/2009/10/22/top-10-sharepoint-server-2010-features

 What’s new in SharePoint 2010?

http://msdn.microsoft.com/en-us/library/ee557323(v=office.14).aspx

   New Features and enhancements

http://www.sharepointkings.com/2010/05/sharepoint-2010-features-and.html

   SharePoint 2010 Enhancements for End Users:

http://community.bamboosolutions.com/blogs/sharepoint-2010/archive/2009/08/21/sharepoint-2010-enhancements-for-end-users-improved-look-amp-feel-and-the-ribbon-comes-to-sharepoint.aspx

http://sharepoint.microsoft.com/en-us/Product/Pages/Feature-Details.aspx?Capability=Sites&FeatureID=17

http://sharepoint.microsoft.com/en-us/product/Pages/Features.aspx?Capability=Content

http://sharepoint.microsoft.com/en-us/product/Pages/Features.aspx?Capability=Sites

http://sharepoint.microsoft.com/en-us/product/Pages/Features.aspx?Capability=Communities

Psconfig Steps at each task

Psconfig Steps at each task

           

check out What happens when we run the Post Setup configuration Wizard . After setup is run the post setup configuration wizard must be run to complete the process of either creating a new farm or joining a server to an existing farm.

Step 1 -      Initialize SharePoint products and technologies configuration

  Note - It Initializes the configuration and has very less chances of failing on this step.

Step 2 -    Create Configuration database.

   Note - It creates a new configuration Database in the SQL. You need to have proper rights to create a database.

    http://technet.microsoft.com/en-us/library/cc678863%28v=office.14%29.aspx

 Setup user account - The Setup user account is used to run the following:

·        Setup

·        SharePoint Products Configuration Wizard

·        Domain user account.

·        Member of the Administrators group on each server on which Setup is run.

·        SQL Server login on the computer that runs SQL Server.

·        Member of the following SQL Server roles:

·        securityadmin fixed server role

·        dbcreator fixed server role

If you run Windows Power Shell cmdlets that affect a database, this account must be a member of the db_owner fixed database role for the database.

If you find an issue Connecting SharePoint to the SQL server. Create a UDL file and check for the  connectivity. For further information on UDL check the link below

http://blogs.msdn.com/b/farukcelik/archive/2007/12/31/basics-first-udl-test.aspx

Step 3 -      Install help collections

Step 4 -       Secure SharePoint resources

Step 5 -      Register SharePoint Services

·        Successfully provisioned service: Windows SharePoint Services  Usage.

·        Successfully installed service instance: Windows SharePoint Services Usage

·        Successfully provisioned service instance: Windows SharePoint Services Usage

·        Successfully installed service: Microsoft.SharePoint.BusinessData.SharedSBdcService.

·        Successfully provisioned service: Microsoft.SharePoint.BusinessData.Sharee.BdcService.

 Step 6 -   Register SharePoint features

·        Successfully installed feature C:\Program Files\Common Files\Microsoft Sh…

·        Server Extensions\14\Template\Features\SPSearchFeature\Feature.xml.

·        Successfully installed feature C:\Program Files\Common Files\Microsoft Sh

·        b Server Extensions\14\Template\Features\TenantAdmin\feature.xml.

Step 7 -    Provision Central Administration Web application and site if   Standalone install.

Step 8 -    Register SharePointHealth Analysis rules

Step 9 -    Create sample data and provision default Web application

Step 10 -   Install application content files

·        Installing the application content files...

·        Installing the SharePoint Central Administration Web Application content.

·        Installing the SharePoint Web Application content files...

Step 11 -   Finalize SharePoint product and technologies configuration

One new feature of SharePoint Foundation 2010 is that it will automatically set up inbound Windows firewall rules when provisioning a Web application or Web services. During PSConfig, steps above firewall rules will be created for newly created Web applications and services

Access stsadm at anytime in command prompt

 Access stsadm at anytime in command prompt 

A quick and easiest way to access STSADM is to set a Path for the 12 Hive's bin folder.  Doing this, you can type "stsadm" at anytime in a command prompt window to access the operations it provides. 

1. Access Environment Variables
1. Go to your server's System Properties
1. RClick 'My Computer' > Properties
2. Click Advanced tab
3. Click Environment Variables button 
   
                 
   
   
   
   
2. Select the variable Path in System Variables

2. Click Edit button 
                                    
                                                                     
   
   
3. In the edit window, add the directory path for stsadm at the end.  Make sure you add a semicolon before the path.

a.         C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\ 

    

5. Click the OK button 

Preferred to do this on any MOSS server for ease of administration via command line.