Monday, December 2, 2013

Server Error in’/’ Application

  Server Error in’/’ Application 
                                                           

      Issue back ground: when open the Central administration page, It shows the Error.

          Exception Details: System.InvalidOperationException: This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products Configuration Wizard, located on the Start menu in Microsoft SharePoint 2010 Products
                

Cause: We are using the same account for DB and SharePoint. we Changed the  password for the account but not updated for SQL services.issue is due to the password for the account used in SQL. The changed PWD not updated in the SQL services

   

     Resolution: 

1.     Check the permissions for the account on SQL DB server
2.      If the account has Specific permissions alreday,check for whether the password was changed recently for the account or not.If changed the passowrd, Then Update the  password in the SQL services        
                   
·       Go to Run->Services.msc-> Find the SQL server,SQL server Agent(Change the Updated PWD)
                                                                                                                

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Upgrade from SharePoint Foundation 2013 to SharePoint Server 2013

 Upgrade from SharePoint Foundation 2013 to SharePoint Server 2013

Initially ,I installed foundation of sharepoint-2013 in my test lab. As you all know there are so many features not available on Foundation version. After working some days on foundation, thought to migrate version to SharePoint server 2013.Many of the people Think to do so. Sharing this Article who looking for the process to do same.

Note:  No  need of Uninstall SharePoint Foundation binaries from server, We can Upgrade SharePoint server on Top of SharePoint Foundation. Please find the below exceptions possible.

·        Upgrade from  SharePoint foundation 2013 to SharePoint server 2013 Trail->
cannot Do on Top, First remove Foundation binaries and install server binaries only. we get the below Error, if we try to do on Top of foundation will get the Error of screen below"  “Trial edition and licensed editions of Sharepoint, Project server, and Office Web Apps products may not be installed on the same server”                      



·         Upgrade from SharePoint Foundation 2013 to SharePoint server 2013 standard\Enterprise-> can do Directly on top without foundation binaries uninstall.
                                                                            
                    
     Follow the below steps to do so.

·   Assume, You have already installed SharePoint foundation.

·    Download the SharePoint server 2013 software from below link. Key already included in the same.


·   double click Click on the SharePoint server 2013 Setup file.


·  Click on Install SharePoint server. It will prompt for Product Key. provide the Key which is already mentioned in MSO site.
                                             
            
                               

·  Click on Continue.
                                      
                               
        
· Accept the Terms of this agreement and continue.
                                              
 
                                                                                      
·      Choose The Server type as per the requirement
                                      
                                    
·  Change the File Location if Necessary.
                                       


 · Once selected Server  type and location, click install now.binaries will get install
                    
                          


· Products and wizard will starts to run.
              


·         Click on Close.
                                            
                                        
·         Click on next and Yes to the Warning
        
                    




             


· Click on “create a new server farm” if its new Config.want to connect to the Existing farm click on “connect to an existing server farm”provide the details.

                    


                
                 
·Provide the Paraphrase, This Phase will be used to connect another servers in farm.

                                     



·    Click Next.

·    Specify Port number, Click next 

·     Once the Wizard Runs successfully, will see the screen below.click Finish 

                

                   
·         Once Finish done, The Central Admin will open.

   
Note: installing SharePoint Server 2013 on top of an existing SharePoint Foundation 2013 farm is not supported BY MS(http://social.technet.microsoft.com/wiki/contents/articles/16033.sharepoint-2013-migrate-from-sharepoint-foundation-2013-to-sharepoint-server-2013.aspx).


Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Sunday, December 1, 2013

Not able to “Uninstall SharePoint foundation 2013 from control panel and Boot Strap Error

   Not able to “Uninstall SharePoint foundation 2013 from control panel and Boot Strap 

    Back Ground: Initially ,I installed foundation of sharepoint-2013 in my test lab. As you all know there are so many features not available on Foundation version. After working some days on foundation, thought to migrate version to SharePoint server 2013.When I run the SharePoint server Version, It gives the Error Trial edition and licensed editions of Sharepoint, Project server, and Office Web Apps products may not be installed on the same server”. It’s Expected because SharePoint foundation consider to be Licensed and SharePoint Server 2013 is Trail version for 180 days. So, thought to Uninstall the SharePoint Foundation. When I try to remove From Control panel “Nothing is working” Meaning Not able to Un-Install. I didn’t see any Events in Evntvwr. I tried to Remove by running the Foundation .EXE, But it failed with the “Boot Strap Error”.After Digging alot and doing  Analysation I found the cause For this.

                                    
                                              

   Cause: While In the Trouble shooting process, I removed the below Registry entries Belongs to the “SharePoint Foundation “Below Are the Names of Registries and the path of registry.Thank God,I took backup of theese Registies.

    HKEY-LOCAL-MACHINE->SOFTWARE->INSTALLER->PRODUCTS

1.      00005109011100000100000000F01FEC

2.      00005109080190400100000000F01FEC

3.      00005109410100000100000000F01FEC

4.      00005109510190400100000000F01FEC

5.      00005109851190400100000000F01FEC



    Resolution: Once I Restored back All the Above 5 Registries. Everything should work as normal. I can remove SharePoint foundation By Control panel.  
                                                 

when I run the "Install SharePoint Foundation .Exe, It work without the “Boot Strap Error.



  •  Note:To restore back the Registers Just Double click on the Back up of Registry and say Yes to continue.It will be restored the same Path where Its originally located.
                                                                        
Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Friday, November 29, 2013

What are the accounts used in SharePoint for a least privileged configuration

 What are the accounts used in SharePoint  for a least privileged configuration.



In Many Organizations while Implementing SharePoint. The first question which may arise is What are the account we need to create and what are the permission levels it should have. I have tried my best to collate the things together and text it in my Blog as per my experience.Theese accouns are minimal accounts that required but it varies as per the requirements.


The setup account: This is the account with which the user is logged that runs the setup. This account must be a local administrator on all systems where SharePoint is run.

Post-Setup Configuration Run-As user: This is the user that runs the PSC tool.
This user must also be a local administrator
PSC runs a prerequisites check.
In addition to being a local administrator on all computers running Office Server, this account also has the following requirements on a remote server running SQL Server to be used as part of a SharePoint Foundation 2010 Services farm

Must be a SQL login
Must be a member of the SQL Server Database Creators Role
Must be a member of the SQL Server Security Administrators Role
This account need not be a local administrator on the server running SQL Server

This is the only account given explicit rights on SQL. It will give the database access account the SQL privileges it needs because it has the rights to do so.

The database access account: This is the account that is specified to the PSC tool when creating or connecting to a Configuration Database.
This account need not be the same as the PSC Run-As user and it need notbe a local administrator on any computer running Office Server.
It should also not be a local administrator on the SQL server, and doesnot require any SQL permissions in advance of creating a configuration database. Many of us refer to this as the “farm admin” account, but thisis misleading. The user that accesses the Central Admin Web pages to perform farm administrative activities is the farm admin account.

Central Admin App Pool ID:This account is “automatically” configured by the PSC tool to be the same account as the database access account that is stipulated to the PSC tool when creating a configuration database. This account and the SPTimer account constitute one exception to separate accounts being usedfor all account types.

The SPTimer account: As with the Central Admin App Pool ID, this account is “automatically” configured by the PSC tool to be the same account as the database accessaccount that is stipulated to the PSC tool when creating a configuration database.

The Farm Admin account: As mentioned earlier, this is the user that accesses the Central Admin Web pages to perform farm administrative functions.
This account can create Web applications, site collections, SSPs, configure Search, IFSS, Profile Imports, assigning permissions, and so on.


Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

ShareThis

X