Skip to content

This operation can be performed only on a computer that is joined to a server farm by users ……..

Error Message: 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.

Issue Description:
In one of my SharePoint environment I start getting this error when browse site collection, it was working fine until yesterday. As per the error message I check all the permission for all the accounts on all databases including config database but no luck.

After several reboots, IIS resets and Googling, back to Event viewer I came across this warning mentioned below from source: ASP.NET. This warning at least has account name. I made sure that account specified in this warning has all the permissions needed but no luck.

Warning in Event Viewer: Event ID: 1309, Source: ASP.NET, Level: Warning
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6/26/2017 3:11:03 PM
Event time (UTC): 6/26/2017 7:11:03 PM
Event ID: 1f56666ca7d249979903cbb7c1aa15de
Event sequence: 2
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1927342608/ROOT-3-131429778631987995
Trust level: Full
Application Virtual Path: /
Application Path: C:\inetpub\wwwroot\wss\VirtualDirectories\Contoso Home-80\
Machine name: ContosoMachine
Process information:
Process ID: 13012
Process name: w3wp.exe
Account name: DOMAIN\\AccountName
Exception information:
Exception type: InvalidOperationException
Exception message: 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 2016  Products.
at Microsoft.SharePoint.Utilities.SPUtility.AlternateServerUrlFromHttpRequestUrl(Uri url)
at Microsoft.SharePoint.Administration.SPAlternateUrl.GetContextUri(HttpContext ctx)
at Microsoft.SharePoint.SPAppRequestContext.InitCurrent(HttpContext context)
at Microsoft.SharePoint.SPAppRequestContext.get_Current()

Solution:
If all steps mentioned above did not work for you try one more, Go to Central Administration > Security > Configure Managed Accounts> Edit the account mentioned in the warning> in my case it was app pool account  > check Change Password now > select the option Use Existing Password> enter the password and click OK. That’s it. 

If  your issue resolved feel free to leave a comment or let me know if any other solution. 

 

 

 

Advertisements

Send email to all users in SharePoint group

Last week I was asked if it’s possible to send email to all SharePoint Group Members. Quick solution I tried was to select all users and click “Email Users” Under “Actions” menu in SharePoint user group. I t will select only user that are on the page not on the next page. You will see an arrow (pagination) to go to next page in case you have more than 30 users.
Item limit any for SharePoint users Group is set to 30 by default. You can increase it to whatever you want. But let’s say if you have 500 users in a group called “Members” you can set the view limit to 99 but “Email Users” under “Actions” menu will not work anymore. You can try. It will throw error something like “cannot send email to that number of users “
Of course there are more than one way to achieve this goal, below is one I came up with quickly and though will share.
Copy and paste each line individually after changing the URL with your site collection url.

$Site=Get-SPSite http://SiteCollectionURL
$Site.rootweb
($Site.rootweb).groups
($Site.rootweb).groups | Format-table -Property name, owner
           # in my case I wanted to send email to all users in “Approvers” group
($Site.rootweb).groups[“Approvers”]
($Site.rootweb).groups[“Approvers”].users | Format-Table -Property DisplayName, Email
($Site.rootweb).groups[“Approvers”].users | Format-Table -Property Email >email.txt

You can modify the script and make it short, by adding more variables but this gave me what I was looking for. Wonder how this will work if one has thousands of users in a group. I don’t have any group with that big number so can’t test, if you have that big group let us know. Might have to use –LimitAll in command.

Another way to do this is open up excel click on data connections and add a new web data connection. Enter URL of the SharePoint group and it will ask you to enter your SPGroupUserslcredentials and will open up group view in excel where you can export every ting from the page in to Excel. Some formatting is needed here but you can easily get user first name and last name and then using formulas convert these 2 column in email address. Let me know if need more info on this option and I will post in detail.

 

Improve Performance for SharePoint and Project Server – Part 2

I have mentioned few tweaks/changes that can help improve SharePoint/Project server performance in Part 1.

I will add few more item here in Part 2 of the same article….

16 – Another important when installing OS before SQL installation you can make is, change the NTFS allocation unit size on your disks/drives. By default its 4096 bytes on windows server 2012 and by changing it to 64 you can easily gain some performance. for more reading : http://www.c-sharpcorner.com/UploadFile/d2ee01/ntfs-allocation-unit-size-on-sharepoint-sql-server-machine/

17 – Make sure the initial size in the “Files” windows of “temp” database properties is set to some higher number. This is in addition to the additional tempDB files. Also “Auto Growth” option must be set to some higher number, not percentage.

18 –  One more place to look is paging file size configuration on the server. Normally it is set to a lower number and can be configured based on the system RAM and other. It is recommended to set the paging size up to 150% of the physical RAM but I will suggest you to look in to your environment first and then set those numbers. At the minimum make sure it is set to “allow system to set the size “option.

19 –   Out Put Cache – one of the thing over looked sometimes but make sure you have Out Put caching enabled on site that will help improve performance.

20 –   Blob Cache- In case of significant use of images on Sharepoint site enabling blob cache can be help full. If you are planning to use new feature like Images renditions, Blob cache is required. It also help improve performance by delivering those images faster from cache.

Feel free to add more in the comment section.

Why HNSCs in a Single Web Application? and Best Practices in SharePoint 2013..

The new recommendations and path suggested by the MS is to go with single web application and multiple Host Named Site Collections (HNSCs) instead of multiple web applications as we use to do in the previous version of SharePoint.

For Software Boundaries and Limits click here.

You can still go with the additional web application if functionality is needed that can not be achieved in the web app shared by all the HNSCs e.g. different authentication requirement SAML or FBA.

I have spent lot of time building this new site architecture and during my research I put together some notes (with links) from different articles written by MVPs and other famous authors/TechNet.

I used this during the implementation and share and show the importance of this new architecture and how to implement e.g. no manual IIS bindings and other best practices.  I thought I will share this online as well for quick reference for others too.

If you have been playing with this new model and want to show your client the importance of this new structure you can use these points mentioned below and feel free to add any additional in the comment section.

  1. From TechNet “The recommended configuration for deploying sites is using host-named site collections with all sites located within a single web application, as illustrated in the following diagram.”
    http://technet.microsoft.com/en-us/library/cc424952.aspx#section1a

    • From the same TechNet link mentioned above “We recommend host-named site collections  unless requirements dictate that path-based sites with alternate access mapping are necessary”
    • From the link mentioned above “You can use host-named and path based site collections in the same web application. To ensure that both types of site collections are accessible to users, do not put host header bindings on the IIS website of your web application”
  2. Corporate Portal with Host named site collection http://www.microsoft.com/en-us/download/details.aspx?id=30362
  3. Why only One Web App is recommended : “ The problem is that even the base binaries needed to load a Site into memory (e.g. using separate web apps) has a high performance impact — and given that people generally want vanity URLs, which meant separate Web Apps in the past, HNSC is a great alternative.” http://social.technet.microsoft.com/Forums/sharepoint/en-US/231859ae-2656-4328-971e-ebf37639a827/host-named-site-collection-hnsc?forum=sharepointadminprevious
  4. As per MVP , Paul Stork “Yes you can add a host header in the IIS binding after the fact, but it’s not a supported design from Microsoft’s point of view and I really wouldn’t recommend it.”” link : http://social.technet.microsoft.com/Forums/en-US/eb95884c-0ebc-4743-9643-22387d164406/single-web-app-w-host-named-site-collections-or-multiple-web-apps-w-host-headings?forum=sharepointadmin
  5. Brenda (MSFT) talks about a Single Web Application “New features and existing features are optimized to work with host-named site collections like never before. However, it’s not just the feature that is important. It’s how it is configured — all host-named site collections are deployed to a single web application. The App model and Request Management, for example, are optimized for this configuration.” http://blogs.technet.com/b/tothesharepoint/archive/2013/05/17/your-friendly-guide-to-host-named-site-collections-with-timo-heidschuster-sharepoint-solution-architect.aspx
  6. Maximum number of web application is 20 but as per the same TechNet article “We recommended limiting the number of web applications as much as possible. Create additional host named site collections where possible instead of adding web applications.” http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx#WebApplication
  7. As per Trevor, MVP “You should try to limit the number of Web Applications (preferably 1). You can mix HNSC and Path-Based site collections within the same Web Application.” http://social.technet.microsoft.com/Forums/sharepoint/en-US/53dc9179-9eb9-4bad-bbaf-57babca28b82/confusion-around-host-named-site-collections-host-header-web-application-and-mysite-host?forum=sharepointadmin
  8. Logical Architecture Guidance for SharePoint by Steve Peschka. Benefits of one Web Application http://blogs.technet.com/b/speschka/archive/2013/06/26/logical-architecture-guidance-for-sharepoint-2013-part-1.aspx
  9. MVP, Trevor says regarding single Web App and single AppPool “The Microsoft model provides far better scalability than individual Web Applications would. Each Web Application (or Application Pool) has a significant amount of overhead, just in the base binaries alone. This is why Microsoft is encouraging towards a single Web Application + single Application Pool + host-based site collection model” http://social.technet.microsoft.com/Forums/sharepoint/en-US/c2de887a-25dd-4554-9181-f4ab1093d8d1/best-practices-for-web-applications-and-app-pools-in-2013?forum=sharepointgeneral
  10. Removing IIS binding manually by Russ Maxwell “When you create a web application and specify a host header URL, you stamp the host header URL on the spwebapplication object which is stored in the objects table in the configuration database. When you try to change the host header URL by updating the Alternate Access Mapping and manually update the bindings in IIS, the SPWebApplication object is never updated so it continues to maintain knowledge of the original host header URL and not the new one. When you start the Microsoft SharePoint Foundation Web Application service in Central Admin, the information from the associated SPWebApplication object in the configuration database is used when instantiating IIS Sites. This is why the original host header URL shows up.” http://blogs.msdn.com/b/russmax/archive/2013/02/27/how-to-properly-change-the-host-header-url-of-a-web-application-in-sharepoint-2010.aspx
    Also see this where MS recommend to remove IIS binding manually.
  11. Last but my favorite ,One of the best article written by Trevor Seward to show comparison of resources usage when use multiple web applications vs single web application with multiple HNSCs. http://thesharepointfarm.com/2014/08/expense-application-pools/

Feel free to add any comments or share your thoughts …

Restore-SpSite : The operation that you are attempting to perform cannot be completed successfully

Recently I was asked to move a site collection from one farm to the other. No problem, piece of cake, right?

That what I thought and ran the command

SPSite-Restore …..After backing up. I have 20 site collection in the data base already and limit is set to 2000 but got this error

Restore-SpSite : The operation that you are attempting to perform cannot be completed successfully. No content databases in the web application were available to store your site collection. The existing content databases may have reached the maximum number of site collections, or be set to read-only, or be offline, or may already contain a copy of this site collection. Create another content database for the Web application and then try the operation again

bl1

Woo, I will never create a new data base for this, here is how I resolved this. Run the same command with additional parameters of “ Databasename” & “DatabaseServer”

E.g. Restore-SpSite URLGoesHere –Path **.bak -force –DatabaseServer ** -DatabaseName **

And it worked this time. Site was successfully restored.

 

In some cases if you are trying to restore or create a new site with the same url that was deleted some time ago, there are possibilities it has not been removed from the database permanently in that case try this.

Get-SPDeletedSite:

bl2

If the site exist with the same URL remove using

Remove-SPDletedSite –Identity

As shown in the image above. Once removed this site will be removed from database for ever permanently.

Hope that helps.