Feeds:
Posts
Comments

Posts Tagged ‘SharePoint Server 2010’

Howdy,

The Problem.

For teamsites and collaborations, sometimes it can be useful to upload big file size documents – which is allowed only partially by SharePoint and IIS. They both have different default settings for the maximum upload file size of a single document or file. They are:

  • SharePoint Server 2010: 50 MB
  • IIS7: ~30 MB

So, when trying to upload a big document, this results in the following error:

image

85 MB is simply too much for the above mentioned settings. Now, the solution section will show you how to fix this.

The Solution.

The good news is: This can be custom tailored to your needs, by simply following 3 steps. Here comes the first step:

1. Increase the SharePoint Upload Limit via Central Administration

First, you must increase the SharePoint 2010 upload limit.

  • Central Administration
  • “Manage Web Applications”
  • Select desired web application row (don’t click on the title, just select)
  • “General Settings” in the ribbon
  • Under Maximum Upload Size, change the setting to the desired value (e.g. 200 MB in our example)
  • “OK”

 

image

Now, the web app is equipped for receiving large files, but IIS7 will still prohibit it, resulting in the same error message as above. So, let’s move on to step 2.

 

2. Increase the IIS7 request length

Use the following command on the machine you are running the IIS 7:

%windir%\system32\inetsrv\appcmd set config -section:requestFiltering -requestLimits.maxAllowedContentLength:valueInBytes

In our case, we’ll simply put 200x1024x1024=209715200 bytes.

You will receive a confirmation message after applying the command. Please bear in mind that you will need to run the cmd.exe in administrator mode.

image

 

3. Increase the IIS7 connection timeout length (optional)

One more thing to keep in mind is the connection timeout settings: When you upload large files, depending on your connection speed it can happen that the connection times out. If you want, you can increase the connection timeout to a larger value. The standard is 120 seconds. This step is optional, but can become required if you have users with low speed internet connections.

image

  • Open IIS
  • Select the Web Application
  • Click on Advanced Settings
  • Expand Connection Limits
  • Set the new value for Connection Time-out (seconds)

 

This is it – all done!

You users will now be able to upload larger files:

image

As usual, test any commands, configuration and settings on a test environment before applying them in production. Applying request lengths bears also some security implications to keep in mind. Use any advices and configurations at your own risk and evaluate risks before applying them.

 

Have a nice day and best regards!

Martin

Read Full Post »

Dear all,

the third episode of SharePoint 5 is ready and can be viewed here:

Please note the slight watermark – I am testing another recording software, so in future there will be no more watermark.

This time, we’re dealing with the installation of language packs for

  • Windows Server 2008 (make sure to grab the 64-Bit version of the LPs!)
  • SharePoint Server 2010

Purpose: Creating sites in different languages than only the originally installed SharePoint Server 2010 language.

Here are the links for downloading all the language packs:

 

Windows Server 2008:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=1246

SharePoint 2010 Language Packs: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3411

 

IMPORTANT: Do not execute these steps without prior consulting your administrator and plan for downtime. There will be a service disruption when running the Products Configuration Wizard, where your SharePoint Contents won’t be accessible for some time. Please bear that in mind before executing any of the above mentioned steps.

 

Best regards and stay tuned till the next episode,

Martin

Read Full Post »

Dear all,

the second episode of SharePointFive is ready to be viewed here:

The topics covered are:

  • Setting up Document Sets site collection feature
  • Setting Up a Document Library
  • Adding a Content Type
  • Creating a Document Set

You can find all SharePointFive videos here:

www.youtube.com/SharePointFive

 

Enjoy and stay tuned till the next time!

Martin

Read Full Post »

Dear all,

it is my pleasure to announce a new initiative of communicating SharePoint knowledge via videos using the “SharePointFive” approach: Show how technical configurations are done within only a few minutes (guideline: 5 mins per video, up to a max of 15 in special cases.

If you want to learn about SharePoint 2010 configurations, but only want to invest a few minutes at a time, if you are looking for the essentials that make up what you actually want to do, then SharePointFive is for you.

SharePointFive (SharePoint5)

SharePointFive is a youtube channel, that you can access under the below mentioned URL. It contains all videos (currently 1 only :-)) that have been and will be published, showing how to apply SharePoint (or related) configurations in just a few minutes. Usually, like in this case, there will be published a related blog post on angler.wordpress.com, in order to facilitate it for you to copy scripts and apply them.

SP5Logo

http://www.youtube.com/sharepointfive

The Video

The video will give you an idea of the steps to be executed, a few caveats. But most of all, it is only a few minutes long and won’t take a long time to watch. This first episode of SharePointFive is  a bit longer (about 12-13 minutes), since it contains also the explanation and motivation why SP5 has been launched.

The Scripts

1. Create the Master Key:

 1: USE master;
 2: 
 3: go
 4: 
 5: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'n0PWStealingAll0w3d!';
 6: 
 7: go

2. Create the Certificate:

 1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = 'SP5 DEK Certificate';
 2: go
 3: 

 

3. Back up Certificate & Private Key (EXTREMELY IMPORTANT TO KEEP IT BACKUPPED AND SAFE!):

 1: USE master;
 2: go
 3: BACKUP CERTIFICATE SP5Certificate TO FILE = 'C:\Certificate\TDECertificate.cer'
 4: WITH PRIVATE KEY (
 5: FILE = 'C:\Certificate\PK.pvk',
 6: ENCRYPTION BY PASSWORD = '?pkP4SsW0rD!');
 7: GO

4. Create Database Encryption Key:

 1: CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE SP5Certificate;
 2: 
 3: GO

5. Enable Transparent Data Encryption for a Specific Content Database:

 1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = SP5Certificate;
 2: go

Please bear in mind:

  • Scripts need to be adapted to your needs, of course
  • Please run everything in a isolated test environment, before applying on production level
  • Consult your DBA before applying any changes to the SQL Server Instance, like running the beforementioned scripts.
  • The author of this blog cannot take responsibility for any damages caused by executing scripts, programs and configurations shown
  • It is your responsibility to inform yourself about possible side effects that are not reported. Usually, Technet and MSDN are good references for complete documentation of the concepts shown.
  • The scripts of SharePointFive are provided “as is”

Stay tuned till the next episode of SharePoint 5 and enjoy!

Best,

Martin

Read Full Post »

The good news

The manuscript is finished and submitted! Now I’m waiting for feedback, and certainly some corrections will be made. However, the big stuff is done.

Einstieg in Business Intelligence mit Microsoft SharePoint 2010: Überblick und Konfiguration der Business Intelligence-Features von SharePoint 2010

Preview it here: Einstieg in Business Intelligence mit SharePoint 2010

Below you can get some numbers about how I passed the last 4 months writing:

 

Book numbers

  • 1 Book
  • 9 chapters
  • 3 appendices
  • 340 pages
  • 250 images
  • 1.5 GB of content created

Time statistics

  • 500 hrs of writing
  • 142 hrs/month (yes, it’s become my second fulltime job)
  • 4.5 hrs sleep/day
  • 14 holidays taken for fulltime writing
  • Average hour of going to sleep:
    • First month of writing: 11.30 p.m
    • Last month of writing: 03.00 a.m.

Trivia

  • 15 albums listening to while writing (7 from which Rammstein)
  • 1 640GB backup hard disk smashed on the floor, causing:
    • INF swearings over the broken hard disk
    • 1 shock proof hard disk purchased
  • 1 MacBook Pro AC adapter cable chewed to death by cat
  • INF amount of:
    • Coffee
    • Red Bull
    • Tea
    • Fresh Fruit
    • Sweets

It was a great experience to write the book and I had the chance to take a 4 month intensive course in specializing on selected topics. However, now I’m really looking forward to increase my sleeping again back from 4.5 to 8 hours!

😉

 

Stay tuned and best regards,

Martin

Read Full Post »

Dear all,

this week is just awesome! After receiving the Microsoft Community Contributor 2011 Award,

it is a great great pleasure & honour to announce that today I have been awarded with the Microsoft Most Valuable Professional Award as of July 2011, in the field of SharePoint Server 2010!

This means I am the first SharePoint MVP in South Tyrol and one of only a hand full in Italy!

It is awarded by Microsoft for outstanding commitment and contributions in technical communities and it is an appreciation for the voluntary work of contributing to the community.

I am really enjoying having received this award and I’m looking forward to be contributing even more to the Microsoft SharePoint, and even more: to join the network of the MVPs worldwide. Currently, there are 4,000+ MVPs in 90 countries worldwide, and about 180 German-speaking MVPs, among which I am (plus Italian & English 😉 ).

 

It is a great motivation to carry on like this, and I’m looking forward to contribute many more times! Thanks to the community, and thanks to Microsoft!

 

Now I’m looking forward to 2 weeks of holidays in Calabria, Italy and will check back with all of you on July, 18th.

 

Best regards,

Martin

Read Full Post »

Foto: fotolia.com/kentoh

Foto: fotolia.com/kentoh

 

Dear all,

Today a new article of mine was released on the online presence of the German magazine “Computerwoche”.

 

It’s title is: “Vom BI-Trödler zum Klassenprimus”

A recent research study has revealed there is a lot of potential how businesses perform when it comes to data management. Clearly, there is a connection between how well a business organizes its data and also cleaning routines, as well as organizing a centralized BI center. SharePoint 2010 can deliver these features which are needed for improving such a business. The articles shows strategies and best practices to improve from poorly performing to best in class companies.

 

You can find the full article here:

http://www.computerwoche.de/software/bi-ecm/2367976/

Read Full Post »