Changing the language of an existing SharePoint site

 Changing the language of an existing SharePoint site.

UPDATE dbo.Webs SET Language = 1033 where Title='System'

Changing the language of one site collection can be done with:

UPDATE dbo.Webs SET Language = 1033 WHERE SiteId = [[SiteCollectionId]]

And for changing the language of a single web or subsite you can use:

UPDATE dbo.Webs SET Language = 1033 WHERE Id = [[WebId]]

     Following are language and ID.          

Language	Language ID
Arabic	1025
Azeri (Latin)	1068
Basque (Basque)	1069
Bosnian (Latin)	5146
Bulgarian	1026
Catalan	1027
Chinese (Simplified)	2052
Chinese (Traditional)	1028
Croatian	1050
Czech	1029
Danish	1030
Dari	1164
Dutch	1043
English	1033
Estonian	1061
Finnish	1035
French	1036
Galician	1110
German	1031
Greek	1032
Hebrew	1037
Hindi	1081
Hungarian	1038
Indonesian	1057
Irish	2108
Italian	1040
Japanese	1041
Kazakh	1087
Korean	1042
Latvian	1062
Lithuanian	1063
Macedonian	1071
Malay (Malaysia)	1086
Norwegian (Bokmål)	1044
Polish	1045
Portuguese (Brazil)	1046
Portuguese (Portugal)	2070
Romanian	1048
Russian	1049
Serbian (Cyrillic)	3098
Serbian (Latin)	2074
Slovak	1051
Slovenian	1060
Spanish	3082
Swedish	1053
Thai	1054
Turkish	1055
Ukrainian	1058
Vietnamese	1066
Welsh	1106

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

Fixing " The server farm account should not be used for other services." SharePoint 2013 Central Administration

Enable session State in SharePoint 2013

Fixing " The server farm account should not be used for other services." SharePoint 2013 Central Administration

Title	The server farm account should not be used for other services.
Severity	1 - Error
Category	Security
Explanation	[farmServiceAccount], the account used for the SharePoint timer service and the central administration site, is highly privileged and should not be used for any other services on any machines in the server farm.  The following services were found to use this account: Distributed Cache Service (Windows Service)
Remedy	Browse to [your CA host]/_admin/FarmCredentialManagement.aspxand change the account used for the services listed in the explanation. For more information about this rule, see   http://go.microsoft.com/fwlink/?LinkID=142685
Failing Servers
Failing Services	SPTimerService (SPTimerV4)
Rule Settings	View

The only way to change this at present is to use PowerShell.  These steps are shown next.

 Procedure

Identify an AD account that you want to use for the Distributed Cache service account.

Register this account with the farm as a managed account.

Login to a farm server using your administrator account.  No need to use the farm administration account, just your own.

Open a farm management shell as administrator (right-click, choose Run as Administrator).

Execute each of the following statements, in order:

$farm = Get-SPFarm

$cacheService = $farm.Services | where {$_.Name -eq "AppFabricCachingService"}

Write-Host $cacheService

$accnt = Get-SPManagedAccount -Identity "DOMAIN\ACCOUNTNAME"

Write-Host "Managed Account" $accnt

$cacheService.ProcessIdentity.CurrentIdentityType = "SpecificUser"

$cacheService.ProcessIdentity.ManagedAccount = $accnt

Write-Host "Now Updating"

$cacheService.ProcessIdentity.Update() 

Write-Host "Finished."

 Only change "DOMAIN\ACCOUNTNAME".

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

PowerShell to deploy SharePoint 2013 Solutions (WSP)

Changing the language of an existing SharePoint site

PowerShell to deploy SharePoint 2013 Solutions (WSP)

         Add-SPSolution  wsp path

        Install-SPSolution –Identity wsp name –WebApplication web application name -

GACDeployment -Force

Following installed SharePoint solution FileName.wsp in the farm within the latest version directories and specifies that global assembly cache (GAC) can be deployed for the new SharePoint solution.

Install-SPSolution -Identity FileName.wsp -GACDeployment -CompatibilityLevel 15

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

Fixing "This content database has a schema version which is not supported in this farm"

Fixing " The server farm account should not be used for other services." SharePoint 2013 Central Administration

Fixing "This content database has a schema version which is not supported in this farm"

       To fix it

Check the version of SharePoint by using (get-spfarm).BuildVersion and then compare with both server farm and if both are not same then download the update and install.

SharePoint 2013

Build Number	Build Name	Component	Information Link	Download Link	Notes
15.0.4128.1014	Beta	SharePoint Foundation 2013		Download	Bugs, Notes, & Regressions
15.0.4128.1014	Beta	SharePoint Server 2013		Download
15.0.4128.1014	Beta	Project Server 2013		Download
​15.0.4420.1017	​RTM	​​SharePoint Foundation 2013	​	​Download	​Bugs, Notes, & Regressions
​​15.0.4420.1017	​RTM	​SharePoint Server 2013	​	​Download	​
​​15.0.4420.1017	​RTM	​Project Server 2013	​	​Download	​
​	​	​	​	​	​
​15.0.4433.1506	​December 2012 Hotfix	​SharePoint Server 2013	​KB2752058	​Download	​Bugs, Notes, & Regressions
​15.0.4433.1506	​December 2012 Hotfix	​SharePoint Server 2013 (coreserver)	​KB2752001	​Download	​
​15.0.4481.1005	​March 2013 Public Update	​SharePoint Foundation 2013	​KB2768000	​Download	​Bugs, Notes, & Regressions
​​15.0.4481.1005	​​March 2013 Public Update	​SharePoint Server 2013	​KB2767999	​Download	​
​​15.0.4481.1005	​​March 2013 Public Update	​Project Server 2013	​KB2768001	​Download	​
​	​	​	​	​	​
​15.0.4505.1002	​April 2013 CU	​​SharePoint Foundation 2013	​KB2751999	​Download	Bugs, Notes, & Regressions
​15.0.4505.1005	​​April 2013 CU	​SharePoint Server 2013	​KB2726992	​Download	​
​	​	​	​	​	​
​15.0.4517.1003	​June 2013 CU	​SharePoint Foundation 2013	​KB2817346	​Download	​Bugs, Notes, & Regressions
​15.0.4517.1005	​June 2013 CU	​​SharePoint Server 2013	​KB2817414	​Download	​
​	​June 2013 CU	​Project Server 2013	​KB2817415	​Download	​
​	​	​	​	​	​
​15.0.4535.1000	​August 2013 CU	​​SharePoint Foundation 2013	​KB2817517	​Download	​Bugs, Notes, & Regressions
​	​​August 2013 CU	​SharePoint Server 2013	​KB2817616	​Download	​
​	​​August 2013 CU	​Project Server 2013	​KB2817615	​Download	​
​	​	​	​	​	​
​15.0.4551.1001	​October 2013 CU	​SharePoint Foundation 2013	​KB2825674	​Download	​Bugs, Notes, and Regressions
​15.0.4551.1005	​October 2013 CU	​SharePoint Server 2013	​KB2825647	​Download	​
​	​October 2013 CU	​Project Server 2013	​	​	​
​15.0.4551.1508	​December 2013 CU	​SharePoint Foundation 2013	​KB2849961	​Download	​​Bugs, Notes, and Regressions
​15.0.4551.1511	​	​SharePoint Server 2013	​KB2850024	​Download	​
​15.0.4551.1508	​	​Project Server 2013	​KB2837668	​Download	​
​	​	​	​	​	​
​15.0.4569.1000	​Service Pack 1	​SharePoint Foundation 2013	​KB2817439	​Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB2817429	​Download	​
​	​	​Project Server 2013	​KB2817434	​Download	​
​	​	​	​	​	​
​15.0.4571.1502*	​Service Pack 1 Mark 2	​SharePoint Foundation 2013	​KB2880551	​Download	​Bugs, Notes, and Regressions
	​​	​SharePoint Server 2013	​KB2880552	​Download	​
	​​	​Project Server 2013	​KB2880553	​Download	​
​​15.0.4605.1000	​April 2014 CU	​​SharePoint Foundation 2013	KB2863892<	​Download	​​Bugs, Notes, and Regressions
​	​	​​SharePoint Server 2013	​KB2878240	​Download	​
​	​	​Project Server 2013	KB2880484	Download	​
​	​	​	​	​	​
​15.0.4615.1001	​MS14-022	​SharePoint Foundation 2013	​KB2952166	​Links in KB	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB2952166	​Links in KB	​
​	​	​Project Server 2013	​KB2952166	​Links in KB	​
​	​	​	​	​	​
15.0.4617.1000	​June 2014 CU	SharePoint Foundation 2013	​KB2881063	​Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	KB2881061	​Download	​
​	​	​Project Server 2013	KB2881062	​Download	​
​ 15.0.4631.1001	​July 2014 CU	​SharePoint Foundation 2013	​KB2882999	​Download	​​Bugs, Notes, & Regressions
​	​	​​SharePoint Server 2013	​KB2882989<	​Download
​	​	​Project Server 2013	​KB2882990	​Download	​
​	​	​	​	​	​
​15.0.4641.1001	​August 2014 CU	​SharePoint Foundation 2013	​KB2883081	​Download	​Bugs, Notes, & Regressions
​	​	​SharePoint Server 2013 (1/5)	​KB2760213	​Download	​
​	​	​​SharePoint Server 2013 (2/5)	​KB2880559	​Download	​
​	​	​​SharePoint Server 2013 (3/5)	​KB2883078	Download	​
​	​	​​SharePoint Server 2013 (4/5)	​KB2883085	​Download	​
​	​	​​SharePoint Server 2013 (5/5)	​KB2883086	​Download	​
​	​	​Project Server 2013	​KB2883083	​Download	​
​15.0.4649.1001	​September 2014 CU	​SharePoint Foundation 2013	​KB2883087	​Download	​Bugs, Notes, & Regressions
​	​	​SharePoint Server 2013	​KB2883068	​Download	​
​	​	​Project Server 2013	​KB2883072	​Download	​
​	​	​	​	​	​
​15.0.4659.1001	​October 2014 CU	​SharePoint Foundation 2013	​KB2889946	​Download	​​Bugs, Notes, & Regressions
​	​	​SharePoint Server 2013 (1/3)	​KB2899469	​Download	​
​	​	​SharePoint Server 2013 (2/3)	​KB2880962	​Download	​
​	​	​SharePoint Server 2013 (3/3)	​KB2880485	​Download	​
​	​	​Documentum Connector	​KB2752098	​Download	​
​	​	​Project Server 2013	​KB2889959	​Download	​
​15.0.4667.1000	​November 2014 CU	​SharePoint Foundation 2013	​KB2899468	​Download	​Bugs, Notes, and Regressions
​	​	​​SharePoint Server 2013	​KB2889944	​Download	​
​	​	​Project Server 2013	​KB2889949	​Download	​
​	​	​	​	​	​
​15.0.4675.1000	​December 2014 CU	​SharePoint Foundation 2013	​KB2910945	​Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB2910938	Download​	​
​	​	​Project Server 2013	​KB2910911	​Download	​
​	​	​	​	​	​
​15.0.4693.1001	​February 2015 CU	​​SharePoint Foundation 2013	​KB2920801	Download	​Bugs, Notes, and Regressions
​	​	​​SharePoint Server 2013	​KB2920804	​Download	​
​	​	​​Project Server 2013	​KB2920796	​Download	​
​15.0.4701.1001	​March 2015 CU	​SharePoint Foundation 2013	​KB2956159	​Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB2956166	​Download	​
​	​	​Project Server 2013	​KB2956162	​Download	​
​	​	​	​	​	​
​15.0.4711.1000	​April 2015 CU	​SharePoint Foundation 2013	​KB2965261	​Download	​Bugs, Notes, and Regressions
​	​	​​SharePoint Server 2013	​KB2965266	​Download	​
​	​	​Project Server 2013	​KB2965263	​Download	​
​	​	​	​	​	​
​15.0.4719.1002	​May 2015 CU	​SharePoint Foundation 2013	KB3039747	Download	​​​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB3039780	Download	​
​	​	​Project Server 2013	​KB3039753	Download	​
​	​	​	​	​	​
​15.0.4727.1001	​June 2015 CU	​SharePoint Foundation 2013	​KB3054864	​Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB3054866	​Download	​
​	​	​Project Server 2013	​KB3054865	​Download	​
​15.0.4737.1001	​​July 2015 CU	​SharePoint Foundation 2013	KB3054931​	Download	Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	KB3054937​	Download	​
​	​	​Project Server 2013	KB3054933	Download	​
​	​	​	​	​	​
​​​​15.0.4745.1001	​August 2015 CU	​SharePoint Foundation 2013	​KB3055004	Download	​​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	KB3055009	Download	​
​	​	​Project Server 2013	KB3055005	​Download	​
​	​	​	​	​	​
​15.0.4753.1000	​September 2015 CU	​SharePoint Foundation 2013	​KB2975894	Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	KB2986213	Download	​
​	​	​Project Server 2013	KB2986195	Download	​
​	​	​	​	​	​
​​15.0.4763.1000	​​October 2015 CU	​SharePoint Foundation 2013	​KB3085488	​Download	​​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​KB3085492	​Download	​
​	​	​Project Server 2013	​KB3085489	​Download	​
​​15.0.4771.1000	​November 2015 CU	​SharePoint Foundation 2013	​KB3101368	​Download	​Bugs, Notes, and Regressions
​	​	​SharePoint Server 2013	​ KB3101373	​Download	​
​	​	​Project Server 2013	​ KB3101369	​Download	​
​	​	​	​	​	​
​​15.0.4779.1000	​December 2015 CU	​SharePoint Foundation 2013	​ KB3114339	​Download	​​Bugs, Notes, and Regressions​​
​	​	​SharePoint Server 2013	​ KB3114345	​Download	​
​	​	​Project Server 2013	​ KB3114341	​Download	​
​	​	​	​	​	​
​​15.0.4787.1000	​​January 2016 CU	​SharePoint Foundation 2013	​ KB3114492	​Download	​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​ KB3114497	​Download​	​
​	​	​Project Server 2013	​KB3114493	​Download	​
​	​	​	​	​	​
​15.0.4797.1000	​​February 2016 CU	​SharePoint Foundation 2013	​KB3114722	​Download	​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​KB3114726	​Download	​
​	​	​Project Server 2013	​KB3114723	​Download	​
​15.0.4805.1000	​​March 2016 CU	​SharePoint Foundation 2013	​KB3114822	​Download	​​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​KB3114827	​Download	​
​	​	​Project Server 2013	​KB3114823	​Download	​
​	​	​	​	​	​
​15.0.4815.1000	​​April 2016 CU	​SharePoint Foundation 2013	​KB3114935	​Download	​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​ KB3114938	​Download	​
​	​	​Project Server 2013	​KB3114936	​Download	​
​	​	​	​	​	​
​15.0.4823.1003	​​May 2016 CU	​SharePoint Foundation 2013	​KB3115023	​Download	​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​KB3115029	​Download	​
​	​	​Project Server 2013	​KB3115024	​Download	​
​	​	​	​	​	​
​15.0.4833.1003	​​June 2016 CU	​SharePoint Foundation 2013	​KB3115171	​Download	​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​KB3115174	​Download	​
​	​	​Project Server 2013	​KB3115172	​Download	​
​	​	​	​	​	​
​5.0.4841.1000	​July 2016 CU	​SharePoint Foundation 2013	​KB3115290	​Download	​Bugs, Notes, and Regressions​​​​
​	​	​SharePoint Server 2013	​KB3115293	​Download	​
​	​	​Project Server 2013	​KB3115291	​Download	​

  

 

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

Check before restore farm in SharePoint 2013

PowerShell to deploy SharePoint 2013 Solutions (WSP)