Monthly Archives: May 2015

SharePoint 2013 Hosting – ASPHostPortal.com :: How to Solve Cannot generate SSPI context in SharePoint

Today’s problem occured after I restarted a Hyper-V based SharePoint 2013 farm (Windows Server 2012, one SharePoint 2013 machine, one SQL Server 2012 machine, one DC). I fired up Central Administration and was hit with the following error:

ahp banner sharepoint-01

Unknown SQL Exception 0 occurred. Additional error information from SQL Server is included below.

The target principal name is incorrect. Cannot generate SSPI context.

After checking the obvious things – testing connectivity to the DB server, checking the SQL service was running, verifying permissions, etc – I initially figured this was an issue with my Hyper-V snapshots being out of sync, so I ran the SharePoint Products Configuration Wizard. This hit me with the following error:

Failed to detect if this server is joined to a server farm. Possible reasons for this failure could be that you no longer have appropriate permissions to the server farm, the database server hosting the server farm is unresponsive, the configuration database is inaccessible or this server has been removed from the server farm.

I attempted to rejoin the server farm to no avail, then I realised I was barking up the wrong tree. The initial error message suggests a Kerberos issue, while my farm is set up to use NTLM. After a lot of searching, this ancient forum thread pointed me in the right direction. In Active Directory, I opened the computer record for the DB server. In the attribute list, the servicePrincipalName attribute showed the following entries:

How to Solve Cannot generate SSPI context in SharePoint

Delete the two MSSQLSvc entries and then restart the database server. In most cases this should solve the problem. Without the SPNs, authentication falls back to NTLM as it should and the farm comes back to life.

Other users have reported that they also need to delete the RestrictedKrbHost entries. In a previous version of this post, I suggested deleting every entry – after all, if we’re using NTLM, we shouldn’t need any SPNs. However, if you delete all the entries you may find you have to remove and then re-add the database server to the domain.

I’m fairly certain that this issue arose when I added Analysis Services to the SQL Server instance on the database server. Other users have reported similar issues when adding Reporting Services and Integration Services to a SQL Server instance.

Cheap and Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

ASPHostPortal.com Announces Cheap Magento 1.9.1.1 Hosting Solution

magento-1911

ASPHostPortal.com serve people since 2008 and we know how to deliver Powerful, Fast and Reliable Magento Hosting with the Superior Customer Support. Our superior servers are housed in US, UK, France, Germany, Netherlands, Australia, and Singapore with up to 100MB/s connection and Cisco Hardware Firewalls. Fully managed and monitored around the clock, our servers run on Windows Operating system with lots of memory (RAM) and up multiple Quad-Core Xeon CPU’s, utilizing power of the Cloud Services. Our Magento Hosting plans come with up to 99.99% uptime and 30-Day Full Money Back Guarantee. Today, we offer high quality Magento 1.9.1.1 hosting at cheap price.

Magento hosting is currently available from hundreds of thousands of providers. The decision of what Magento hosting company to use can be the difference between the success and the demise of a Magento shopping cart website. While any Magento hosting, eCommerce hosting, or even generic web hosting company may look the same at first glance- placed in very simple terms, nothing could be further from the truth.

Security is a topic that’s crucial for any eCommerce web site. If your site stores valuable financial info such as credit card numbers and personal contacts, as most Magento shops do, the severity of this topic is multiplied. No organization can afford to risk the devastating effects of having such data compromised. Many Magento hosting environments consist of private, virtual partitions of a server. This protects against a number of potential exploits that can be opened up by irresponsible webmasters that might otherwise share a server with your Magento shopping cart site.

ASPHostPortal.com provides Premium Magento 1.9.1.1 hosting plans on high performance servers and high-speed internet connection in the world. We provide high quality Magento hosting at an affordable price. We care for the clients, ensuring each and every client is more than just satisfied day in and day out. We only use the best hardware, super fast network, covered by 24/7 Support Team. To learn more about Magento 1.9.1.1 Hosting, please visit http://asphostportal.com/Magento-Hosting

About ASPHostPortal.com :
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET Hosting. ASPHostPortal.com has ability to support the latest Microsoft and ASP.NET technology, such as: such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. ASPHostPortal include shared hosting, reseller hosting, and sharepoint hosting, with speciality in ASP.NET, SQL Server, and architecting highly scalable solutions. ASPHostPortal.com strives to supply probably the most technologically advanced hosting solutions available to all consumers the world over. Protection, trustworthiness, and performance are on the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.

SharePoint 2013 Hosting – ASPHostPortal.com :: How to Fix SharePoint Cannot Show The Value of Filter

Multi-valued PeoplePicker Column that can be filtered using PowerShell

Recently I came across an error while filtering the multi-valued PeoplePicker column. The error reads “Cannot show the value of filter“. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.” There are only four values in the column, surely it has no relation to the list view threshold value.

ahp banner sharepoint-01

Internally, SharePoint server uses “_layouts/filter.aspx” application page for filter values which are presented in an iFrame. I checked the ULS logs and copied the Request URL with filter.aspx. I pasted it in browser and hit “Enter”. It returned no result.

What is multi-valued field?

The field which allows more than one values or which allows multiple selections. The multi-valued fileds are non-sortable, non-filterable. Multi-valued fields cannot be indexed.

How to Fix

This behavior can be overridden. Every field has an associated schema. Multi-valued fields are marked as “Sortable =false” in the schema for performance reasons. Note: Apply the workaround wherever it is unavoidable.

If we mark the multi-valued PeoplePicker as “Sortable=true”, the column turns filterable/ sortable. This can be achieved using SharePoint Server Object Model or using Windows PowerShell (I love it).

PowerShell Script to mark the column as Sortable:

$web=Get-SPWeb <weburl>
$list=$web.Lists[<list title>]
$field=$list.Fields[<field title>]
$strSchema=$field.SchemaXml
$str=Schema$strSchema.Replace(“Sortable=`”FALSE`””,”Sortable=`”true`””)
$field.SchemaXml = $strSchema

Update: I noticed that multi-valued “person or group” column in other web application was showing filter choices even though “Sortable=false”. Googling did not help. I checked at various levels and found that “Online Presence” setting causes this error. If Online presence setting is turned OFF, SP 2010 starts showing this error for multi-valued columns when tried to filter. So turn it ON, and no error, filter choices are shown back. The Online Presence setting is available in Web applications’s General Settings.

Cheap and Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

ASPHostPortal.com Announces Cheap Microsoft OWIN 3.0.1 Hosting Solution

owin301-01

ASPHostPortal.com is a web hosting provider dedicated to providing high quality web hosting at an affordable price. We care for the clients, ensuring each and every client is more than just satisfied day in and day out. We only use the best hardware, super fast network, covered by 24/7 Support Team. We have locations in 7 world class data centers, located USA, UK, France, Germany, Netherlands, Singapore and Australia. Each of locations will provide with amazing performance. Today, we offer high quality Microsoft OWIN 3.0.1 hosting at cheap price.

OWIN defines a standard interface between .NET web servers and web applications. The goal of the OWIN interface is to decouple server and application, encourage the development of simple modules for .NET web development, and, by being an open standard, stimulate the open source ecosystem of .NET web development tools. Microsoft Owin 3.0.1 Provides a set of helper types and abstractions for simplifying the creation of OWIN components.

With IIS supporting Owin it is possible to run other Owin-enabled frameworks such as Nancy on IIS. With Microsoft’s web frameworks depending on Owin and not IIS it is possible to run those in other environments, such as self hosting within a process or on a web server on linux running Mono. SignalR and Web API already uses Owin which means that they can be self hosted and other cool stuff. ASP.NET MVC6 which is part of ASP.NET vNext will be completely based on Owin. Transfer your host to ASPHostPortal.com to get faster and cheaper Microsoft OWIN solution.

We have established thousands of connections worldwide and multiple points of presence both domestically in the United States and worldwide. We have the capabilities to provide the quality, power and speed to keep businesses optimized and running quickly over the internet. Our goal is to provide and connect thousands of clients around the world with a personalized hosting solution to meet the rising information technology demands of businesses. To learn more about Microsoft OWIN 3.0.1 Hosting, please visit http://asphostportal.com/ OWIN-Katana-ASPNET-Hosting

About ASPHostPortal.com :
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET Hosting. ASPHostPortal.com has ability to support the latest Microsoft and ASP.NET technology, such as: such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. ASPHostPortal include shared hosting, reseller hosting, and sharepoint hosting, with speciality in ASP.NET, SQL Server, and architecting highly scalable solutions. ASPHostPortal.com strives to supply probably the most technologically advanced hosting solutions available to all consumers the world over. Protection, trustworthiness, and performance are on the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.

ASPHostPortal.com Announces Cheap and Fast WordPress 4.2.2 Hosting Solution

wordpress 422-01

ASPHostPortal.com is set up with an aim to serve customers in an excellent manner by providing them quality service. We strongly believe in high quality standards and Hence you’ll always find our services better than every other host in this industry. We understand the value of time and hence our ordering process is very simple. Customers can choose servers from multiple price levels to suit their business module. Today, we offer premium WordPress 4.2.2 hosting with fast loading speed, and uptime guarantee.

The WordPress blog platform that you install at your own chosen web host and use with your own domain name, is an excellent choice for your blogging efforts. WordPress makes it easy for anyone to set up, manage and maintain a website, and you can do it without being a total geek. WordPress lets you quickly and easily create posts, which are basically the blog part of WordPress, and they are usually organized by time-of-post, are usually open for comments, and they are the content to build out the meat of your site. With WordPress, there are hundreds and hundreds of free themes available so you can easily manage your site’s look and feel.

WordPress would be great for a personal blog about how you care for your own yard’s grass, and offer advice to other homeowners about all the other chores and repairs a homeowner must perform. WordPress will satisfy your Web site needs when you want to establish an online presence for either personal or business purposes. To increase their performance, a few days ago WordPress has released WordPress 4.2.2 version. If your WordPress site load slow, it usually caused by your current hosting provider that doesn’t support WordPress well. Transfer your host to ASPHostPortal.com will be the best solustion if you need a fast site.

ASPHostPortal.com also comes with the support and knowledge their customers have come to rely on. We ensure that customer’s questions are resolved timely and effectively and from friendly and respectful customer support team. We have robust hosting packages and super-affordable prices. We will provide you with complete web hosting solution. Our Web Hosting packages are perfect for individuals and business requiring high uptime and performance. To learn more about WordPress 4.2.2 Hosting, please visit http://asphostportal.com/WordPress-Hosting

About ASPHostPortal.com :
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET Hosting. ASPHostPortal.com has ability to support the latest Microsoft and ASP.NET technology, such as: such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. ASPHostPortal include shared hosting, reseller hosting, and sharepoint hosting, with speciality in ASP.NET, SQL Server, and architecting highly scalable solutions. ASPHostPortal.com strives to supply probably the most technologically advanced hosting solutions available to all consumers the world over. Protection, trustworthiness, and performance are on the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.