Search This Blog

Wednesday 31 July 2013

SP2013: Site Locked after interrupting Backup

Hi,
i Had to interrupt a Backup and that got my site stuck in Maintenance mode.
You have a red bar at the top of your site warning you and your site is grayed out on Read Only.

Here is how to fix it.
Open SharePoint PowerShell

Open SharePoint PowerShell

$Admin =  new-object Microsoft.SharePoint.Administration.SPSiteAdministration('http://YourSite.Domain.com') (Hit Enter)
$Admin.ClearMaintenanceMode() (Hit Enter)
$site.MaintenanceMode (Hit Enter)


After this I went back and it was unlocked


SP2013: Enable SharePoint 2013 Tasks List Email Notification

Hi,

You need to run a script to get this enabled.

Make sure your outgoing mail is working.
Run this:

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue

$web = Get-SPWeb "https://sitename.domain.com/sites/Sitename/"
$list = $web.Lists.TryGetList("TaskName")

$list.EnableAssignToEmail = $true
$list.Update()





Thursday 25 July 2013

SP2013: Cant open in explorer view: We’re having a problem opening this location in File Explorer, Add this web site to your Trusted sites list and try again

Got this error on my desktop:
We’re having a problem opening this location in File Explorer, Add this web site to your Trusted sites list and try again

i Restarted the Webclient service on my notebook and then it worked.

Friday 12 July 2013

SharePoint User Accounts and rights

Hi,

Here is the accounts and the rights assigned to them:

SP_Admin
 Local Admin on Application and Web Front-end Servers
 On SQL DBCreate rights and SecurityAdmin rights.
 Give user a email same as SP_Farm
 Installation account

SP_Farm
 Dont assign any rights. Will be assigned by SharePoint during installation.
 Use this account in Config Wizzard as DB Access Account
 Give user same email as SP_Admin

SP_SQLUser
 Local Admin on SQL Server
SQL Admin


SP_Crawl

SP_ServiceApps

SP_UserSync
Rights in AD to Sync User Profile Sync
http://technet.microsoft.com/en-us/library/hh296982.aspx

SP_WebApps


SharePoint in a 3 Tier farm

Hi,

Quick Steps for SharePoint in a 3 Tier farm.

Install your Application Server.
i Skip Application Wizard and configure it manually.
Install at least PU March 2013 according to this post: http://daniecsp.blogspot.com/2013/07/sp2013-compulsory-public-update-march.html (If there are a SP1 out it will probably be diffrent)
Configure Service Applications Manually
Start and Stop Services (Here i have started some but still looking for a list of what should be started and stopped.

Now i installed the SP2013 WFE server.
Tried to add it to the farm i kept on getting this error:

"failed to connect to the existing server farm located at the specified database server and database name. The Database name is not a valid configuration database"


i Forgot to install PU March 2013 on the WFE...
After installing this it excepted it and asked for the passphase.

Now, to decide which services should be running on which server...

i Cant find much on the net regarding SharePoint 2013...Here is what mine looks like...Please make comments if you dont agree with anything

Application Server: (Image Updated 2014/06/12)


fyi: User Profile is still "Starting in the image and should also be on Started, i needs a little configuration before you can get it started...

Web Front End: (Image Updated 2014/06/12)


Other Items that needs to be configured...(This list wil probably grow over time...)
Incoming mail(If required)
Outgoing mail
User Profile Sync
Search
Secure Service Store


Here is a handy doc for setting up SharePoint in a 3 Tier farm
http://technet.microsoft.com/en-us/library/ee805948.aspx
http://www.microsoft.com/en-us/download/details.aspx?id=6096

update: 2014-03-20
Just found this...also very handy piece on what must be started where (SharePoint 2013)
http://fazlulchowdhury.blogspot.com/2013/09/sharepoint-2013-across-multiple-servers.html

Updated 2014-09-23
Needed this but more for SharePoint 2010, 2 nice blogs:

http://davecoleman146.com/2011/04/07/which-services-run-on-each-server-in-a-three-tier-sharepoint-2010-setup/

http://www.wahidsaleemi.com/2010/04/which-services-are-required-for-sharepoint-2010-web-server-role/

Wednesday 10 July 2013

SP2010: Specific User cant create Business Inelegance Site

Hi,

i Have a user that get the following error when trying to create a BI site.

Provisioning did not succeed. Details: failed to initialize some site properties for web at url 0x80070005
In the ULS Logs:
Exception was: 'System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>    

When i granted the user Full access to the Site Collection she got Access Denied error.
 Made her a Site Collection Administrator and she could add the site.

Solution:
Granted Restricted Read Access to user with issue
_catalogs/masterpage

Url below helped to solve it.
http://blog.beckybertram.com/Lists/Posts/Post.aspx?ID=181


Tuesday 9 July 2013

SP2010: Setup User Profile Synchronization

Hi, 
This will is a very common issue.
Your user profile sync does not start....says starting for a while and then stops...
To start this you need to add you SP_Farm user group into the local admins group. The restart your time service
After this you should be able to start the service.
When it started remove it from your administrators group


SP2013: Compulsory Public Update March 2013

Hi,

For SharePoint 2013 there is a compulsory Public update.
You can see this as a baseline but if you are planning to install CU's you need this installed.

There are specifics steps to follow with this PU update different to normal SP's and CU's.

Links and some details:
http://blogs.technet.com/b/stefan_gossner/archive/2013/03/21/march-public-update-for-sharepoint-2013-available-and-mandatory.aspx

The Server update include Foundation update and the Project update include Foundation and server.

Downloads:
Foundation: http://www.microsoft.com/en-us/download/details.aspx?id=36987
Foundation + Server: http://www.microsoft.com/en-us/download/details.aspx?id=36989
Foundation + Serve + Project: http://www.microsoft.com/en-us/download/details.aspx?id=36988

Steps to follow:

Do this for each server running search component in the order below: You might as well try and stop them anyway...Should say already stopped if services is not present.

Stop the SharePoint Timer Service, SharePoint Server Search 15, and SharePoint Search Host Controller services (open a Command Prompt and run each command in the order below):
NET STOP SPTimerV4 
NET STOP OSearch15
NET STOP SPSearchHostController

Remember my farm as below is clean with no Service application's installed yet


Install Package
It askes for a restart, i have restarted and stopped the services again after the restart.
Run the wizard

Restart services in this order:
NET START SPSearchHostController
NET START OSearch15
NET START SPTimerV4 

After this i could not connect to the farm...
Restarted again
Still an issue...Inside Central admin my Central Admin site was not started...


Each server will require a restart

Thursday 4 July 2013

SP2010: Service pack and Cumulative update install procedure.

Hi, 

Here is how it should be done according to me...

Assuming Service Pack 1 has not been installe
  • Install Foundation SP1
  • Install Server SP1 
  • Install Project SP1


The update packages has changed(on August 2011) and after that you don't need to install the foundation update and then Server. You only have to install Server SP1 if you are running server and same for project server but must of the people seems to still do Foundation, then Server...i Play it safe with this.

Then you need to choose the CU you want to install.
There was some issues on SP1 so you have to go at least to June 2011 CU.
Some people like to stick to this update but this is your call.
When the choice is mine i go to Dec 2012 CU.

You don't have to install all the CU's prior to the one you are installing. Each CU contains the previous CU's after the latest service packs 
You can download the CU you want and apply it.

So continuing from above:

  • Install Foundation December 2012 CU (Version you are happy with)(After August 2011 not needed)
  •  Install Server December 2012 CU (Version you are happy with)
  • Run the Configuration wizard
  • Prob not needed but restart your server
  • Run (get-spserver $env:computername).NeedsUpgrade
  • If True is returned above goto next step.
  • Run from bin dir as administrator: PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures


And this should be it.
You don’t have to run the wizard between setups.
You will have to decide what CU is going to work for you.
You only need to install the CU that you want to use. No need to install all the CU’s before it. They are included in the CU you choose.
If you have web apps i think there are some more steps...Double check this.

More then one WFE & App Server:
Wizard also needs to be run on each Server one by one. Run it on App server first and then repeat on each WFE.


SP2010: Additions to this Web site have been blocked

Hi, Got this error at a client when trying to change site collection administrators.

Also could not get the full menu structure on any of the sites.

Solution:
Check your Configure quotas and locks...The Site Collection was set to Read-Only