Posts

Showing posts with the label SharePoint

Required Permissions in SharePoint Farm for executing PowerShell scripts

Image
Before you execute any of the SharePoint Cmdlet you must be sure that you have necessary permissions to execute in the farm. Also you must have access to local WSS_ADMIN_WPG group where you are executing the cmdlet. Also you must be member of the SharePoint_Shell_Access SQL role within the databases your cmdlet calls in to interact with. Some commands also require you to be a member of the local administrator and farm administrator grooups. For ex. to create a web application, you must be a local administrator and farm administrator. In Regards to adding users to the WSS_ADMIN_WPG group and SharePoint_Shell_Access SQL role, you must not be adding users directly to these groups rather you should use Add_SpShellAdmin cmdlet. This cmdlets accepts optional database name as parameter. If you do not pass this parameter it will add the user to the SharePoint_Shell_Access SQL role in the SharePoint configuration database only. Above third line of c...

Enable Desktop Experience on Servers to Access SharePoint Web Folders

Image
All of us like to access our files like a network drive, and drag and drop and mapping this drive to windows explorer or write/upload to SharePoint using scripts. In order to access SharePoint like a network drive we need to enable a windows feature on our OS which is called "Desktop Experience" which include a webDAV client which is required to open SharePoint documents as a folder on our machine. On most windows desktop OS it is by default enabled, but on servers we need to enable this feature. If you see the below image, you can notice that if you click on "Open with Explorer" you may get this error. The Solution is very simple on to enable this on Windows servers (2008/2012 servers)   Open Powershell command prompt Type "Import-Module ServerManager" without Quotes and execute it(enter) Next you need to execute "Add-Windowsfeature Desktop-Experience" this will install the necessary feature Or you can create a pow...

Recover Sharepoint 2013 databases from suspect mode.

Image
This Post courtesy to:  Lydia Bronze Original Post from: Blogs.cloudshare.com I restarted my SharePoint server, opened Central Administration and encountered the following error: Server Error in ‘/’ Application Runtime Error Description: An application error occurred on the server. In order to troubleshoot this issue I had to check couple of thing: Make sure SQL Server services are up and running Make sure the IIS application pools are started Review Windows logs and gather more information about the server. I noticed the following event: SQL Database ‘SharePoint_Config’ on SQL Server instance ‘C4968397007′ not found. Additional error information from SQL Server is included below. Cannot open database “SharePoint_Config” requested by the login. The login failed. Login failed for user ‘DC07\SQLSvc’. This event made me suspect something is wrong with my SQL Server. I opened SQL Server management studio and noticed that some of my most critical SharePoint data...