Category Archives: Operating Systems

Post navigation

If you manage both your SharePoint environment and your SQL environment, you may find that the SharePoint_Config_Log.ldf file keeps growing far too large. Here is a quick way to reduce the size of the file. There are other articles that explain how to do this for older versions of SQL server, but I found this one to work for me in my environment.

Environment

Windows Server 2012

SQL Server 2012 SP1

SharePoint 2013 Standard

Solution

Run the SQL Server Management Studio 2012

Select the SharePoint_Config database (you may have renamed yours)

Open a new Query window

Enter the following commands (Make sure you change the DB name if you don’t use the default name)

This will set the recovery mode of the configuration database to Simple which then will shrink the log file then it will reset the database back to FULL. I left mine as Simple as I have no intention of restoring my configuration database should there be an issue.

We have installed it in our DEV environment and have verified the issue is fixed within our farm. I have also confirmed that you must still have KB2844286 installed and then install KB2872441 as you will still need the other security related patches from KB2844286 (or KB2844285, or KB2844287 depending on OS)

My original post can be found below as I am still updating that post as I get updates.

Came in today to find the following error message showing up on seemingly random web parts and lists throughout our SharePoint 2010 Foundation farm. ULS Logs on the servers weren’t very helpful.

[This issue has been RESOLVED see updates below]

For the sake of search indexing, here is the text version of the error we are getting.

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

We quickly tracked it down to a Security Update that was applied to our web front end servers last night. Check the OS below to find the KB update associated with your server.

Windows 7 Service Pack 1 and Windows Server 2008 R2 Service Pack 1

Windows Vista Service Pack 2 and Windows Server 2008 Service Pack 2

As a temporary workaround, we found uninstalling the update (KB2844286) from your servers (all WFE’s and App servers) then performing an IISReset on the servers will resolve the issue. Several others have experienced this issue as noted in just one of many forums such as the one below

If I find there is a solution better than uninstalling I will update this post to reflect that. As of right now, uninstalling this update is the best option.

[Update 7/16/2013 3:40pm]

It appears the error typically appears when a list or web part view has had the XSLT customized. At least in our Farm, that has been the common behavior.

[Update 7/17/2013 10:03am]

Not much of an update, but I’m awaiting contact from our Microsoft TAM to see about this issue. If we don’t hear from them soon, then we’ll be opening a ticket with Microsoft. Luckily we were able to work around the issue by uninstalling.

[Update 7/17/2013 12:50pm]

I just received confirmation from our TAM that Microsoft is aware of 2 issues regarding the patch noted in this article above. One of which appears to be the SharePoint issue we’re having.

[Update 7/17/2013 2:43pm]

Just spoke with our Microsoft Sr. Support Escalation Engineer assigned to our premier support ticket and here is their response (summarized).

“Our product group is currently working on the updated patch. We have no ETA for the new release at the moment.”

Looks like we wait then for a resolution.

[Update 7/17/2013 2:59pm]

One more confirmation from Microsoft Support and a link to the forum MS is using to track the issue publicly. No public information just yet beyond that, however.

“Both the SharePoint and .NET product groups are aware of the issue and they are in the process of fixing the patch.”

So far I have heard of no updated patch being released yet by Microsoft. There were two MS Security Bulletin updates but it doesn’t appear they were related to this issue as they were for Bulletin MS12-006 and MS12-052.

[Update 7/21/2013 12:36pm]

Still no updated patch. Received an e-mail from our MS Support representative and they indicated they too have no ETA on any updates to the security patch. I guess I’d rather they take their time then rush an update out all to break something else. It would be a good idea if Microsoft were to either add a note to the update download page indicating the issue, or just pull the update altogether.

[Update 7/24/2013 8:28am]

I just got a message from our Microsoft Support representative and she informed me there is no update as of yet on a new download for the patch. No surprise there.

[Update 7/25/2013 7:50am]

As you can see from the comments that have arrived thus far, it appears Microsoft has provided a fix to the KB2844286 issue. We are in the process of testing it out in our DEV environment now. Let’s hope it fixes it and doesn’t cause more issues.

[Update 7/25/2013 8:22am]

I am at this point, comfortable with counting this issue RESOLVED. We’ve tested it in DEV and the solution resolves the problem and doesn’t seem to break anything else. We won’t be able to complete the resolution in our Production environment until after hours as we will have to re-install KB2844286 which will require a reboot and the patch requires at the very least an IISRESET.

I have found several articles on the web that made mail merge using a SharePoint 2010 list as the data source possible which has spawned this post. The instructions I found online were great, up to a certain point, however. Most of the instructions assumed the users had some basic understanding and thus many steps were omitted which reduces the target audience that can use their instructions considerably. These instructions are intended for folks who have not worked with the Visual Basic Macro editor and don’t have a lot of interest in learning how to do it. They just want to get their work done.

Setup Info

I have created the following test documents and test SharePoint lists for these instructions. You will need to do the same for your project.

Cerberus or Kerberos, in Greek and Roman mythology, is a multi-headed hound (usually three-headed)which guards the gates of the Underworld, to prevent those who have crossed the river Styx from ever escaping. more

Configuring Kerberos Authentication in SharePoint 2010 has gotten a bad reputation for being too hard to do so many, if not most, stick with the standard NTLM authentication. Even Microsoft recommends this. For many instances, this may be fine, but if you require Kerberos, I recommend using the below document from Microsoft to guide you through the configuration of Kerberos.

How do I know if I should use Kerberos or NTLM?This is a good article that lays out why you would use Kerberos. Click Here

Some keys to remember when setting up Kerberos is the people or technologies you will need to work with.

In a typical enterprise, you will need to speak with the following folks.

Active Directory Administrators (Create SPN’s & KDC configuration)

Load Balancing Administrators

SSL Encryption (external or internal)

If you are the administrator of all of this, then your job gets easier and harder, because now you have to know how to do all of this. The above document, however, walks you through the process step by step and then shows you how to effectively test to ensure the configuration is working.

Basically there are 5 steps to configuring Kerberos (not including SharePoint Installation)

The process is more complex than just 5 steps, but those are the basic aspects of the configuration. Ensure you follow the above document and don’t get bored by all of the content within. They get a little too much into their scenario for configuration which is can be confusing. The naming scheme for service accounts and Service Applications are so similar it’s easy to get lost in the document.

I recommend you read through the document once or twice before starting, create an action plan that shows your step-by-step process before you begin then execute. More importantly, research and truly analyze whether your implementation really requires Kerberos or you can get by with just NTLM.

Once you’ve made it through, you’ll find it’s much easier than even the document makes it out to be. Sometimes these documents are much too wordy.

I ran into the below error today while installing the April 2012 Cumulative Update (KB 2598321) for SharePoint 2010 Foundation.

I figured I would post the resolution for anyone who happens upon this issue as well and for my own sake, since I’m constantly forgetting the parameter to run. The resolution isn’t specifically just for the April 2012 Cumulative Update. It can be used anytime you see this error.

What Happened?

Scenario: Installed CU on both WFE’s and ran Configuration Wizard on the primary server first. Attempted to run on the 2nd server and received the error above.

Impact: When the configuration wizard fails, it may then take your WFE offline until you can get this resolved.

Resolution: Run the following PowerShell command on the affected server

psconfig.exe -cmd installcheck –noinstallcheck

WARNING: Ensure you understand what this command is doing before you perform it on your production servers. Click Here for more information on PSCONFIG.You may need to re-run the configuration wizard to ensure all is functioning but this should bypass the installation check which will disregard the error you saw above.Hopefully this helps you if you have this error.Thank you to @AviSuj for reminding me of these parameters.

SharePoint 2010 is a really fun platform to administer, but configuring it can be a challenge, both technically and socially. If your organization is like mine and has a team of DBA’s administering your SQL instance/s for SharePoint, you’ll want to know how to deploy SharePoint 2010 as clean as possible.

What is a Clean install of SharePoint?

SharePoint 2010 can be installed and configured in a very short amount of time using the configuration wizards which basically will do almost all of the work for you. If you value your relationship with your DBA’s… DON”T DO THIS!!

Using the configuration wizard will inevitably create a slew of SQL databases with horrible names that include a long GUID at the end. This can be a real nightmare for maintenance and just plain ugly. (see below)

This is default SharePoint 2010 Foundation Database configuration. Standard/Enterprise are much worse by default.

This article will just address that of deploying and configuring the SharePoint Farm and Central Administration web application so as to keep that aspect of the installation clean.

This is what SharePoint 2010 Foundation could look like with some extra effort. Standard/Enterprise can be cleaned up as well.

If I can’t use the wizard, what do I use?

In order to do this, you will need to use the SharePoint 2010 Management Shell to do this as there is no clean way of doing it via a GUI interface that I know of.

But don’t get too nervous just yet, because even though it’s powershell, it’s pretty easy, and if you follow my steps, you can do it with little to no powershell experience. Leave a comment if you’re interested in downloading a script that makes these steps even easier.

NOTE: I highly recommend you familiarize yourself with PowerShell if you plan on administering SharePoint.

SQL Steps

Install SharePoint on your server

Skip to SharePoint Steps Section if not using Pre-Created Databases (i.e. are you or DBA’s creating empty databases, if so continue to next step)

Microsoft Office has been the productivity suite of choice for a large majority of businesses and organizations for years. The biggest challenge is training and keeping staff and other users trained on the products.

In this day and age, users are expected to be Self-Learners, thereby reducing the overhead in terms of training costs. This, however, isn’t always a natural personality trait for all users. This article isn’t intended to tackle the ins and outs of why or how to address this. It simply is intended to show users a quick easy resource to access to help become a Self-Learner for Microsoft Office products.

Microsoft has created many different versions of their Help/Support sites over the years to help users learn about their products. This latest version seems to be the most user friendly and intuitive of them all.

I strongly invite all users of Office products to check out the link below to learn more about their Office Products so you can better utilize these resources our employers have provided us and become or continue to be a Self-Learner.

Technology is a great way to stay connected, but there are those out there that have taken technology and turned it into a confusing, frustrating, and even unsafe place to be.

Hackers, viruses, spyware, SPAM are the equivalent of the schoolyard bully. They do it for many reasons, but it always causes you headaches. This is why having an antivirus program on all your home computers is so important.

Do I need antivirus if I don’t use the Internet very much?

Yes. No matter what, you should always have an antivirus program on your computer and it should be up-to-date.

What does it mean to be “Up-to-date”?

All antivirus programs have “Virus Definitions.” Virus Definitions are the files the antivirus company has written that detect new viruses that have been found on the Internet. Most companies produce new definitions every day. You should be wary of a program that does not publish definitions on a daily basis.

Can I use more than one antivirus? Will that protect me more?

No. Most, if not all, antivirus programs highly recommend you not run more than one antivirus program on your computer. There are several reasons to only run one but the two primary reasons are below.

Antivirus programs use a lot of resources

Multiple Antivirus programs may detect each other as viruses and disable features leaving you unprotected

I don’t want to buy antivirus. Is there anything free?

Yes. There are a few options you could try. I would recommend one of the two options below.

ClamAV

AVG Free Antivirus

The key to any antivirus program it to keep an eye on it, make sure that it’s always updated. It’s a good idea to check your antivirus definitions weekly to make sure that it’s up to date. You should also make sure that you set up a full scan weekly and make sure you set up an active scan to scan daily. This will help prevent your computer from getting viruses.

In the end the best way to prevent viruses is to be smart when using the internet.

We are happy to announce that the Read & Write Gold software has been installed on our server and is ready for students and staff to begin using.

All users should see a new Read Write Gold icon on their desktops now. The first time you open the program it will indicate that there is no user created for you and it will ask if you would like the system to create one for you. Click Yes.

What is Read & Write Gold?

Read&Write GOLD is the award-winning literacy software solution that allows struggling students to access any curriculum and complete reading, writing, and research assignments as well as take tests independently.