Thursday, October 22, 2015

“The signin method you’re trying to use isn’t allowed” – Windows Server 2012 - Adding AD Accounts to local users and groups

“The signin method you’re trying to use isn’t allowed” – Windows Server 2012

During the work with my first book Beginning SharePoint 2013 Workflows, I have been using a Hyper-V VM running SharePoint 2013 on Windows Server 2012. I created a workflow demo where an admin started a workflow that assigned a task to a standard user. But then when I tried to login as this user, I received the following message in the login window:  “The signin method you’re trying to use isn’t allowed. For more info contact your network administrator.”
This behavior is  probably intended by Microsoft. By default, only administrators should login locally to the server where Windows Server 2012 is running. The server is not supposed to be someone’s workstation! This is a valid and understood statement in a production environment since otherwise it could become the security hole of the century!  But I’m running  WS2012 with SharePoint 2013 on a VM hosted on my Windows 8 laptop, and I want to switch users locally, so there should be a solution for this. The good news are, you can bypass this restriction, but you have to dig deep into the Group Manager hierarchy to find the correct place to add the fix. Here’s how:
Log in as the administrator on the server, then start the Group Policy Management Editor by running the  gpmc.msc command from PowerShell or the Command Line window.
1. In the Group Policy Management window on the left hand side, select Group Policy Management.
Pic1
2. Click to expand the  Forest<your domain name> tree node.
3. Click Domains.
4. Select your domain name.
5. Click Group Policy Objects.
Pic2
6. In the right-hand window, double-click Default Domain Controllers Policy.
7. Right-click Default Domain Controllers Policy and Select Edit.
8. In the Group Policy Management Editor window, click Default Domain Controllers Policy.
9. Click Computer Configuration, and then click Policies.
10. Click Windows Settings, and then click Security Settings.
Pic3
11. Click Local Policies and then click User Rights Assignments.
12. In the right pane, click Allow log on locally.
Pic4
12. Click the Add User or Group button.
13. In the Add User or Group dialog,  enter the name to be added or click Browse.. to search for a name.
Pic5
14. Click OK .
15. Repeat steps 12-14 if you want to add more users.
16. Click OK to Close the Allow log on locally Properties dialog, and then click Close several times to Close the remaining open Windows.
17. Run the following command in Powershell or the Command Window to activate the policy changes:
gpupdate /force.
By running this rather messy procedure,  I was able to login to Windows Server 2012 locally using a standard user name. Hopefully there are easier ways to achieve this,  so if anyone reads this post and knows anything, please don’t hesitate to add a comment!
Ref Link: http://www.sharepointviking.com/the-signin-method-youre-trying-to-use-isnt-allowed-windows-server-2012/#comment-690 

Friday, September 18, 2015

The specified user username is a local account. Local accounts should only be used in stand alone mode error in SharePoint 2013

Thursday, September 10, 2015

Missing server file or server configuration issues. Web part Errors:

Missing server file or server configuration issues.
Web part Errors:
The following web part(s) are referenced by the content, but they are not installed on the web server
•Id = 72818beb-d38f-ce20-ad03-17a569674760, Type = Unknown, Reference = 29, Status = Missing             
•Id = b0361b90-8e73-425f-bcbc-2b2469198a00, Type = Unknown, Reference = 14, Status = Missing             
•Id = 19060b95-1c73-5a5b-875c-2e2c7d7cd355, Type = Unknown, Reference = 4, Status = Missing             
Steps to fix the errors
1.Logon to Database server and Run following SQL query on the content database for the Support site:
SELECT * FROM [WebParts] WITH(NOLOCK)where tp_WebPartTypeId =’ID’             
Example: SELECT * FROM [WebParts] WITH(NOLOCK)where tp_WebPartTypeId ='72818beb-d38f-ce20-ad03-17a569674760'             
            
From the results pane copy the tp_PageUrlID . These are the ids of the urls which has reference to the missing webparts .
2.Now run following query:
SELECT * FROM Alldocs WITH(NOLOCK)where id='80A251DD-1452-4199-A0BA-05120A7286EC'            
(ID is the value of the tp_PageURLID)
You will get DirName and LeafName corresponding to that PageURLID
3.Repeat step-2 for all the PageURL Ids to get complete URLs for a particular webpart ID. Step-1 and Step-2 needs to be performed multiple times to get a list of all the URLs where we need to fix the webpart error.
4.Now go to the URL, example :http://abc.amd.com/test/pages/test.aspx?contents=1
5.Check-out the page , delete the error web part and check-in/publish the page
6.To test if the issue is fixed run the below query again:
SELECT * FROM Alldocs WITH(NOLOCK)where id='80A251DD-1452-4199-A0BA-05120A7286EC'
again.
You should not get any results if all the URLs are fixed.

Ref Link: https://amritatalreja.wordpress.com/2011/08/02/preupgradecheck-errors-part-1/

How to Remove Missing WebPart during SharePoint Upgrade

If you are upgrading SharePoint 2007 to SharePoint 2010 and getting “MissingWebPart” error when using the Test-SPContentDatabase cmdlet in PowerShell, this tip will help you diagnose the issue.
Following is the original error:
Category: MissingWebPart
Error: True
UpgradeBlocking : False
Message: WebPart class [8c8bca43-cbc1-da50-d518-54614c79b3f5] is referenced [1] times in the database [WSS_Content], but is not installed on the current farm. Please install any feature/solution which contains this web part.
Remedy: One or more web parts are referenced in the database [WSS_Content], but are not installed on the current farm. Please install any feature or solution which contains these web parts.
As you can see, the error message gives you a WebPart GUID [8c8bca43-cbc1-da50-d518-54614c79b3f5] and the name of the content database [WSS_Content]. What we need to find out is on which page it is referenced in the database. For this we can run a SQL SELECT query on the “AllDocs” table in the content database exhibiting the problem. For example, you would run the following command to find details of the web part with the class ID “8c8bca43-cbc1-da50-d518-54614c79b3f5″:
select AllDocs.SiteId, WebId, Webs.Title as‘Web Title, ListId, DirName, LeafNamefrom AllDocs innerjoin WebParts on AllDocs.Id = WebParts.tp_PageUrlID innerjoinWebs on AllDocs.WebId = Webs.Id where WebParts.tp_WebPartTypeID =’8c8bca43-cbc1-da50-d518-54614c79b3f5′
It will list a very useful output, as shown in this example:
To remove the web part, type the page URL in the browserformat as “http://<SiteURL>/<DirName>/<Leafname>?contents=1″. In this example, type the following URL in the browser:
http://mossdev/default.aspx?contents=1
The screenshot below shows a web part maintenance page, you can delete the missing WebParts on the page.



Ref Link: http://www.boostsolutions.com/blog/how-to-remove-missing-webpart-during-sharepoint-upgrade/

Friday, September 4, 2015

Download a WSP Solution File from SharePoint 2010 Farm with PowerShell

Download a WSP Solution File from SharePoint 2010 Farm with PowerShell



$farm = Get-SPFarm
$file = $farm.Solutions.Item("extendeddiagnosticproviders.wsp").SolutionFile
$file.SaveAs("c:\temp\extendeddiagnosticproviders.wsp")